2023.07.29----springboot项目分页操作

最新推荐文章于 2024-05-19 18:50:29 发布

weixin_51554985

最新推荐文章于 2024-05-19 18:50:29 发布

阅读量45

点赞数

文章标签： spring boot 后端 java

本文链接：https://blog.csdn.net/weixin_51554985/article/details/131994077

版权

添加依赖

<dependencies>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.12</version>
        </dependency>

        <dependency>
            <groupId>cn.wwh.cloud.vehicle</groupId>
            <artifactId>driver-server-api</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>cn.wwh.cloud.vehicle</groupId>
            <artifactId>illrecord-server-api</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.0</version>
        </dependency>
    </dependencies>

@Mapper
public interface IllrecordsMapper {

   @Select("select * from car_record LEFT JOIN illcode on car_record.icode=illcode.icode order by crid asc")
    public List<Record> query();

}

@Override
    public PageInfo<Record> queryPageInfo(Integer pageNum,Integer pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        //List<Record> recordList = illrecordsMapper.query(new RowBounds((pageNum - 1) * pageSize, pageSize));
        List<Record> recordList = illrecordsMapper.query();

        PageInfo<Record> recordPageInfo = new PageInfo<>(recordList);
        List<Record> juhe = juhe(recordList);
        recordPageInfo.setList(juhe);
        return recordPageInfo;
    }