• mybatis分页查询(limit分页、RowBounds分页)


    1、limit分页

    (1)mapper接口:

     List<Student> getStudentByLim(HashMap<String, Integer> map);

    (2)配置文件:

        <select id="getStudentByLim" resultType="pers.zhb.pojo.Student" parameterType="map">
            select * from student limit #{startIndex},#{pageSize}
        </select>

    (3)测试:

        @Test
        public void getStudentByLimTest(){
            SqlSession sqlSession= MybatisUtils.getSqlSession();
            StudentMapper studentMapper=sqlSession.getMapper(StudentMapper.class);
            HashMap<String,Integer> map=new HashMap<String, Integer>();
            map.put("startIndex",0);
            map.put("pageSize",3);
            List<Student> students= studentMapper.getStudentByLim(map);
            for(Student student:students){
                System.out.println(student);
            }
        }
    DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
    DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - Opening JDBC Connection
    DEBUG [main] - Created connection 1728790703.
    DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@670b40af]
    DEBUG [main] - ==>  Preparing: select * from student limit ?,? 
    DEBUG [main] - ==> Parameters: 0(Integer), 3(Integer)
    DEBUG [main] - <==      Total: 3
    Student{studentno='201811', sname='zhai', sex='男', birthday='1998-11-11', classno='80501', point='890', phone='1234567890', email='null', clas=null}
    Student{studentno='201812', sname='zhai2', sex='男', birthday='1998-11-11', classno='80601', point='893', phone='19837372533', email='null', clas=null}
    Student{studentno='201813', sname='zhai3', sex='男', birthday='1998-11-11', classno='80501', point='892', phone='19837372534', email='null', clas=null}

    2、RowBounds分页(了解,不建议使用)

    (1)接口:

    List<Student> getStudentByRowBounds();

    (2)配置文件:

        <select id="getStudentByRowBounds" resultType="pers.zhb.pojo.Student">
            select * from student
        </select>

    (3)测试:

        @Test
        public void getStudentByRowBoundsTest(){
            SqlSession sqlSession= MybatisUtils.getSqlSession();
            RowBounds rowBounds=new RowBounds(1,2);
            List<Student> students=sqlSession.selectList
                    ("pers.zhb.mapper.StudentMapper.getStudentByRowBounds",null,rowBounds);
            for (Student student : students) {
                System.out.println(student);
            }
            sqlSession.close();
        }
    DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
    DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
    DEBUG [main] - Opening JDBC Connection
    DEBUG [main] - Created connection 243745864.
    DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@e874448]
    DEBUG [main] - ==>  Preparing: select * from student 
    DEBUG [main] - ==> Parameters: 
    Student{studentno='201812', sname='zhai2', sex='男', birthday='1998-11-11', classno='80601', point='893', phone='19837372533', email='null', clas=null}
    Student{studentno='201813', sname='zhai3', sex='男', birthday='1998-11-11', classno='80501', point='892', phone='19837372534', email='null', clas=null}
    DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@e874448]
    DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@e874448]
    DEBUG [main] - Returned connection 243745864 to pool.

    使用RowBounds实现的分页是基于代码的,二limit实现的分页是基于sql的

    3、分页插件

    官网含有该插件的文档,里面有详细的步骤

     摘自:https://pagehelper.github.io/docs/

  • 相关阅读:
    Postman 接口数据生成
    python中获取中位数(搬来的)
    数据库域名配置
    每10秒执行定时任务/每5分钟执行一次(附crontab的常用的命令)
    MATCHED 用法
    leetcode279 Perfect Squares
    leetcode480 Sliding Window Median
    leetcode295 Find Median from Data Stream
    leetcode424 Longest Repeating Character Replacement
    leetcode209 Minimum Size Subarray Sum
  • 原文地址:https://www.cnblogs.com/zhai1997/p/12779074.html
Copyright © 2020-2023  润新知