网络留言板1

来源：互联网发布：域名 cc 编辑：程序博客网时间：2024/06/10 02:02

项目功能：
用户可以输入留言，查看留言
用户输入提交后，会进行页面跳转，如果留言不成功，则单击“”添加新留言“超链接，如果留言成功，则单击“查看所有留言内容”超链接。
项目所需核心文件：
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 stubrequest.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 stubString 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 exceptione.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>

运行 addMessage.jsp 浏览器中输入http://localhost:8080/guestbook/addMessage.jsp

0 0