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
}