分页生效需要配置分页拦截器
@Configuration
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
导入依赖
<!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.3.1</version>
</dependency>
Mapper
@Mapper
@Repository
public interface UserMapper extends BaseMapper<User> {
User findUserByName(String name);
IPage<User> customerUserPage(@Param("page") Page<User> page);
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.xx.security.mapper.UserMapper">
<select id="findUserByName" resultType="cn.xx.security.pojo.User">
select * from user where name=#{name}
</select>
<select id="customerUserPage" resultType="cn.xx.security.pojo.User">
select * from user where name != 'zhang'
</select>
</mapper>
Service
public interface UserService extends IService<User> {
User findUserByName(String name);
IPage<User> customerUserPage(@Param("page") Page<User> page);
}
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper,User> implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User findUserByName(String name) {
return userMapper.findUserByName(name);
}
@Override
public IPage<User> customerUserPage(Page<User> page) {
return userMapper.customerUserPage(page);
}
}