基于mybatis中的分页查询功能

最新推荐文章于 2024-07-18 18:15:00 发布

lhylww

最新推荐文章于 2024-07-18 18:15:00 发布

阅读量263

点赞数

分类专栏： IDEA 文章标签： java

本文链接：https://blog.csdn.net/lhylww/article/details/101534090

版权

IDEA 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

基于mybatis中的分页查询功能

核心映射文件（mybatis-config.xml）

<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- 配置属性文件信息   -->
    <properties resource="jdbc.properties"></properties>
    <!-- 设置信息   -->
    <settings>
        <!--  是否使用标签名替代列名      -->
        <setting name="useColumnLabel" value="true"/>
    </settings>
    <!-- 类型别名设置：简化映射文件中resultType值的设置   -->
    <typeAliases>
    <!--        <typeAlias type="com.softeem.mybatis.entity.Student" alias="student"></typeAlias>-->
    <package name="com.softeem.mybatis6.entity"/>
    </typeAliases>
<!-- 添加分页插件   -->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    </plugins>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
<!--        <mapper class="com.softeem.anno.mapper.StudentMapper"/>-->
        <mapper resource="mapper/StudentMapper.xml"/>
    </mappers>
</configuration>

实体类

  private int id;
    private String sname;
    private String sex;
    private int age;
    private Date birth;
    private Department dept;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public Date getBirth() {
        return birth;
    }

    public void setBirth(Date birth) {
        this.birth = birth;
    }

    public Department getDept() {
        return dept;
    }

    public void setDept(Department dept) {
        this.dept = dept;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", sname='" + sname + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", birth=" + birth +
                ", dept=" + dept +
                '}';
    }
}

mapper层

public interface StudentMapper {
/**分页查询方法*/
List<Student> selectAll2();
}

service层

/**
     * 分页查询
     * @param pageNow   当前页
     * @param pageSize   每页记录数
     */
    public PageInfo<Student> queryByPage(int pageNow,int pageSize){
        SqlSession session = MybatisUtils.getSession();
        StudentMapper mapper = session.getMapper(StudentMapper.class);
        //设置分页
        PageHelper.startPage(pageNow,pageSize,"age");
        //执行查询
        List<Student> list = mapper.selectAll2();
        for (Student s:list) {
            System.out.println(s);
        }
        //根据集合构建pageInfo对象（包含分页的一切信息）
        PageInfo<Student> page = new PageInfo<>(list);
        return page;
    }

测试层

public class StudentServiceTest {

 /**分页查询*/
    @Test
    public void queryByPage(){
        StudentService service = new StudentService();
        PageInfo<Student> page = service.queryByPage(2, 3);
        System.out.println(page);
    }
}

结果预览

"C:\Program Files\Java\jdk1.8.0_101\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.2\lib\idea_rt.jar=59158:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.2\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.2\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.2\plugins\junit\lib\junit-rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.2\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_101\jre\lib\rt.jar;C:\Users\Administrator\IdeaProjects\javaee\out\test\mybatis06_sql;C:\Users\Administrator\IdeaProjects\javaee\out\production\mybatis06_sql;C:\Users\Administrator\Desktop\pagehelper-5.1.6.jar;C:\Users\Administrator\Desktop\jsqlparser-1.2.jar;C:\Users\Administrator\Desktop\mybatis\log4j-1.2.16.jar;C:\Users\Administrator\Desktop\mybatis\mybatis-3.5.2.jar;C:\Users\Administrator\Desktop\mybatis\mysql-connector-java-5.1.46.jar;C:\Users\Administrator\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\Administrator\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.softeem.mybatis6.service.StudentServiceTest,queryByPage

DEBUG [main] - ==>  Preparing: SELECT count(0) FROM student s, department d WHERE s.dno = d.dno 
DEBUG [main] - ==> Parameters: 
TRACE [main] - <==    Columns: count(0)
TRACE [main] - <==        Row: 7
DEBUG [main] - <==      Total: 1
DEBUG [main] - ==>  Preparing: SELECT s.id, s.sname, s.sex, s.age, s.birth, d.dno, d.dept_name, d.dept_tel, d.dept_summary FROM student s, department d WHERE s.dno = d.dno order by age LIMIT ?, ? 
DEBUG [main] - ==> Parameters: 3(Integer), 3(Integer)
TRACE [main] - <==    Columns: id, sname, sex, age, birth, dno, dept_name, dept_tel, dept_summary
TRACE [main] - <==        Row: 6, 德玛西亚, 男, 19, 2019-09-24, 1002, 机电学院, 10001, 罗汉学院
TRACE [main] - <==        Row: 3, 马尔咋哈, 男, 25, 2018-12-10, 1002, 机电学院, 10001, 罗汉学院
TRACE [main] - <==        Row: 1, 小甜甜, 男, 28, 2019-09-02, 1001, 计算机学院, 10086, 全院都是黑客
DEBUG [main] - <==      Total: 3
Student{id=6, sname='德玛西亚', sex='男', age=19, birth=Tue Sep 24 00:00:00 CST 2019, dept=Department{dno=1002, deptName='机电学院', deptTel='10001', deptSummary='罗汉学院'}}
Student{id=3, sname='马尔咋哈', sex='男', age=25, birth=Mon Dec 10 00:00:00 CST 2018, dept=Department{dno=1002, deptName='机电学院', deptTel='10001', deptSummary='罗汉学院'}}
Student{id=1, sname='小甜甜', sex='男', age=28, birth=Mon Sep 02 00:00:00 CST 2019, dept=Department{dno=1001, deptName='计算机学院', deptTel='10086', deptSummary='全院都是黑客'}}
PageInfo{pageNum=2, pageSize=3, size=3, startRow=4, endRow=6, total=7, pages=3, list=Page{count=true, pageNum=2, pageSize=3, startRow=3, endRow=6, total=7, pages=3, reasonable=false, pageSizeZero=false}[Student{id=6, sname='德玛西亚', sex='男', age=19, birth=Tue Sep 24 00:00:00 CST 2019, dept=Department{dno=1002, deptName='机电学院', deptTel='10001', deptSummary='罗汉学院'}}, Student{id=3, sname='马尔咋哈', sex='男', age=25, birth=Mon Dec 10 00:00:00 CST 2018, dept=Department{dno=1002, deptName='机电学院', deptTel='10001', deptSummary='罗汉学院'}}, Student{id=1, sname='小甜甜', sex='男', age=28, birth=Mon Sep 02 00:00:00 CST 2019, dept=Department{dno=1001, deptName='计算机学院', deptTel='10086', deptSummary='全院都是黑客'}}], prePage=1, nextPage=3, isFirstPage=false, isLastPage=false, hasPreviousPage=true, hasNextPage=true, navigatePages=8, navigateFirstPage=1, navigateLastPage=3, navigatepageNums=[1, 2, 3]}