使用Criteira对Hibernate进行分页查询

Hibernate

（1）创建Page类

public class HibernatePage {
    private Integer pageT;//当前页
    private Integer pageSize;//每页的记录数
    private Integer rowsNum;//总记录数：
    private Integer pageNum;//总页数：

    public Integer getPageT() {
        return pageT;
    }

    public void setPageT(Integer pageT) {
        this.pageT = pageT;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }

    public Integer getRowsNum() {
        return rowsNum;
    }

    public void setRowsNum(Integer rowsNum) {
        this.rowsNum = rowsNum;
    }

    public Integer getPageNum() {
        return pageNum;
    }

    public void setPageNum(Integer pageNum) {
        this.pageNum = pageNum;
    }
}

（2）创建实体类

这里创建实体类User

package com.sw.bean;

import java.io.Serializable;

/**
 * Created by shaowei on 2021/5/10.
 */
public class User implements Serializable {
    private Integer id;
    private String username;
    private String password;
    private String sex;
    private Integer age;
    private Group group;
    private IdCard idCard;

    public User(){}

    public User(String o1, String o2){
        this.username = (String)o1;
        this.password = (String)o2;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", group=" + group +
                ", idCard=" + idCard +
                '}';
    }

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getSex() {
        return sex;
    }

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

    public Integer getAge() {
        return age;
    }

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

    public Group getGroup() {
        return group;
    }

    public void setGroup(Group group) {
        this.group = group;
    }

    public IdCard getIdCard() {
        return idCard;
    }

    public void setIdCard(IdCard idCard) {
        this.idCard = idCard;
    }
}

（3）创建表t_user

（4）编写测试程序

public class MainTest {
    @Test
    public void mainT(){
        Configuration configure = new Configuration().configure();
        SessionFactory sessionFactory = configure.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();

        try{
            configure = new Configuration().configure();
            sessionFactory = configure.buildSessionFactory();
            session = sessionFactory.openSession();
            transaction = session.beginTransaction();

            HibernatePage page = new HibernatePage();
            page.setPageT(1);
            page.setPageSize(5);
            Criteria criteria = session.createCriteria(User.class);
            Integer pageT = page.getPageT();
            Integer pageSize = page.getPageSize();
            criteria.setFirstResult((pageT-1)*pageSize);
            criteria.setMaxResults(pageSize);
            List<User> list = criteria.list();
            list.forEach(System.out::println);

            transaction.commit();
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            session.close();
            sessionFactory.close();
        }
    }
}

（5）结果