方法一:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.2.1</version>
</dependency>
第一步配置:
@Configuration
public class PageHelperConfig {
//配置mybatis的分页插件pageHelper
@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;
}
}
第二部编码 :注意顺序
@GetMapping("/client")
public Result client() {
//一定要放在上面
PageHelper.startPage(1,2);
//一定要放在PageHelper.startPage下面,有顺序的,不然分页失效
List<Client> clients = clientService.selectAll();
PageInfo<Client> userPageInfo = new PageInfo<>(clients);
return ResultGenerator.genSuccessResult(userPageInfo);
}
下面未无用的配置(不用配置这个),没效果,测试过
另外一种配置
但是还是有时配置有问题,报错如下:
Unsatisfied dependency expressed through method 'sqlSessionFactoryBean' parameter 0; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Qualifier(value=dataSource)}
原因是数据源至少要注入一个配置,因为注入可能会失败,需要了解一些配置的问题,所以不太建议使用这种