基于javaweb+mysql的jsp+servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat)

基于javaweb+mysql的jsp+servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

发表留言，查看留言，回复留言，查看回复，删除留言(管理员)

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript

基于javaweb+mysql的JSP+Servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat)

				}
			}
			String idString=request.getParameter("id");
			int id=Integer.parseInt(idString);
			message.setId(id);
			try {
   
				message.delete(message);
				response.sendRedirect("MessageServlet?type=query");
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}else if(type.equals("queryOne")){
   
			User info = (User) request.getSession().getAttribute("info");
			if(info==null){
   
				request.getSession().setAttribute("info","查看留言请登录");
				response.sendRedirect("fail.jsp");
				return;
			}
			try {
   
				Message one = message.queryOne(getId);
				request.getSession().setAttribute("message",one);
				response.sendRedirect("detail.jsp");
			} catch (SQLException throwables) {
   
				throwables.printStackTrace();
			}
		}
	}

}

    public UserServlet() {
   
        super();
        // TODO Auto-generated constructor stub
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
   
        doPost(req, resp);

    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {
   
        User user = new User();
        //登录
        String userName = null;
        userName = request.getParameter("text_username_login");
        String passWord = request.getParameter("text_password_login");
        request.setCharacterEncoding("utf-8");
        //如果 用户名 或者密码 或者 验证码为 空，就返回
        if (userName == null || passWord == null)
            return;
        //如果 用户名 或者密码 或者 验证码为 空字符串，就返回
        if (userName == "" || passWord == "")
            return;

        // 进行了编码转换，以便支持中文用户名
        userName = new String(userName.getBytes("ISO-8859-1"), "UTF-8");
        try {
   
            ArrayList<User> users = user.queryAll();
            for (User user1 : users) {
   
                if (user1.getUsername().equals(userName) && user1.getPassword().equals(passWord)) {
   
                    //传给前端得数据
                    request.getSession().setAttribute("info", user1);
                    resp.sendRedirect("MessageServlet?type=query");
                    return;
                }
            }
            request.getSession().setAttribute("info", "账号或者密码错误");
            resp.sendRedirect("fail.jsp");
        } catch (SQLException throwables) {
   
            throwables.printStackTrace();
        }
    }
}

				}
			}
			String idString=request.getParameter("id");
			int id=Integer.parseInt(idString);
			message.setId(id);
			try {
   
				message.delete(message);
				response.sendRedirect("MessageServlet?type=query");
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}else if(type.equals("queryOne")){
   
			User info = (User) request.getSession().getAttribute("info");
			if(info==null){
   
				request.getSession().setAttribute("info","查看留言请登录");
				response.sendRedirect("fail.jsp");
				return;
			}
			try {
   
				Message one = message.queryOne(getId);
				request.getSession().setAttribute("message",one);
				response.sendRedirect("detail.jsp");
			} catch (SQLException throwables) {
   
				throwables.printStackTrace();
			}
		}
	}

}

public class ReplyServlet extends HttpServlet {
   

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        request.setCharacterEncoding("utf-8");
        String mid = request.getParameter("mid");
        String type=request.getParameter("type");
        System.out.println("type:"+type);
        Reply reply=new Reply();
        if(type.equals("reply")){
   
            User info = (User) request.getSession().getAttribute("info");
            if(info==null){
   
                request.getSession().setAttribute("info","留言请登录");
                response.sendRedirect("fail.jsp");
                return;
            }
            String reusername=request.getParameter("reusername");
            String recontent=request.getParameter("recontent");
            reply.setReUsername(reusername);
            reply.setReContent(recontent);
            reply.setMid(Integer.parseInt(mid));
            try {
   
                reply.add(reply);
                response.sendRedirect("show.jsp");
            } catch (SQLException e)