jsp+servlet+javabean实现简易留言板（包含数据库文件）

package com.ser; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.bean.Message; /** * 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 type=request.getParameter("type"); System.out.println("type:"+type); Message message=new Message(); if(type.equals("add")){ String title=request.getParameter("title"); String content=request.getParameter("content"); message.setTitle(title); message.setContent(content); //stu.setName(name); 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<Message> messages=new ArrayList<Message>(); 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")){ 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(); } } } }