在【SpringBoot攻略六、集成mybatis实战】基础上做如下修改:
pom.xml
我们删除mybatis-spring-boot-starter和pagehelper-spring-boot-starter依赖。
新增依赖:
<!-- mybatis plus -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
application.properties
去掉mybatis和pagehelper的配置项
新增配置项:
#mybatis plus
mybatis-plus.configLocation=classpath:mybatis/mybatis-config.xml
mybatis-plus.mapperLocations=classpath*:/mybatis/**/*Mapper.xml
mybatis-plus.typeAliasesPackage=com.javasgj.springboot.mybatisplus.domain
mybatis-plus.typeAliasesSuperType=com.javasgj.springboot.mybatisplus.domain.BaseEntity
mybatis-config.xml
新增分页插件:
<plugins>
<!-- mybatisplus分页拦截器 -->
<plugin interceptor="com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor">
</plugin>
</plugins>
好了,开始实战
mybatisplus开发指南:https://mp.baomidou.com/
1、创建实体类
Pagination:
package com.javasgj.springboot.mybatisplus.domain;
import com.alibaba.fastjson.annotation.JSONField;
import com.baomidou.mybatisplus.annotation.TableField;
/**
* 分页工具类
*/
public class Pagination {
/**
* 当前页码
*/
@TableField(exist = false)
@JSONField(serialize = false)
protected int pageIndex;
/**
* 每页大小
*/
@TableField(exist = false)
@JSONField(serialize = false)
protected int pageSize;
public int getPageIndex() {
return pageIndex;
}
public void setPageIndex(int pageIndex) {
this.pageIndex = pageIndex;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
}
BaseEntity:
package com.javasgj.springboot.mybatisplus.domain;
import java.util.Date;
import com.alibaba.fastjson.annotation.JSONField;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
/**
* 基础实体类
*/
public class BaseEntity extends Pagination {
// 主键
@TableId(type=IdType.UUID)
protected String id;
// 创建人
protected String cjrId;
protected String cjr;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
protected Date cjSj;
// 更新人
protected String gxrId;
protected String gxr;
@JSONField(format = "yyyy-MM-dd HH:mm:ss")
protected Date gxSj;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getCjrId() {
return cjrId;
}
public void setCjrId(String cjrId) {
this.cjrId = cjrId;
}
public String getCjr() {
return cjr;
}
public void setCjr(String cjr) {
this.cjr = cjr;
}
public Date ge