项目功能:
用户可以输入留言,查看留言
用户输入提交后,会进行页面跳转,如果留言不成功,则单击“”添加新留言“超链接,如果留言成功,则单击“查看所有留言内容”超链接。
项目所需核心文件:
addMessage.jsp //接受留言内容的jsp文件
AddMessageServlet.java//添加留言内容到数据库的Servlet
GetMessageServlet.java//显示留言内容的Servlet
Eclipse项目名称: guestbook
数据库:数据库名zn , 表名book , 字段有 name email phone title content publishtime
数据库构建路径: 在Libraries中 和 web-inf下的lib中引入 mysql的JDBC驱动的jar文件
addMessage.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form id="form1" method="post" action="/guestbook/zn/AddMessageServlet" name="form1">
姓名:<input type="text" name="name" ><br>
E-mail:<input type="text" name="email"><br>
电话:<input type="text" name="phone"><br>
主题:<input type="text" name="title"><br>
内容:<textarea rows="6" cols="60" name="content">大家好</textarea>
<input type="submit" name="submit" value="提交">
<input type="reset" name="reset" value="重置">
</form>
</body>
</html>
AddMessageServlet.java
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out=response.getWriter();
String driver ="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/zn";
String username="root";
String password="123456";
String sql="insert into book(name,email,phone,title,content,publishtime) values(?,?,?,?,?,?)";
Connection conn=null;
int result=0;
String name=request.getParameter("name");
String title=request.getParameter("title");
String email= request.getParameter("email");
String phone=request.getParameter("phone");
String content=request.getParameter("content");
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String publishtime=sdf.format(new java.util.Date());
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,username,password);
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2,email);
pstmt.setString(3, phone);
pstmt.setString(4, title);
pstmt.setString(5,content );
pstmt.setString(6, publishtime);
result=pstmt.executeUpdate();
pstmt.close();
conn.close();
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
// TODO: handle exception
}
if(result==0){
out.print("对不起,留言不成功,请您重新输入!<br>");
out.print("name:"+name+"<br>");
out.print("email:"+email+"<br>");
out.print("phone:"+phone+"<br>");
out.print("title:"+title+"<br>");
out.print("content:"+content+"<br>");
out.print("publishtime:"+publishtime+"<br>");
out.print("<a href='/guestbook/addMessage.jsp'>添加新的留言</a><br>");
}else{
out.print("成功添加留言。<br>");
out.print("<a href='/guestbook/zn/GetMessageServlet'>查看所有留言内容</a><br>");
}
}
GetMessageServlet.java
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/zn";
String name="root";
String pwd="123456";
String sql="select * from book";
Connection conn=null;
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.print("留言内容<br>");
try{
Class.forName(driver);
conn=DriverManager.getConnection(url,name,pwd);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.println("---") ;
this.printRow(out, rs);
}
rs.close();
conn.close();
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
}
private void printRow(PrintWriter out, ResultSet rs) throws SQLException {
out.print("姓名:" + rs.getString("name")+"<br>");
out.print("E-mail:" + rs.getString("email")+"<br>");
out.print("电话:" + rs.getString("phone")+"<br>");
out.print("主题:" + rs.getString("title")+"<br>");
out.print("内容:" + rs.getString("content")+"<br>");
out.print("时间:" + rs.getString("publishtime")+"<br>");
}
web.xml
<servlet>
<servlet-name>addm</servlet-name>
<servlet-class>zn.AddMessageServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>addm</servlet-name>
<url-pattern>/zn/AddMessageServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>getm</servlet-name>
<servlet-class>zn.GetMessageServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>getm</servlet-name>
<url-pattern>/zn/GetMessageServlet</url-pattern>
</servlet-mapping>