10.2框架知识_mybatis#Spring + Mybatis 使用 PageHelper 插件分页

最新推荐文章于 2023-03-14 17:49:34 发布

panyu_SMD

最新推荐文章于 2023-03-14 17:49:34 发布

阅读量437

点赞数 1

分类专栏： mybatis 文章标签： spring mybatis maven

本文链接：https://blog.csdn.net/panyu_smd/article/details/62037866

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本文介绍了如何在Spring Mybatis项目中整合PageHelper分页插件，包括添加maven依赖、配置mybatis-config.xml、配置Spring的sqlSessionFactory，以及在测试代码中使用PageHelper进行分页查询的示例。

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

先增加maven依赖:

[html] view plain copy print ?

<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.0.0</version>
</dependency>

创建mybatis配置文件:mybatis-config.xml内容:

[html] view plain copy print ?

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="oracle"/>
<property name="offsetAsPageNum" value="true"/>
<property name="rowBoundsWithCount" value="true"/>
<property name="pageSizeZero" value="true"/>
<property name="reasonable" value="true"/>
<property name="params" value="pageNum=start;pageSize=limit;"/>
<property name="supportMethodsArguments" value="true"/>
<property name="returnPageInfo" value="check"/>
</plugin>
</plugins>
</configuration>

在Spring配置中配置sqlSessionFactory的时候引入配置文件

[html] view plain copy print ?

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:joker/itq/im/mapping/*.xml" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>

测试代码:

[java] view plain copy print ?

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration({"classpath*:/spring-mybatis.xml"})
public class MyBatiasTest {
@Resource
private ColumnMapper columnMapper;
@Test
public void test(){
PageHelper.startPage(1, 20); // 核心分页代码
List<Column> cls = columnMapper.selectAll();
for (Column column : cls) {
System.out.println(column.getBrcoName());
}
}
}

----------------------------------------------------------------------------------------------------------

实例：

----------------------------------------------------------------------------------------------------------

service：

public PageResult<JzCaseVo> pageList(PageParam pageParam, JzCaseVo searchVo) {
    //列排序
    if (StringUtils.isNotEmpty(pageParam.getColumnSort())) {
        searchVo.setOrderByClause( pageParam.getColumnSort());
    }
    //开始分页查询，注意：紧跟在下面这一行代码之后的第一个查询才会进行分页
    PageHelper.startPage(pageParam.getPage(), pageParam.getRows());
    //获取案例作者
    List<JzCaseVo> pageList = jzCaseSelfMapper.selectPageList(searchVo);
    if (null!=pageList&&pageList.size()>0){
        for (JzCase jzCaseVo : pageList){
            JzBaseInfoDraft baseInfoDarft = jzBaseInfoDraftMapper.getRealNameByDesignerId( jzCaseVo.getDesignerId());
            if (baseInfoDarft!= null){
                jzCaseVo.setDesigner(baseInfoDarft.getRealName());
            }
        }
    }
    //构造分页信息
    PageInfo pageInfo = new PageInfo(pageList);
    //构造分页结果
    PageResult<JzCaseVo> pageResult = PageResult.newPage(pageList, pageInfo.getTotal(), pageInfo.getPages(), pageInfo.getPageNum());
    return pageResult;
}

查询页面传入s参数类定义：

public class PageParam implements Serializable {

    private static final long serialVersionUID = -7047857825792876554L;

    /**
     * 当前页
     */
    private int page;
    /**
     * 每页显示记录数
     */
    private int rows;

    /**
     * 排序字段
     */
    private String sidx;

    /**
     * 排序方式 asc desc
     */
    private String sord;

    /**
     * 列排序 = 排序字段 + 排序方式
     */
    private String columnSort;

    private Integer offset;
    private Integer limit;

    public int getPage() {
        return page;
    }

    public void setPage(int page) {
        this.page = page;
    }

    public int getRows() {
        return rows;
    }

    public void setRows(int rows) {
        this.rows = rows;
    }

    public String getSidx() {
        return sidx;
    }

    public void setSidx(String sidx) {
        this.sidx = sidx;
    }

    public String getSord() {
        return sord;
    }

    public void setSord(String sord) {
        this.sord = sord;
    }

    public String getColumnSort() {
        if (StringUtils.isNotEmpty(this.sidx)) {
            this.columnSort = this.sidx + " " + this.sord;
        }
        return columnSort;
    }

    public void setColumnSort(String columnSort) {
        this.columnSort = columnSort;
    }

    public Integer getOffset() {
        return offset = offset == null ? (page - 1) * rows : offset;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getLimit() {
        return limit = limit == null ? this.rows : limit;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }
}

分页结果类：

public class PageResult<T> implements Serializable {

    private static final long serialVersionUID = -7710168010225904920L;

    /**
     * 数据列表
     */
    private List<T> rows;
    /**
     * 总记录数
     */
    private long records;
    /**
     * 总页数
     */
    private int total;
    /**
     * 当前页
     */
    private int page;

    public PageResult() {
    }

    public PageResult(List<T> rows, long records, int total, int page) {
        this.rows = rows;
        this.records = records;
        this.total = total;
        this.page = page;
    }

    public static <T> PageResult<T> newPage(List<T> rows, long records, int total, int page) {
        return new PageResult<T>(rows, records, total, page);
    }

    public static <T> PageResult<T> newPageResult(List<T> rows, long records, int pageNo,int pageSize) {
        int totalPages = (int) (records % pageSize == 0 ? records / pageSize : records / pageSize + 1);
        return new PageResult<T>(rows, records, totalPages, pageNo);
    }

    public List<T> getRows() {
        return rows;
    }

    public void setRows(List<T> rows) {
        this.rows = rows;
    }

    public long getRecords() {
        return records;
    }

    public void setRecords(long records) {
        this.records = records;
    }

    public int getTotal() {
        return total;
    }

    public void setTotal(int total) {
        this.total = total;
    }

    public int getPage() {
        return page;
    }

    public void setPage(int page) {
        this.page = page;
    }
}