基于j2ee+mysql留言板系统

package popeyelin; import java.sql.*; import java.io.PrintWriter; import javax.servlet.http.HttpServletResponse; public class messageList{ int page; int count; public void setPage(int page) { try{ Class.forName("org.gjt.mm.mysql.Driver"); } catch (ClassNotFoundException e) { System.out.println("驱动没有找到！"); } this.page=page; } public void Display(HttpServletResponse response) { try { response.setContentType("text/HTML;GBK"); PrintWriter out=response.getWriter(); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root","123"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select count(*) from messagebook"); rs.next(); this.count=rs.getInt(1); int first=count-(page-1)*3; int last=count-page*3; PreparedStatement pstmt=con.prepareStatement("select * from messagebook where uid>=? and uid<=? group by uid"); pstmt.setInt(1, last); pstmt.setInt(2, first); rs=pstmt.executeQuery(); rs.afterLast(); while(rs.previous()){ out.print("留言人："); out.print(rs.getString("name")); out.print("<br>"); out.print("电子邮件"); out.print("<a href=mailto:"); out.print(rs.getString("email")); out.print(">"); out.print(rs.getString("email")); out.print("</a>"); // out.print("来自："+rs.getString("ip")+"留言于"+rs.getString("exactpost")); out.print("<br>"); out.print("他说"); out.print(rs.getString("content")+"<br>"+"<br>"); } rs.close(); } catch (Exception e) { System.out.println(e.toString()); } } public boolean hasnext(){ if (count>page*3) return true; else { return false; } } }