Oracle使用MyBatis中RowBounds实现分页查询功能_oracle_

 package com.xyfer.service.impl; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.ibatis.session.RowBounds; import com.xyfer.dao.UserDao; import com.xyfer.service.UserService; public class UserServiceImpl implements UserService { private UserDao userDao; @Override public Map queryUserList(String currentPage, String pageSize) { //查询数据总条数 int total = userDao.queryCountUser(); //返回结果集 Map resultMap = new HashMap(); resultMap.put("total", total); //总页数 int totalpage = (total + Integer.parseInt(pageSize) - 1) / Integer.parseInt(pageSize); resultMap.put("totalpage", totalpage); //数据的起始行 int offset = (Integer.parseInt(currentPage)-1)*Integer.parseInt(pageSize); RowBounds rowbounds = new RowBounds(offset, Integer.parseInt(pageSize)); //用户数据集合 List> userList = userDao.queryUserList(rowbounds); resultMap.put("userList", userList); return resultMap; } }

 package com.xyfer.dao; import java.util.List; import java.util.Map; import org.apache.ibatis.session.RowBounds; public interface UserDao { public int queryCountUser(); //查询用户总数 public List> queryUserList(RowBounds rowbounds); //查询用户列表 }

 select count(1) from user  select * from user