Java PageHelper.startPage方法代码示例

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
@Override
public DataTablesResult getItemSearchList(int draw, int start, int length,int cid, String search,
                                          String minDate, String maxDate, String orderCol, String orderDir) {

    DataTablesResult result=new DataTablesResult();

    //分页执行查询返回结果
    PageHelper.startPage(start/length+1,length);
    List<TbItem> list = tbItemMapper.selectItemByMultiCondition(cid,"%"+search+"%",minDate,maxDate,orderCol,orderDir);
    PageInfo<TbItem> pageInfo=new PageInfo<>(list);
    result.setRecordsFiltered((int)pageInfo.getTotal());
    result.setRecordsTotal(getAllItemCount().getRecordsTotal());

    result.setDraw(draw);
    result.setData(list);

    return result;
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
@Override
public Map<String, Object> getSearchCategorySecondaryList(String sSearch, Integer sEcho, Integer iDisplayStart, Integer iDisplayLength) {

    HashMap<String, Object> map = new HashMap<>();
    int pageNum = iDisplayStart / iDisplayLength + 1;
    //System.out.println(pageNum);
    PageHelper.startPage(pageNum, iDisplayLength);

    TbCategorySecondaryExample example = new TbCategorySecondaryExample();
    TbCategorySecondaryExample.Criteria criteria = example.createCriteria();
    criteria.andNameLike("%" + sSearch + "%");

    List<TbCategorySecondary> list = categorySecondaryMapper.selectByExample(example);
    //System.out.println(list.size());
    PageInfo<TbCategorySecondary> pageInfo = new PageInfo<>(list);

    map.put("sEcho", sEcho + 1);
    map.put("iTotalRecords", pageInfo.getTotal());//数据总条数
    map.put("iTotalDisplayRecords", pageInfo.getTotal());//显示的条数
    map.put("aData", list);//数据集合

    return map;
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 订单查询(点击页面中的用户订单)
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/pageSearch_historyorder")
public PageData pageSearch_historyorder(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = orderManagementMapper.listPagehistoryorder(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 代理商未分派给陪诊人员,也没有分派给专家
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/assignToExpertAndAccompany")
public PageData assignToExpertAndAccompany(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = orderManagementMapper.assignToExpertAndAccompany(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
public ServerResponse<PageInfo> manageSearch(Long orderNo, int pageNum, int pageSize) {
    PageHelper.startPage(pageNum, pageSize);
    Order order = orderMapper.selectByOrderNo(orderNo);
    if (order != null) {
        List<OrderItem> orderItemList = orderItemMapper.getByOrderNo(orderNo);
        OrderVo orderVo = assembleOrderVo(order, orderItemList);

        PageInfo pageResult = new PageInfo(Lists.newArrayList(order));
        pageResult.setList(Lists.newArrayList(orderVo));
        return ServerResponse.createBySuccess(pageResult);
    }
    return ServerResponse.createByErrorMessage("订单不存在！");
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 订单查询中的订单详细信息
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/onumDesc")
public PageData onumDesc(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = hospitalGuideMapper.onumDesc(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 获取商品集合
 * @param pageNum 第几页
 * @param pageSize 每页多少个
 * @return
 */
public ServerResponse<PageInfo> manageProductList(Integer pageNum,Integer pageSize){
    PageHelper.startPage(pageNum,pageSize);
    List<Product> products = productMapper.selectList();
    List<ProductListVo> productListVos = Lists.newArrayList();
    for (Product productItem : products){
        productListVos.add(assembleProductListVo(productItem));
    }
    PageInfo pageInfo = new PageInfo(products);
    pageInfo.setList(productListVos);
    return ServerResponse.createBySuccess(pageInfo);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 订单查询中的代理商信息
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/spDesc")
public PageData spDesc(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = orderManagementMapper.spDesc(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 
 * @Description: 分页查询
 * @param pd
 * @return
 * @throws Exception    
 * @return PageData    
 * @throws
 */
@RequestMapping(value = "/pageSearch")
public PageData pageSearch(@RequestBody PageData pd) throws Exception{
	List<PageData> buttonList = null;
	if (pd.getPageNumber()!=0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	buttonList = buttonMapper.buttonlistPage(pd);;
	//分页
	pd=this.getPagingPd(buttonList);
	//结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
public List<User> getAll(String type, String value, int page) {
    Example example = new Example(User.class);
    Example.Criteria criteria = example.createCriteria();
    criteria.andLike(type, "%" + value + "%");
    PageHelper.startPage(page, Constant.PAGE_SIZE);
    return userMapper.selectByExample(example);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 订单查询中的评价星级信息
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/evallevelDesc")
public PageData evallevelDesc(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = orderManagementMapper.evallevelDesc(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
@Override
public List<City> getCitysByPage(Integer rows, Integer page) {
	PageHelper.startPage(page, rows);
	CityExample example = new CityExample();
	List<City> list = cityMapper.selectByExample(example);
	if (list.isEmpty()) {
		return new ArrayList<City>();
	}
	return list;
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 分页查询
 * 
 * @param pd
 *            查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/pageSearch")
public PageData pageSearch(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = activeGroupRelateMapper.listPage(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
/**
 * 订单查询(全部订单)
 * 
 * @param pd 查询、分页条件
 * @return
 * @throws Exception
 */
@RequestMapping(value = "/pageSearch_all")
public PageData pageSearch_all(@RequestBody PageData pd) throws Exception {
	List<PageData> lists = null;
	if (pd.getPageNumber() != 0) {
		PageHelper.startPage(pd.getPageNumber(), pd.getPageSize());
	}
	lists = orderManagementMapper.listPageAll(pd);
	// 分页
	pd = this.getPagingPd(lists);
	// 结果集封装
	return WebResult.requestSuccess(pd);
}
 

import com.github.pagehelper.PageHelper; //导入方法依赖的package包/类
@Override
public DataTablesResult getRemoveMemberList(int draw, int start, int length, String search,
                                            String minDate, String maxDate, String orderCol, String orderDir) {

    DataTablesResult result=new DataTablesResult();

    try{
        //分页执行查询返回结果
        PageHelper.startPage(start/length+1,length);
        List<TbMember> list = tbMemberMapper.selectByRemoveMemberInfo("%"+search+"%",minDate,maxDate,orderCol,orderDir);
        PageInfo<TbMember> pageInfo=new PageInfo<>(list);

        for(TbMember tbMember:list){
            tbMember.setPassword("");
        }

        result.setRecordsFiltered((int)pageInfo.getTotal());
        result.setRecordsTotal(getRemoveMemberCount().getRecordsTotal());

        result.setDraw(draw);
        result.setData(list);
    }catch (Exception e){
        throw new XmallException("加载删除用户列表失败");
    }

    return result;
}