mybatis返回结果映射成ListMapString,Object

mybatis返回结果映射成List<MapString,Object>>
xml:

<select id="getProjectRate"  resultType="java.util.HashMap">
sql......
</select>

mapper:

List<Map<String, Object>> getProjectRate();

service:

@Override
    public List<Map<String, Object>> getProjectRate(){

        return monthlyReportMapper.getProjectRate();
    }

controller:

@RequestMapping(value = "/getProjectRate", method = {RequestMethod.GET})
    public JsonResult getProjectRate(){
        List<Map<String, Object>> list = monthlyReportService.getProjectRate();
        return new JsonResult(StatusCode.OK, list);
    }

返回结果:
在这里插入图片描述
所用到的依赖:

import com.alibaba.fastjson.JSONException;
import com.alibaba.fastjson.JSONObject;
/**
 * @author Wu zhiwei(Allen)
 * @Title:
 * @Description: 返回统一的json
 * @date 2018/10/12 10:28
 */
public class JsonResult<T> {

    private String code;
    private String message;
    private T data;

    public JsonResult() {
        this.setCode(StatusCode.OK);
        this.setMessage("成功!");
    }

    public JsonResult(StatusCode code) {
        this.setCode(code);
        this.setMessage(code.getMessage());
    }

    public JsonResult(StatusCode code, T data) {
        this.setCode(code);
        this.setMessage(code.getMessage());
        this.setData(data);
    }

    /*public JsonResult(StatusCode code, String message) {
        this.setCode(code);
        this.setMessage(message);
    }*/

    public JsonResult(StatusCode code, String message, T data) {

        this.setCode(code);
        this.setMessage(message);
        this.setData(data);

    }

    @Override
    public String toString() {

        JSONObject json = new JSONObject();
        try {
            json.put("code", code);
            json.put("message", message);
            json.put("data", data);
        } catch (JSONException e) {
            e.printStackTrace();
        }

        return json.toString();
    }

    public String getCode() {
        return code;
    }

    public void setCode(StatusCode code) {
        this.code = String.valueOf(code.getCode());
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public Object getData() {
        return data;
    }

    public void setData(T data) {
        this.data = data;
    }
}
  

public enum StatusCode {

    OK(200,"Successfully handle the request."),
    FAIL(-200,"Unsuccessfully handle the request."),
    DUPLICATE_RESOURCE(201,"duplicate resource"),
    PARAM_ERROR(400,"Request parameters error"),
    PERMISSON_DENIED(403,"Permission denied"),
    UNAUTHORIZED(407,"Need login"),
    INTERFACE_LEAPID_FAIL(408,"could not get data from leadip"),
    SERVER_ERROR(500,"Server internal error");

    private final int code;
    private final String message;

    private StatusCode(int code,String message){
        this.code = code;
        this.message = message;
    }
    public int getCode() {
        return code;
    }
    public String getMessage() {
        return message;
    }
}
  • 3
    点赞
  • 17
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值