1.pom.xml中添加配置
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.6</version>
</dependency>
2.启动类中添加配置
package com.lj;
import com.github.pagehelper.PageHelper;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.servlet.ServletComponentScan;
import org.springframework.context.annotation.Bean;
import java.util.Properties;
/**
* @author: luojie
* date: 2018/1/22 10:33
*/
@SpringBootApplication
@MapperScan("com.lj.mapper")
@ServletComponentScan("com.lj.servlet")
public class Application {
public static void main(String args[]) {
SpringApplication.run(Application.class, args);
}
@Bean
public PageHelper pageHelper() {
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("offsetAsPageNum", "true");
properties.setProperty("rowBoundsWithCount", "true");
properties.setProperty("reasonable", "true");
properties.setProperty("dialect", "mysql"); //配置mysql数据库的方言
pageHelper.setProperties(properties);
return pageHelper;
}
}
3.controller层
@RequestMapping(value = "getAll2")
public List<User> getAll2(){
return userService.findUserList(1,3);
}
4.service实现类
@Override
public List<User> findUserList(int currentPage, int pageSize){
PageHelper.startPage(currentPage,pageSize);
List<User> list=userMapper.findAll();
return list;
}
5.测试 http://localhost:8080/getAll2
成功,只出现了3条数据