Mybatis+Oracle 分页
1,使用mybatis的插件PageHelper
(1)Mapper.xml
<?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">
<!-- namespace:填写的是监听的Mapper权限命名的接口 -->
<mapper namespace="cn.ssm.dao.StudentMapper">
<select id="selectUserinfo" resultType="cn.ssm.dao.bean.Userinfo">
select * from userinfo
</select>
</mapper>
(2)分页实现
public List<Userinfo> selectUserinfo() {
PageHelper.startPage(2, 3); //使用分页插件
List<Userinfo> userinfos =studentMapper.selectUserinfo();
PageInfo<Userinfo> infos=new PageInfo<Userinfo>(userinfos);
List<Userinfo> list = infos.getList();
return