MyBatis实现简单的分页

wuaji

　　//Mapper接口
// #　标准的替代　　$等量替代　${sort} ${order}
@Select("select * from t_user where (username like #{name} or password like #{name}) order by ${sort} ${order} limit #{pageOffset},#{pageSize} ")
public List<User> findAll(Map<String, Object> map);
@Select("select count(*) from t_user where (username like #{name} or password like #{name})")
public int findCount(Map<String, Object> map);
//Dao
　　 int pageSize = SystemContext.getPageSize();
int pageOffset = SystemContext.getPageOffset();
String order = SystemContext.getOrder();
String sort = SystemContext.getSort();
SqlSession sqlSession = null;
Pager<User> pages = new Pager<User>();
try {
sqlSession = MyBatisUtil.createSession();
Map<String, Object> params = new HashMap<String, Object>();
params.put("name", "%" + name + "%");
params.put("pageSize", pageSize);
params.put("pageOffset", pageOffset);
params.put("order", order);
params.put("sort", sort);
List<User> datas = sqlSession.getMapper(UserMapper.class).findAll(
params);
pages.setDatas(datas);
pages.setPageOffset(pageOffset);
pages.setPageSize(pageSize);
int count = sqlSession.getMapper(UserMapper.class)
.findCount(params);
pages.setTotalRecord(count);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
MyBatisUtil.closeSession(sqlSession);
}