模糊分页、模糊查询分页

r囧r小猫 2023-10-11 22:03 207阅读 0赞

一、html页面

  • 分页

  • JS中代码

二、Controller层

1.接收jsp的查询条件参数，和当前页参数page

2.查询所有的学生信息

3.进行模糊条件查询

4.将pageinfo，所有部门 和查询条件存进model

5.跳转到展示页面

  • 首次打开该页面，加载的数据

    request.setCharacterEncoding(“utf-8”);

    1.     response.setContentType("text/html;charset=utf-8");
    2.     String query = request.getParameter("query");
    3.     //获取当前页
    4.     String pagesize =             request.getParameter("page")==null?"1":request.getParameter("page");
    6.     StudentService studentService = new StudentService();
    7.     Page page = new Page();
    8.     //给当前页赋值
    9.     page.setCurrentPage(Integer.parseInt(pagesize));
    10.     //分页信息
    11.     List<Student> studentList = studentService.getStudentList(query,page);
    12.     //获取总条数
    13.     int ssum = studentService.selStudentPageSize(query);
    14.     //设置总条数
    15.     page.setRecordTotal(ssum);
    16.     //内容
    17.     page.setContent(studentList);
    18.     request.setAttribute("query",query);
    19.     request.setAttribute("page",page);
    20.     request.getRequestDispatcher("/WEB-INF/pages/admin/admin-student.jsp").forward(request, response);

  • 点击首页，上一页，下一页之后，所显示的数据

    request.setCharacterEncoding(“utf-8”);

    1.     response.setContentType("text/html;charset=utf-8");
    2.     String pagesize = request.getParameter("page");
    3.     String query = request.getParameter("query");
    5.     StudentService studentService = new StudentService();
    6.     Page page = new Page();
    7.     //给当前页赋值
    8.     page.setCurrentPage(Integer.parseInt(pagesize));
    9.     //分页信息
    10.     List<Student> studentList = studentService.getStudentList(query,page);
    11.     //总条数
    12.     int ssum = studentService.selStudentPageSize(query);
    13.     page.setRecordTotal(ssum);
    14.     page.setContent(studentList);
    15.     request.setAttribute("query",query);
    16.     request.setAttribute("page",page);
    17.     request.getRequestDispatcher("/WEB-INF/pages/admin/admin-student.jsp").forward(request, response);

三、DAO层

  1. //获取所有的学生
  2.     public List<Student> getStudentList(String query, Page page) {
  3.         Connection con = null;
  4.         PreparedStatement pre = null;
  5.         ResultSet resultSet = null;
  6.         List<Student> res = new ArrayList<>();
  8.         try {
  9.             con = DBUtils.getConnection();
  10.             String sql = "SELECT * FROM tb_student LEFT JOIN tb_class on tb_student.cid=tb_class.id where 1=1";
  11.             if(query != null && !"".equals(query.trim())) {
  12.                 query = ParamsUtils.wrapper(query);
  13.                 sql += " and student_no like " + query + " or student_name like " + query;
  14.             }
  15.             sql += " limit ?,?";
  16.             pre = con.prepareStatement(sql);
  17.             //(当前页-1)*每页显示条数
  18.             pre.setInt(1, (page.getCurrentPage()-1)*page.getPageSize());
  19.             //每页大小
  20.             pre.setInt(2,page.getPageSize());
  21.             resultSet = pre.executeQuery();
  22.             while(resultSet.next()) {
  23.                 String studentNo = resultSet.getString("student_no");
  24.                 String studentName = resultSet.getString("student_name");
  25.                 String description = resultSet.getString("description");
  26.                 String idCard = resultSet.getString("id_card");
  27.                 Integer age = resultSet.getInt("age");
  28.                 Integer id = resultSet.getInt("id");
  29.                 Byte gender = resultSet.getByte("gender");
  30.                 String name = resultSet.getString("name");
  31.                 String year = resultSet.getString("year");
  32.                 String hobby = resultSet.getString("hobby");
  33.                 Date createTime = resultSet.getDate("create_time");
  34.                 Date updateTime = resultSet.getDate("update_time");
  35.                 Student student = new Student();
  36.                 student.setStudentNo(studentNo);
  37.                 student.setStudentName(studentName);
  38.                 student.setDescription(description);
  39.                 student.setIdCard(idCard);
  40.                 student.setAge(age);
  41.                 student.setGender(gender);
  42.                 student.setYear(year);
  43.                 student.setCreateTime(createTime);
  44.                 student.setUpdateTime(updateTime);
  45.                 Classs aClasss = new Classs();
  46.                 aClasss.setId(id);
  47.                 aClasss.setName(name);
  48.                 student.setHobby(hobby);
  49.                 student.setAclasss(aClasss);
  50.                 res.add(student);
  51.             }
  52.         } catch (SQLException e) {
  53.             // TODO Auto-generated catch block
  54.             e.printStackTrace();
  55.         }finally {
  56.             DBUtils.closeConnection(con, pre, resultSet);
  57.         }
  58.         return res;
  59.     }
  61. //获取学生总数
  62.     public int selStudentPageSize(String query) {
  63.         Connection con = null;
  64.         PreparedStatement pre = null;
  65.         ResultSet resultSet = null;
  67.         try {
  68.             con = DBUtils.getConnection();
  69.             String sql = "SELECT count(*) ssum FROM tb_student left join tb_class on tb_student.cid=tb_class.id where 1=1";
  71.             if(query != null && !"".equals(query.trim())) {
  72.                 query = ParamsUtils.wrapper(query);
  73.                 sql += " and student_no like " + query + " or student_name like " + query;
  74.             }
  75.             pre = con.prepareStatement(sql);
  77.             resultSet = pre.executeQuery();
  78.             while(resultSet.next()) {
  79.                 return resultSet.getInt("ssum");
  80.             }
  81.         } catch (SQLException e) {
  82.             // TODO Auto-generated catch block
  83.             e.printStackTrace();
  84.         }finally {
  85.             DBUtils.closeConnection(con, pre, resultSet);
  86.         }
  87.         return 0;
  88.     }

