网络留言板1

最新推荐文章于 2023-05-07 17:13:03 发布

zn505119020

最新推荐文章于 2023-05-07 17:13:03 发布

阅读量1k

点赞数

分类专栏： java相关

本文链接：https://blog.csdn.net/zn505119020/article/details/51620669

版权

java相关专栏收录该内容

66 篇文章 1 订阅

订阅专栏

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

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

zn505119020

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
网络留言板1

项目功能：用户可以输入留言，查看留言用户输入提交后，会进行页面跳转，如果留言不成功，则单击“”添加新留言“超链接，如果留言成功，则单击“查看所有留言内容”超链接。项目所需核心文件：addMessage.jsp //接受留言内容的jsp文件AddMessageServlet.java//添加留言内容到数据库的ServletGetMessageServlet.java//显示留
复制链接

扫一扫

专栏目录