1.pom文件
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.hlkj</groupId>
<artifactId>springboot_mybatisForPagehelper</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.0.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.10</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
</dependency>
</dependencies>
</project>
2、实体类如下:
@Data
public class Person {
private String pid;
private String pname;
}
3、mapper类如下
public interface PersonMapper {
@Select("select * from person")
List<Person> findPersonList();
}
4、service类如下
@Service
public class PersonService {
@Autowired
private PersonMapper personMapper;
public PageInfo<Person> findPersonList(int page,int pageSize){
PageHelper.startPage(page,pageSize);//底层实现原理改写语句
List<Person> lists=personMapper.findPersonList();
PageInfo<Person> pageInfoUserList=new PageInfo<Person>(lists);
return pageInfoUserList;
}
}
5、controller类如下
@RestController
public class PersonController {
@Autowired
private PersonService personService;
@RequestMapping("index")
public PageInfo<Person>index(int page,int pageSize){
return personService.findPersonList(page, pageSize);
}
}
7、测试类如下
@SpringBootApplication
@MapperScan("com.hlkj.mapper")
public class PagehelperTest {
public static void main(String[] args) {
SpringApplication.run(PagehelperTest.class, args);
}
}
8、application.properties如下
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
logging.level.com.example.demo.dao=DEBUG
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
pagehelper.page-size-zero=true