四、分页工具类

  1. package com.dayrain.utils;
  3. import java.util.List;
  5. /**
  6.  * 分页
  7.  *
  8.  */
  9. public class Page<T> {
  11.     /**
  12.      * currentPage 当前页
  13.      */
  14.     private int currentPage = 1;
  15.     /**
  16.      * pageSize 每页大小
  17.      */
  18.     private int pageSize = 3;
  19.     /**
  20.      * pageTotal 总页数
  21.      */
  22.     private int pageTotal;
  23.     /**
  24.      * recordTotal 总条数
  25.      */
  26.     private int recordTotal = 0;
  28.     /**
  29.      * content 每页的内容
  30.      */
  31.     private List<T> content;
  34.     public List<T> getContent() {
  35.         return content;
  36.     }
  38.     public void setContent(List<T> content) {
  39.         this.content = content;
  40.     }
  42.     public int getCurrentPage() {
  43.         return currentPage;
  44.     }
  46.     public void setCurrentPage(int currentPage) {
  47.         this.currentPage = currentPage;
  48.     }
  50.     public int getPageSize() {
  51.         return pageSize;
  52.     }
  54.     public void setPageSize(int pageSize) {
  55.         this.pageSize = pageSize;
  56.     }
  58.     public int getPageTotal() {
  60.         ///1   53%5   3     50%5   0
  61.          pageTotal = ((recordTotal%pageSize)==0)?(recordTotal/pageSize):((recordTotal/pageSize)+1) ;
  62.         return pageTotal;
  63.     }
  65. //    public void setPageTotal(int pageTotal) {
  66. //        this.pageTotal = pageTotal;
  67. //    }
  69.     public int getRecordTotal() {
  70.         return recordTotal;
  71.     }
  73.     public void setRecordTotal(int recordTotal) {
  74.         this.recordTotal = recordTotal;
  75.     }
  79.     @Override
  80.     public String toString() {
  81.         return "Page{" +
  82.                 "currentPage=" + currentPage +
  83.                 ", pageSize=" + pageSize +
  84.                 ", pageTotal=" + pageTotal +
  85.                 ", recordTotal=" + recordTotal +
  86.                 ", content=" + content +
  87.                 '}';
  88.     }
  89. }

五、页面效果

ff622944982f4b6ca07fed5ddf9bd2c6.gif

发表评论

表情：
评论列表 （有 0 条评论，207人围观）

还没有评论，来说两句吧...

相关阅读