1、引用jar包
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
import org.apache.ibatis.plugin.Interceptor;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.apache.ibatis.plugin.Interceptor;
import org.mybatis.spring.SqlSessionFactoryBean;
import java.util.Properties;
2、spring 启动类注入pageHelper 相当于properties配置,可以不配置,使用默认足够。
public class WebApplication {
@Bean
public PageHelper pageHelper(){
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("reasonable", "true");
properties.setProperty("supportMethodsArguments", "true");
properties.setProperty("returnPageInfo", "check");
properties.setProperty("params", "count=countSql");
pageHelper.setProperties(properties);
//添加插件
new SqlSessionFactoryBean().setPlugins(new Interceptor[]{new PageInterceptor()});
return pageHelper;
}
}
3、Controller类 红色两个就够了
@RequestMapping(value = "/selectAll", method = {RequestMethod.POST,RequestMethod.GET})
public RemoteResult selectAll(@RequestBody PageHelperDto dto){
RemoteResult remoteResult = new RemoteResult();
PageHelper.startPage(Integer.parseInt(dto.getPageNum()), Integer.parseInt(dto.getPageSize()));
List<Object> appsList = service.selectAll();
PageInfo<Object> appsPageInfo = new PageInfo<>(appsList);
remoteResult.setResultObject(appsPageInfo);
return remoteResult;
}
4、service类
@Override
public List<Object> selectAll() {
List<Object> list = dao.selectAll();
return list;
}
5、Mapper
@Select("select * from table ")
List<Object> selectAll();
public class PageHelperDto {
private String pageSize;
private String pageNum;
public String getPageSize() {
return pageSize;
}
public void setPageSize(String pageSize) {
this.pageSize = pageSize;
}
public String getPageNum() {
return pageNum;
}
public void setPageNum(String pageNum) {
this.pageNum = pageNum;
}
}
是不是很简单,后边自己随意扩展,功能功能很强大,自己慢慢研究。