Springboot整合mybatis实现分页

最新推荐文章于 2024-09-01 18:43:29 发布

qq_37431087

最新推荐文章于 2024-09-01 18:43:29 发布

阅读量321

点赞数 1

本文链接：https://blog.csdn.net/qq_37431087/article/details/95909657

版权

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