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

}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);