MyBatis-Plus单表分页

 

1. orderNO（排序用的）：是前台传过来的，根据orderNO（类似下标）找到前台定义好的数据库字段
2. order（排序用的）：根据orderNO（类似下标）找到前台定义好的数据库字段
3. orderdir（排序用的：是asc   还是desc）
4. 前台还传了userName  模糊查询

/**
	 * 前台传递的URL：/users/usersPage
	 * 
	 * @param param
	 * @param request
	 * @return
	 */
	@ResponseBody
	@GetMapping(value = "/usersPage")
	public ResponseData usersPage(SearchParam param,String userName, HttpServletRequest request) {
		logger.info("usersPage ...........");
		String orderNO = request.getParameter("order[0][column]");
		String order = request.getParameter("columns[" + orderNO + "][name]");
		String orderdir = request.getParameter("order[0][dir]");
		
		EntityWrapper<User> ew = new EntityWrapper<>();
		ew.like("user_name", userName).orderBy(order, "asc".equals(orderdir) ? true : false);

		Page<User> pageDate = userService.selectPage(new Page<User>(param.getStart(), param.getLength()), ew);

		return responseData(param.getDraw(), pageDate);
	}

package cn.com.befery.dataai.controller;

import org.springframework.stereotype.Controller;

import com.baomidou.mybatisplus.plugins.Page;

import cn.com.befery.dataai.vo.ResponseData;

@Controller
public class BaseController {

    /**
     * 
     * @param draw 重构次数
     * @param page 分页数据
     * @return
     */
    public ResponseData responseData(String draw,Page<?> page){
    	ResponseData res = new ResponseData();
    	res.setData(page.getRecords());
    	res.setDraw(draw);
    	res.setRecordsFiltered((int)page.getTotal());
    	res.setRecordsTotal((int)page.getTotal());
    	return res;
    }
}

省去get set方法 

package cn.com.befery.dataai.vo;

import java.util.List;

//@JsonInclude(Include.NON_NULL) 
public class ResponseData {
    
	/**
	 * 
	 */
//	private static final long serialVersionUID = 1L;
	
	private String draw;
	
	private int recordsTotal;
	
	private int recordsFiltered;
	
	@SuppressWarnings("rawtypes")
	private List data;
}