SpringBoot2.1+MybatisPlus3.0.7简便分页语法

pom配置要点

    <properties>
          <mybatisplus.version>3.0.7.1</mybatisplus.version>
    </properties>
    <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatisplus.version}</version>
     </dependency>
     <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus</artifactId>
                <version>${mybatisplus.version}</version>
     </dependency>
     <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
    </dependency>
    

application.yml配置要点

# DataSource Config
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/mp?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&allowMultiQueries=true
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
server:
  port: 8080
mybatis-plus:
  #指明mapper.xml扫描位置(classpath 代表编译后类文件根目录)
  mapper-locations: classpath:/mapper/**Mapper.xml
# Logger Config
logging:
  level:
    com.baomidou.mybatisplus.samples: debug

用户表user

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  `email` varchar(20) DEFAULT NULL,
  `last_name` varchar(10) DEFAULT NULL,
  `data_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

实体类

@Data
@EqualsAndHashCode(callSuper=true)
@Accessors(chain = true)
@TableName(value = "t_user")
public class User extends Model<User> {
    @TableId(value = "id",type = IdType.AUTO)
    private Long id;

    private String name;
    private Integer age;
    private String email;
    @TableField(value = "last_name")
    private String lastName;
    @TableField(value="data_time")
    private Timestamp dataTime;

    @Override
    protected Serializable pkVal() {
        /**
         * AR 模式这个必须有，否则 xxById 的方法都将失效！
         * 另外 xxxMapper 也必须 AR 依赖该层注入，可有可无 XML
         */
        return this.id;
    }
}

Mapper接口

public interface UserMapper extends BaseMapper<User> {
}

分页插件配置类

@EnableTransactionManagement
@Configuration
@MapperScan("com.baomidou.mybatisplus.samples.crud.mapper")
public class MybatisPlusConfig {
    /**
     * 分页插件，自动识别数据库类型 多租户，请参考官网【插件扩展】
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor page = new PaginationInterceptor();
        page.setDialectType("mysql");
        return page;
    }
}

在Controller层直接分页演示

 @GetMapping("/page")
    public IPage<User> listPage(){
        //分页的简便语法。不用专门定义分页类。
        int current=1,size=3;
        IPage<User> page = new Page<>(current, size);
        LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
        wrapper.like(User::getName, "刘晓");
        wrapper.orderByDesc(User::getId);
        try {
            page = userMapper.selectPage( page, wrapper);
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println("Total: "+page.getTotal()+" ; Size: "+page.getSize()+" ; Current: "+page.getCurrent());
        return page;
    }

项目结构层级

借鉴苞米豆的sample例子，以及诸多网友的无私奉献的点点滴滴，揣摩出合适自己需要的语法糖。不用写sql，不用写xml。直接在java语句区间就可以看出业务逻辑。实际开发中java代码放在service.impl中，略加修改即可。

postman输出

测试正确输出预期结果。

{
    "records": [
        {
            "id": 11,
            "name": "刘晓5",
            "age": 51,
            "email": "xsb.lx@ch.com",
            "lastName": "阿弥陀佛",
            "dataTime": "2019-04-14T09:52:18.000+0000"
        },
        {
            "id": 10,
            "name": "刘晓",
            "age": 51,
            "email": "xsb.lx@ch.com",
            "lastName": "阿弥陀佛",
            "dataTime": null
        },
        {
            "id": 9,
            "name": "刘晓3",
            "age": 51,
            "email": "xsb.lx@ch.com",
            "lastName": "阿弥陀佛!",
            "dataTime": "2019-04-14T09:52:20.000+0000"
        }
    ],
    "total": 6,
    "size": 3,
    "current": 1,
    "searchCount": true,
    "pages": 2
}