分页查询例子
Mybatis分页插件PageHelper的使用
排序要自己实现
Mybatis,Order By排序问题
[url]http://blog.csdn.net/hu_zhiting/article/details/53026448[/url]
mybatis的#{}和${}的区别以及order by注入问题
[url]http://www.cnblogs.com/yanspecial/p/5659429.html[/url]
Spring Data JPA
Spring Data JPA: 分页和排序
[url]https://www.cnblogs.com/nicuty/p/6265303.html[/url]
[url]http://blog.csdn.net/ie8848520/article/details/8161986[/url]
[url]http://blog.csdn.net/dragonpeng2008/article/details/52252907[/url]
直接获取Pageable对象
多个字段排序
Mybatis分页插件PageHelper的使用
public PageInfo<Goods> findByPage(Goods goods, Date createtimeStart, Date createtimeEnd, int pageNo, int pageSize) {
PageHelper.startPage(pageNo, pageSize);
Map m = ObjAnalysis.ConvertObjToMap(goods);
List<Goods> goodsList = goodsMapper.getAll(m);
PageInfo<Goods> PageInfGoods = new PageInfo<>(goodsList);
return PageInfGoods;
}
排序要自己实现
Mybatis,Order By排序问题
[url]http://blog.csdn.net/hu_zhiting/article/details/53026448[/url]
mybatis的#{}和${}的区别以及order by注入问题
[url]http://www.cnblogs.com/yanspecial/p/5659429.html[/url]
Spring Data JPA
Spring Data JPA: 分页和排序
public Page<Blog> getEntryByParams(@RequestParam(value = "page", defaultValue = "0") Integer page,
@RequestParam(value = "size", defaultValue = "15") Integer size) {
Sort sort = new Sort(Direction.DESC, "id");
Pageable pageable = new PageRequest(page, size, sort);
return blogRepository.findAll(pageable);
}
[url]https://www.cnblogs.com/nicuty/p/6265303.html[/url]
[url]http://blog.csdn.net/ie8848520/article/details/8161986[/url]
[url]http://blog.csdn.net/dragonpeng2008/article/details/52252907[/url]
直接获取Pageable对象
@RequestMapping(value = "", method=RequestMethod.GET)
public Page<Blog> getEntryByPageable(@PageableDefault(value = 15, sort = { "id" }, direction = Sort.Direction.DESC)
Pageable pageable) {
return blogRepository.findAll(pageable);
}
多个字段排序
Order order2 = new Order(Direction.DESC, "age");
Order order3 = new Order(Direction.ASC, "pgrade");
Order order = new Order(Direction.DESC, "dnum");