下面是写的一个邮件
系统页面的分页,数据库可以根据情况改动, 已经测试过,仅供参考! 1.UserMail.java package com.softeem.user;
public class UserMail { private int id; //发件人 private String sender; //收件人 private String recipients; //主题 private String title; //内容 private String contents; //时间 private String times; //附件 private String upload; //邮件大小 private int sizes; //邮件类型:1为新邮件,2为收件箱,3为草稿箱,4为发件箱,5为
垃圾箱 private int types; //状态:1为已读,0为未读 private int status; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getSender() { return sender; } public void setSender(String sender) { this.sender = sender; } public String getRecipients() { return recipients; } public void setRecipients(String recipients) { this.recipients = recipients; }
public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getContents() { return contents; } public void setContents(String contents) { this.contents = contents; } public String getTimes() { return times; } public void setTimes(String times) { this.times = times; } public String getUpload() { return upload; } public void setUpload(String upload) {
this.upload = upload; } public int getSizes() { return sizes; } public void setSizes(int sizes) { this.sizes = sizes; } public int getTypes() { return types; } public void setTypes(int types) { this.types = types; } public int getStatus() { return status; } public void setStatus(int status) { this.status = status; } }
2.UserDAO.java /** *
查询收件箱中所有数据,分页显示 * @return */ public List
ListUserMail(int count){ List list = new ArrayList(); Connection conn = DBManager.getConnection(); //types为状态,表示收件箱 String sql = "select top 10 * from usersmail where types = '2' and (id not in (select top (10*(?-1)) id from usersmail where types='2'))" ; try { PreparedStatement pst = conn.prepareStatement(sql); pst.setInt(1,count); ResultSet rs = pst.executeQuery(); while(rs.next()){ UserMail user = new UserMail(); int id = rs.getInt("id"); int status = rs.getInt("status");
String upload = rs.getString("upload"); String sender = rs.getString("sender"); String title = rs.getString("title"); String times = rs.getString("times"); int sizes = rs.getInt("sizes");
user.setId(id); user.setStatus(status); user.setUpload(upload); user.setSender(sender); user.setTitle(title); user.setTimes(times); user.setSizes(sizes);
list.add(user); } } catch (SQLException e) { e.printStackTrace(); } return list; } 3.ListUserServlet.java
/** *新建一个 servlet,由 jsp 跳转到 servlet,用于分页 */ package com.softeem.servlet;
import java.io.IOException; import java.util.List;
import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.
servlet.http.HttpServletResponse;
import com.softeem.dao.UserDAO; import com.softeem.user.Count; import com.softeem.user.UserMail;
/** * Servlet implementation class ListUserServlet */ public class ListUserServlet extends HttpServlet { private static final long serialVersionUID = 1L;
/** * @see HttpServlet#HttpServlet() */ public ListUserServlet() { super(); // TODO Auto-generated constructor stub }
/** * @see HttpServlet#doGet(Htt