引入依赖
<dependencies>
<!--MyBatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<!--PageHelper依赖 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.2.0</version>
</dependency>
<!-- mysql jdbc -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.18</version>
<scope>provided</scope>
</dependency>
</dependencies>
只使用注解映射时
核心配置文件要将该类导入
<mappers>
<!--使用注解方式配置映射文件关系,加载接口文件路径,或者存放接口文件的包名-->
<!-- <mapper class="com.mapper.UserMapper"/>-->
<package name="com.mapper"/>
</mappers>
核心配置文件配置PageHelper
<!--pagehelper分页插件-->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
</plugins>
Mapper层
public interface UserMapper {
@Select("select * from user where sex = #{user.sex} and age = #{user.age}")
public List<User> queryByPageWithPlugin(@Param("user") User user);
}
Test
public class Test1 {
public static void main(String[] args) {
SqlSession session = MybatisUtil.getSession();
UserMapper userMapper = session.getMapper(UserMapper.class);
User user = new User();
user.setSex(1);
user.setAge(20);
//使用分页插件进行查询,注意:在使用PageHelper.startPage方法时,后面要紧跟查询代码
//自动拦截后边紧跟的第一条SQL语句进行分页查询。
PageHelper.startPage(1, 10);//第一个参数为页数,第二个参数为每页的数量
// PageHelper.offsetPage(0,10);//第一参数是第几条数据,第二个参数为取多少个数据
//此处不能有其他无关查询代码
//封装分页的内容
List<User> list = userMapper.queryByPageWithPlugin(user);
PageInfo pageInfo = new PageInfo(list);
for (User u :list) {
System.out.println(u);
}
System.out.println(pageInfo);
/* PageInfo<Object> info = PageHelper.startPage(1, 10).doSelectPageInfo(new ISelect() {
public void doSelect() {
userMapper.queryByPageWithPlugin(user);
}
});
Page<Object> objects = PageHelper.startPage(1, 10).doSelectPage(new ISelect() {
public void doSelect() {
userMapper.queryByPageWithPlugin(user);
}
});*/
session.close();
}
}
注意:在使用PageHelper.startPage方法时,后面要紧跟查询代码