mybatis-plus分页查询

 1.这里另外使用了swagger依赖哦，不用去掉即可

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;

@Data
@ApiModel(value = "分页请求参数")
public class DemoReqAttributePage extends DemoReqAttribute {
    private static final long serialVersionUID = 1L;

    @ApiModelProperty("分页-当前页")
    private volatile int current;

    @ApiModelProperty("分页-每页条数")
    private volatile int pageSize;

}

@Data
@ApiModel(value = "请求参数封装")
public class DemoReqAttribute implements Serializable {
    private static final long serialVersionUID = 1L;

}

@RestController
@RequestMapping("/demo")
@Api(value = "swagger折叠框", tags = "swagger标签")
public class DemoController extends BaseController {

    @ApiOperation(value = "列表分页查询", notes = "列表分页查询")
    @PostMapping(value = "/getListPage")
    public RestResponse<IPage<DemoBasic>> getDemoListPage(@RequestBody DemoReqAttributePage model) {
        
        Page<DemoBasic> queryPage = new Page<>(model.getCurrent() , model.getPageSize());

        IPage<DemoBasic> list = demoService.getListPage(queryPage, model);
        
        return RestResponse.success(list);
    }
}

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mti.ultd.common.dynamic.datasource.core.service.MtiPlusService;

public interface DemoService extends MtiPlusService<DemoMapper, DemoBasic> {

    /**
     * 分页查询列表
     * @return
     */
    IPage<DemoBasic> getListPage(Page page, DemoReqAttribute model);

}

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class DemoServiceImpl extends MtiPlusServiceImpl<DemoMapper, DemoBasic>
        implements DemoService {

    @Autowired
    private DemoMapper demoMapper;

    @Override
    public IPage<DemoBasic> getListPage(Page page, DemoReqAttribute model) {
        QueryWrapper wrapper = new QueryWrapper<DemoBasic>();
        wrapper.le("time", model.getTimeJssj());
        wrapper.orderByDesc("time");//time字段倒序排序
        IPage<DemoBasic> demoIPage = demoMapper.selectPage(page , wrapper);
        return demoIPage;
    }
}

import com.mti.ultd.common.dynamic.datasource.core.mapper.MtiPlusBaseMapper;
import org.apache.ibatis.annotations.Select;

public interface DemoMapper extends MtiPlusBaseMapper<DemoBasic> {

    //可自定义SQL
    @Select("select field1, field2 from tableName limit 10")
    List<Map<String, Object>> selectDIYLIST();
    //也可通过mybatis配置xml
    List<Map<String, Object>> selectxmllist();
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.....mapper.DemoMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="baseResultMap" type="com.....entity.DemoBasic">
        <id column="id" property="id" />
        <result column="field1" property="field1" />
        <result column="field2" property="field2" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id,field1,field2,time
    </sql>
    <select id="selectxmllist">

    </select>

</mapper>