<!-- spring boot pagehelper分页需要引入三个包 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
<version>1.2.5</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
-----------------配置文件--------------
#mybatis对应实体类
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.dt.domain
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
pagehelper.returnPageInfo=check
----------------mapper----------
@Mapper
public interface UserMapper {
int insert(User user);
List<User> find();
}
---------------service---------------
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public int addUser(User user) {
return userMapper.insert(user);
}
/*
* 这个方法中用到了我们开头配置依赖的分页插件pagehelper
* 很简单,只需要在service层传入参数,然后将参数传递给一个插件的一个静态方法即可; pageNum 开始页数 pageSize
* 每页显示的数据条数
*/
@Override
public PageInfo<User> findAllUser(int pageNum, int pageSize) {
// 将参数传给这个方法就可以实现物理分页了,非常简单。
PageHelper.startPage(pageNum, pageSize);
List<User> userDomains = userMapper.find();
PageInfo result = new PageInfo(userDomains);
return result;
}
}