您的位置：首页 → 网页设计 → JSP实例 → 如何使用JSP+MySQL创建留言本三

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

时间：2004/11/7 3:39:00来源：本站整理作者：蓝点我要评论(0)

下面我们开始建立留言的页面！

<%@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的格式

}



%>

萍慧jsp留言薄

<%! 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);

                       

%>

留言成功,谢谢!

  

   

   

   

  

  

   

   

   

   

  

  

   

   

  

  

   

  

昵称：<%=username%>	性别：<%=sex%>	地址：<%=address %>
电话：<%=telnumber%>	邮编：<%=post%>	OICQ：<%=oicq%>	ICQ：<%=icq%>
Email：		网址：
留言：<%=comment%>     &nbsp;&nbsp;&nbsp;&nbsp;-<%=time %>（来自<%=ip %>）

---

<%

} catch (SQLException e) //写数据库失败

{ out.print ("留言失败");

  out.print (MyQuery);

  out.print (userid);

}

else

{

  out.print ("总共有"+testcomment.ErrorCount+"条错误数据,请修改!");

%>