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;
}
}
}
评论2