Shulou(Shulou.com)06/02 Report--

This article mainly introduces how to make a JSP message board, the article is very detailed, has a certain reference value, interested friends must read it!

I. JSP message board: create a database

1)。 Open Access2000 and create a new database, which I call foxdb.mdb, with C:\ tomcat\ fox\ global\ foxdb.mdb. Next, create a table in eagle.mdb, named foxtable, with five fields, all in text format:

"URL" is used to record the IP of the person who left the message. As for the length of each field, I set the "message" as 200 and the other four as 20.

2)。 Specify the ODBC data source, named foxdb, pointing to C:\ tomcat\ fox\ global\ foxdb.mdb.

2. JSP message board: write the user's message interface

Foxnote.html, which is stored in C:\ tomcat\ fox\ foxnote.html:

< html > < body > < form method= "post" action= "foxnoteinsert.jsp" > < br > name: < input name=username size=15value= "> < br > email: < input name=email size=15value=" > < br > message: < br > < textarea name=doc rows= "5" cols= "40" > < / textarea > < br > < input type=submit value= "submit" > < input type=reset value= "refill" > < / form > < / bocy > < / html >

Type http://ip/fox/foxnote.html in IE to see if it displays properly (ip is the ip address of your machine)

3. JSP message board: write foxnoteinsert.jsp

Write the user's message to the database table:

< body bgcolor= "# FFFFFF" > <% @ page import= "java.sql.*,MyUtil,java.util.*"% > <% Connection con=null; String username=MyUtil.gb2312ToUnicode (request.getParameter ("username")); String email=MyUtil.gb2312ToUnicode (request.getParameter ("email")); String doc=MyUtil.gb2312ToUnicode (request.getParameter ("doc")); String url=request.getRemoteAddr (); try {Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection ("jdbcdbc:foxdb", ") String str= "insert into foxtable values (,);"; PreparedStatement pstmt=con.prepareStatement (str); pstmt.setString (1jie username); pstmt.setString (2je email); pstmt.setString (3je doc); pstmt.setString (4jue url); pstmt.executeUpdate (); pstmt.close (); con.close ();} catch (Exception e) {out.println (e.getMessage ());}% >

There is something to be explained in this program, that is, a JavaBean: MyUtil.class is used.

The function of MyUtil is to convert between strings. It is important to note that the string in JSP is represented in Unicode, while the form in the message board interface is represented in gb2312. So writing the user's message into the database also requires code-to-code conversion. If the message is written directly to the database table without conversion, garbled code will be generated. The following is the original code of MyUtil, which is stored in C:\ tomcat\ fox\ WEB-INF\ classes\ MyUtil.java, and the compiled MyUtil.class file is also stored here.

Import java.io.*; public class MyUtil {public static String gb2312ToUnicode (String s) {try {return new String (s.getBytes ("ISO8859_1"), "gb2312");} catch (UnsupportedEncodingException uee) {return s;}} public static String unicodeTogb2312 (String s) {try {return new String (s.getBytes ("gb2312"), "ISO8859_1");} catch (UnsupportedEncodingException uee) {return;}

IV. JSP message board: writing foxnoteview.jsp

It is used to browse the existing messages in the database table and is stored in C:\ tomcat\ fox\ foxnoteview.jsp. The code is as follows:

< html > < body > <% @ page c language= "java" import= "java.sql.*"% > < Connection con=null; try {Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection ("jdbcdbc:foxdb", "", "); Statement statement=con.createStatement (); ResultSet rs=statement.executeQuery (" select * from foxtable ") % > < table border= "1" width= "100%" cellspacing= "0" cellpadding= "0" align= "center" bordercolorlight= "# CCCCFF" bordercolordark= "# FFFFFF" > < tr bgcolor= "# FFFFFF > < td width=" 15 "height=" 25 "align=" center "> < I > author < / I > < / td > < td width=" 28% "height=" 25 "align=" center "> < I > publication time < / I > < / td > < td width=" 22% " Height= "25" align= "center" > < I > Email < / I > < / td > < td width= "35%" height= "25" align= "center" > < I > message content < / I > < / td > <% while (rs.next ()) {out.println ("< TR > < td align=center > < font size=2color=#999999 >" + rs.getString ("author") + "< / TD >") Out.println ("< TD > < font size=2color=#999999 >" + rs.getString ("Email") + "< / font > < / TD >"); out.println ("< TD > < font size=2color=#999999 >" + rs.getString ("message") + "< / font > < / TD >"); out.println ("< TD > < font size=2color=#999999 >" + rs.getString ("URL") + "< / font > TD > < / TR >");} rs.close (); con.close () } catch (Exception e) {out.println (e.getMessage ());}% > < / table > < / body > < / html > these are all the contents of the article "how to make a JSP message board". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.