使用MyBatis-Plus实现分页
- 配置MyBatis-Plus分页插件
@Configuration
public class MyBatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
- 在Controller类中实现分页,用JSON返回给前端
@GetMapping("/queryAllProcess")
public JSONObject queryAllProcess(Long current,Long size){
JSONObject json = new JSONObject();
if (current==null || size==null){
json.put("success",0);
return json;
}
Page<Process> page = processService.page(new Page<Process>(current, size));
if (page==null){
json.put("success",0);
return json;
}
current = page.getCurrent();
List<Process> processes = page.getRecords();
long total = page.getTotal();
size = page.getSize();
long pages = page.getPages();
json.put("success",1);
json.put("current",current);
json.put("total",total);
json.put("size",size);
json.put("pages",pages);
json.put("processes",processes);
return json;
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)