基于javaweb+mysql的jsp+servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat) |
您所在的位置：网站首页 › javaweb留言板代码 › 基于javaweb+mysql的jsp+servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat) |
基于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) * @see HttpServlet#HttpServlet() */ public MessageServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("lookreply")){ try { //留言的id String getId=request.getParameter("getId"); ArrayList replies=new ArrayList(); replies=reply.queryAll(Integer.parseInt(getId)); request.getSession().setAttribute("replies", replies); response.sendRedirect("lookreply.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public class UserServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public UserServlet() { super(); // TODO Auto-generated constructor stub } @Override e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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(); } } message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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")){ /** * Servlet implementation class Student */ public class MessageServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public MessageServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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(); } } } } reply.setReUsername(reusername); reply.setReContent(recontent); reply.setMid(Integer.parseInt(mid)); try { reply.add(reply); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("lookreply")){ try { //留言的id String getId=request.getParameter("getId"); ArrayList replies=new ArrayList(); replies=reply.queryAll(Integer.parseInt(getId)); request.getSession().setAttribute("replies", replies); response.sendRedirect("lookreply.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } public class UserServlet extends HttpServlet { private static final long serialVersionUID = 1L; User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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(); } } } } doPost(req,resp); } @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) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("lookreply")){ try { //留言的id String getId=request.getParameter("getId"); ArrayList replies=new ArrayList(); replies=reply.queryAll(Integer.parseInt(getId)); request.getSession().setAttribute("replies", replies); response.sendRedirect("lookreply.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); message.setUsername(((User)request.getSession().getAttribute("info")).getUsername()); try { message.add(message); response.sendRedirect("MessageServlet?type=query"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); /** * Servlet implementation class Student */ public class MessageServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public MessageServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String getId = request.getParameter("getId"); String type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","留言请登录"); response.sendRedirect("fail.jsp"); return; } String title=request.getParameter("title"); String content=request.getParameter("content"); String theme=request.getParameter("theme"); message.setTitle(title); message.setContent(content); message.setTheme(theme); message.setTime(String.valueOf(new Date())); e.printStackTrace(); } }else if(type.equals("query")){ try { ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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"); ArrayList messages=new ArrayList(); messages=message.queryAll(); request.getSession().setAttribute("messages", messages); response.sendRedirect("show.jsp"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }else if(type.equals("delete")){ User info = (User) request.getSession().getAttribute("info"); if(info==null){ request.getSession().setAttribute("info","删除留言请登录"); response.sendRedirect("fail.jsp"); return; }else{ if(!info.getGrade().equals("admin")){ request.getSession().setAttribute("info","非管理员不可删除"); response.sendRedirect("fail.jsp"); return; } } 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();
|
【本文地址】
今日新闻 |
推荐新闻 |