mybaits 分页查询级返回结果集实现
2020-08-11 本文已影响0人
阿杰_96c5
代码实现
public QueryResponseResult myBookCourt(Integer id,int pageNum, int pageSize) {
//分页参数
if(pageNum <= 0){
pageNum = 1;
}
if(pageSize <= 0){
pageSize = 10;
}
// 分页插件查询 jdk8 lambda用法
PageInfo<BookCourt> pageInfo = PageHelper.startPage(pageNum, pageSize).doSelectPageInfo(
() ->
bookCourtMapper.selectBookCourtListByUserId(id.longValue())
);
// 封装查询结果
QueryResponseResult result = new QueryResponseResult(
CommonCode.SUCCESS,
new QueryResult()
.setTotal(pageInfo.getTotal())
.setList(pageInfo.getList()));
return result;
}
结果实体类
/**
* @ClassName: QueryResponseResult
* @description: 查询列表返回结果类
* @author: wangjie
* @time: 2020-06-27 16:37
*/
public class QueryResponseResult extends ResponseResult {
QueryResult queryResult;
public QueryResponseResult(ResultCode resultCode,QueryResult queryResult){
super(resultCode);
this.queryResult = queryResult;
}
public QueryResult getQueryResult() {
return queryResult;
}
public QueryResponseResult setQueryResult(QueryResult queryResult) {
this.queryResult = queryResult;
return this;
}
}
/**
* @ClassName: ResponseResult
* @description: 响应结果类
* @author: wangjie
* @time: 2020-06-27 16:37
*/
public class ResponseResult {
//操作是否成功
@ApiModelProperty(value = "执行结果成功标识 true:请求执行成功 false:请求执行失败", position = 1)
boolean success = true;
//操作代码
@ApiModelProperty(value ="执行结果代码",position = 2)
int code = 10000;
//提示信息
@ApiModelProperty(value ="执行结果提示信息",position = 3)
String message;
public ResponseResult() {
}
public ResponseResult(boolean success, int code, String message) {
this.success = success;
this.code = code;
this.message = message;
}
public ResponseResult(ResultCode resultCode){
this.success = resultCode.success();
this.code = resultCode.code();
this.message = resultCode.message();
}
public boolean isSuccess() {
return success;
}
public ResponseResult setSuccess(boolean success) {
this.success = success;
return this;
}
public int getCode() {
return code;
}
public ResponseResult setCode(int code) {
this.code = code;
return this;
}
public String getMessage() {
return message;
}
public ResponseResult setMessage(String message) {
this.message = message;
return this;
}
public static ResponseResult SUCCESS(){
return new ResponseResult(CommonCode.SUCCESS);
}
/**操作失败**/
public static ResponseResult FAIL(){
return new ResponseResult(CommonCode.FAIL);
}
/**权限不足,无权操作!**/
public static ResponseResult UNAUTHORISE(){
return new ResponseResult(CommonCode.UNAUTHORISE);
}
/**非法参数**/
public static ResponseResult INVALID_PARAM(){
return new ResponseResult(CommonCode.INVALID_PARAM);
}
/*抱歉,系统繁忙,请稍后重试!*/
public static ResponseResult SERVER_ERROR(){
return new ResponseResult(CommonCode.SERVER_ERROR);
}
}
public enum CommonCode implements ResultCode{
SUCCESS(true,10000,"操作成功!"),
LOGIN_SUCCESS(true,10000,"用户登录成功!"),
UNAUTHENTICATED(false,10001,"此操作需要登陆系统!"),
UNAUTHORISE(false,10002,"权限不足,无权操作!"),
INVALID_PARAM(false,10003,"非法参数!"),
FAIL(false,10003,"操作失败!"),
/****************************场地基础资料异常****************************/
/**场地管理返回码**/
NOT_FOND_COURT(false,2001,"场地不存在"),
COURT_HAS_EXISTED(false,2002,"场地已存在"),
/****************************场地价格资料异常****************************/
/*场地价格管理*/
NOT_FOND_PRICE(false,2101,"时段价格不存在"),
/****************************场地预定异常****************************/
HAS_BOOK(false,2201,"场地已被预定,请重新选择"),
ADD_BOOK_FAIL(false,2202,"场地预定,保存失败"),
/**错误返回码**/
SERVER_ERROR(false,99999,"抱歉,系统繁忙,请稍后重试!");
//操作是否成功
boolean success;
//操作代码
int code;
//提示信息
String message;
private CommonCode(boolean success,int code, String message){
this.success = success;
this.code = code;
this.message = message;
}
@Override
public boolean success() {
return success;
}
@Override
public int code() {
return code;
}
@Override
public String message() {
return message;
}
@Override
public String toString() {
return "CommonCode{" +
"success=" + success +
", code=" + code +
", message='" + message + '\'' +
'}';
}
}
public interface ResultCode {
//操作是否成功,true为成功,false操作失败
boolean success();
//操作代码
int code();
//提示信息
String message();
}