如何使用JSP+MySQL创建留言本(三)


答案：下面我们开始建立留言的页面！ 
<%@page 
 import ="java.util.*" 
 import ="java.text.*" 
 import="java.sql.*" 
 import ="java.io.*" 
 import ="java.lang.*" 
 contentType="text/html; charset=gb2312" 
%> 
<% 
class CommentError// throws java.lang.NullPointerException 
{ public String Username="",Sex="",Address="",Postal="",Oicq="",Icq="",Tel="",Comment=""; 
 public boolean NoError=true;//false; 
 public int ErrorCount=0; 
 private boolean IsNumber(String s1) {} 
 public String font (String se) {} 
 public String Comment_Er(String se) {} 
 public void Username (String se) {} 
 public void Sex (String se) {} 
 public void Address (String se) {} 
 public void Comment (String se) {} 
 public void Tel (String se) {} 
 public void Postal (String se) {} 
 public void Oicq (String se) {} 
 public void Icq (String se) {} 
} 
class FormatComment 
{ public String Replace(String source, String oldString, String newString) {} 
 public String formatint(String se) {} 
 public String fromatcomment(String se) {} 
 public String toHtmlInput(String str) {} 
 public String toHtml(String str) {} 
 public String toSql(String str) {}//转换为可以加入Myqal的格式 
} 

%> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<meta name="GENERATOR" content="Microsoft FrontPage 4.0"> 
<meta name="ProgId" content="FrontPage.Editor.Document"> 
<title>使用MYsql数据库</title> 
</head> 

<body> 

<p align="center"><center><font style="COLOR: blue; FONT-FAMILY: 方正舒体,华文行楷,隶书,宋体; FONT-SIZE: 16pt">萍慧jsp留言薄</font></center></p> 
<p align="center"> 

<%! String username,sex,address,post,oicq,icq,telnumber,comment,email,url.urltitle; 
%> 
<% 
try{ username=request.getParameter("name"); 
 }catch (NullPointerException e){ username="";} 

try{ comment=request.getParameter("comment"); 
 }catch (NullPointerException e){ comment="";} 

try{ sex=request.getParameter("sex"); 
 }catch (NullPointerException e){ sex="";} 

try{ address=request.getParameter("address"); 
 }catch (NullPointerException e){ address="";} 

try{ post=request.getParameter("postal"); 
 }catch (NullPointerException e){ post="";} 

try{ oicq=request.getParameter("oicq"); 
 }catch (NullPointerException e){ oicq="";} 

try{ icq=request.getParameter("icq"); 
 }catch (NullPointerException e){ icq="";} 

try{ telnumber=request.getParameter("telphone"); 
 }catch (NullPointerException e) { telnumber= ""; } 
try{ email=request.getParameter("email"); 
 }catch (NullPointerException e) { email= ""; } 
try{ url=request.getParameter("url"); 
 }catch (NullPointerException e) { url= ""; } 
try{ urltitle=request.getParameter("urltitle"); 
 }catch (NullPointerException e) { urltitle= ""; } 

 String ip=request.getRemoteAddr();//得到IP地址                      
 String time=(new SimpleDateFormat ("yyyy-MM-dd hh:mm:ss", Locale.US )).format(new java.util.Date()); 
 String userid=""; 
 String MyQuery=""; 
此处我调用了一个对留言进行合法检验的类 
 CommentError testcomment= new CommentError(); 
 testcomment.Username(username);                      
 testcomment.Postal (post);                      
 testcomment.Sex(sex); 
 testcomment.Address(address); 
 testcomment.Tel(telnumber); 
 testcomment.Comment(comment);     
 testcomment.Oicq(oicq);    
 testcomment.Icq(icq); 

 if (testcomment.NoError) //留言中没有错误,写数据库                      
 try {//写数据库成功                      
  java.sql.Connection sqlConn; //数据库连接对象 
  java.sql.Statement sqlStmt; //语句对象 
  java.sql.ResultSet sqlRst; //结果集对象 
  //登记JDBC驱动对象 
  Class.forName ("org.gjt.mm.mysql.Driver").newInstance (); 
  //连接数据库 
  sqlConn= java.sql.DriverManager.getConnection ("jdbc:mysql://localhost/pinghui","test",""); 
  //创建语句对象 
  sqlStmt=sqlConn.createStatement (java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
  //执行Sql语句 
此处调用了一个对留言进行处理的类，是留言能被Mysql承认, 
  FormatComment FC= new FormatComment();                      
  oicq=FC.formatint(oicq);                      
  icq=FC.formatint(icq);                      
  post=FC.formatint(post);                      
  telnumber=FC.formatint(telnumber);         
  username=FC.toSql(username);         
  comment=FC.toSql(comment);         
  MyQuery="insert into comment (username,sex,address,ip,post,oicq,icq,telnumber,comment,time,url,email) values ('"+username+"','"+sex+"','"+address+"','"+ip+"',"+post+","+oicq+","+icq+",'"+telnumber+"','"+comment+"',now(),'"+url+"','"+email+"');"; 
  sqlRst=sqlStmt.executeQuery (MyQuery); //向数据库中加入数据 
   sqlRst.close();//关闭结果集对象 
  sqlStmt.close ();//关闭语句对象 
  sqlConn.close(); //关闭数据库连接 
  out.print (time); 

%> 
<font size="5" face="华文行楷">留言成功,谢谢!</font> 
<table border="0" cellpadding="0" cellspacing="0" width="100%"> 
 <tbody> 
  <tr> 
   <td width="25%">昵称：<%=username%></td> 
   <td width="25%">性别：<%=sex%></td> 
   <td colspan="2" width="50%">地址：<%=address %></td> 
  </tr> 
  <tr> 
   <td width="25%">电话：<%=telnumber%></td> 
   <td width="25%">邮编：<%=post%></td> 
   <td width="25%">OICQ：<%=oicq%></td> 
   <td width="25%">ICQ：<%=icq%></td> 
  </tr> 
  <tr> 
   <td colspan="2" width="50%">Email：<a href=>   <td colspan="2" width="50%">网址：<a href target="_blank"></a></td> 
  </tr> 
  <tr> 
   <td colspan="4"><font style="COLOR: green; LINE-HEIGHT: 150%">留言：</font><%=comment%><font style="COLOR: green; LINE-HEIGHT: 150%"><br> 
        -</font><%=time %><font style="COLOR: green; LINE-HEIGHT: 150%">（来自</font><%=ip %><font style="COLOR: green; LINE-HEIGHT: 150%">）</font></td> 
  </tr> 
 </tbody> 
</table> 
<hr color="#0080c0" noshade size="1" width="100%"> 

<% 
 } catch (SQLException e) //写数据库失败 
 { out.print ("<font color=red>留言失败</font>"); 
  out.print (MyQuery); 
  out.print (userid); 
 } 
 else 
 { 
  out.print ("<font color=red>总共有"+testcomment.ErrorCount+"条错误数据,请修改!</font>"); 
%> 

<script language="JavaScript"> 
<!-- <
上一个：jsp实现购物程序
下一个：JSP由浅入深(11)—— 标记库
更多图片编程知识: