分页查询例子

分页查询例子


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");