MVC框架开发在线留言板

package servlet; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import db.DBUtil; import db.GuestBook; public class ListServlet extends HttpServlet { private static final long serialVersionUID = 6772075223587069854L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { DBUtil dbutil = new DBUtil(); String sql = "select * from guestbook"; ResultSet rs = dbutil.query(sql); List<GuestBook> list = new ArrayList<GuestBook>(); try { while (rs.next()) { GuestBook g = new GuestBook(); g.setId(rs.getInt("id")); g.setUser(rs.getString("user")); g.setTitle(rs.getString("title")); g.setContent(rs.getString("content")); g.setTime(rs.getString("time")); g.setIp(rs.getString("ip")); list.add(g); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { rs.close(); dbutil.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } request.setAttribute("list",list); request.getRequestDispatcher("show.jsp").forward(request, response); } }