DAO层实现分页的方法.代码作为记录.

最新推荐文章于 2020-07-18 01:11:24 发布

xuefei7

最新推荐文章于 2020-07-18 01:11:24 发布

阅读量5.3k

点赞数

文章标签： dao exception integer bean string list

本文链接：https://blog.csdn.net/xuefei7/article/details/6655027

版权

这篇博客展示了如何在后台使用PageDao类实现数据库分页查询。代码中包括了获取当前页数据、计算总页数、处理边界情况以及关闭JDBC资源的方法。在前端，通过JavaScript函数进行页面跳转和页码选择。QueryServlet处理请求，将分页数据传递到list.jsp页面展示。

摘要由CSDN通过智能技术生成

当初看到这个代码没有深入研究,为方便用了一简便的servlet端分页,导致很严重后果.

仅记录后台代码于此:

public class PageDao {

public PageDao() {
}

public List pageData(int currentPage, int pageCount) {
List results = new ArrayList();

  String tableName = "demo_userinfo_pages";
  ResultSet rs = null;
  StringBuffer sql = new StringBuffer("");
  Statement stmt = null;
  Connection conn = null;
  try {
   int count = recordCount();
   int totalPage = (int) Math.ceil(1.0 * count / pageCount);
   int start = 0;
   int end = 0;
   if (currentPage <= 0) {
    currentPage = 1;
    start = 1;
    end = currentPage * pageCount;
   }

   if (currentPage > totalPage) {
    currentPage = totalPage;
    return results;
   }
   if ((currentPage - 1) * pageCount >= 0) {
    start = (currentPage - 1) * pageCount + 1;
    end = currentPage * pageCount;
   }

   sql.append("SELECT * ").append("FROM (SELECT a.*,ROWNUM rn ")
     .append(" FROM (SELECT * ").append("  FROM " + tableName)
     .append("  ORDER BY   asc) a").append("  )").append(
       " WHERE rn >= " + start + " and rn <=" + end);

   conn = DBManager.getConnection();
   stmt = conn.createStatement();
   rs = stmt.executeQuery(sql.toString());
   while (rs.next()) {
    UserForm bean = new UserForm();