Mybatis-Plus官網測試用例

//Spring boot方式 @Configuration @MapperScan("com.baomidou.cloud.service.*.mapper*") public class MybatisPlusConfig {@Beanpublic PaginationInterceptor paginationInterceptor() {PaginationInterceptor paginationInterceptor = new PaginationInterceptor();// 設置請求的頁面大于最大頁后操作， true調回到首頁，false 繼續請求 默認false// paginationInterceptor.setOverflow(false);// 設置最大單頁限制數量，默認 500 條，-1 不受限制// paginationInterceptor.setLimit(500);// 開啟 count 的 join 優化,只針對部分 left joinpaginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));return paginationInterceptor;} }

2. 調整修改后的代碼 MyBatisPlusConfig.java

/*** @FileName: MyBatisPlusConfig* @Author Steven* @Date: 2020/12/29*/ @EnableTransactionManagement @MapperScan("com.macro.cloud.mapper") @Configuration public class MyBatisPlusConfig {@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor(){MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();PaginationInnerInterceptor innerInterceptor=new PaginationInnerInterceptor();innerInterceptor.setDbType(DbType.MYSQL);innerInterceptor.setOverflow(true);interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());interceptor.addInnerInterceptor(innerInterceptor);return interceptor;}@Beanpublic ConfigurationCustomizer configurationCustomizer(){return mybatisConfiguration -> mybatisConfiguration.setUseGeneratedShortKey(false);} }

實體類 User.java

/*** @FileName: User* @Author Steven* @Date: 2020/12/28*/ @Data @AllArgsConstructor @NoArgsConstructor public class User {/*** 對應數據庫中的主鍵*/@TableId(type = IdType.AUTO)private Long id;private String name;private Integer age;private String email;/*** 字段添加填充內容*/@TableField(fill= FieldFill.INSERT)private Date createTime;@TableField(fill = FieldFill.INSERT_UPDATE)private Date updateTime;/*** 樂觀鎖注解@Version*/@Versionprivate Integer version;@TableLogic(value = "0",delval = "1")@TableField(fill=FieldFill.INSERT)private Integer deleteFlag; }

3.映射類:UserMapper.java

public interface UserMapper extends BaseMapper<User>{ }

UserController.java

RequestMapping("user") @Controller @Api(tags = "用戶管理") public class UserController {@AutowiredUserMapper userMapper;/****/@ApiOperation("分頁查詢")@ResponseBody@GetMapping("/getUsers")public Page<User> getUsers(@RequestParam int current,@RequestParam int size){Page<User> page=new Page<>(current,size);Page<User> userPage = userMapper.selectPage(page, null);return userPage;}}

測試結果
{
“records”: [
{
“id”: 1,
“name”: “Jone”,
“age”: 18,
“email”: “test1@baomidou.com”,
“createTime”: “2020-12-29T23:50:05.000+00:00”,
“updateTime”: “2020-12-29T23:50:05.000+00:00”,
“version”: 0,
“deleteFlag”: 0
},
{
“id”: 2,
“name”: “Jack”,
“age”: 20,
“email”: “test2@baomidou.com”,
“createTime”: “2020-12-29T23:50:05.000+00:00”,
“updateTime”: “2020-12-29T23:50:05.000+00:00”,
“version”: 0,
“deleteFlag”: 0
},
{
“id”: 3,
“name”: “Tom”,
“age”: 28,
“email”: “test3@baomidou.com”,
“createTime”: “2020-12-29T23:50:05.000+00:00”,
“updateTime”: “2020-12-29T23:50:05.000+00:00”,
“version”: 0,
“deleteFlag”: 0
}
],
“total”: 9,
“size”: 3,
“current”: 1,
“orders”: [],
“optimizeCountSql”: true,
“hitCount”: false,
“countId”: null,
“maxLimit”: null,
“searchCount”: true,
“pages”: 3
}

總結

以上是生活随笔為你收集整理的SpringBoot整合Mybatis-Plus分页失效，Mybatis-Plus 3.4.1分页插件失效踩坑的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。