【无标题】idea分页查询（其中有JsonFromat实体类和OutPutJson实体类）

public void pageFind(HttpServletRequest request, HttpServletResponse response) {
        int page=request.getParameter("page")!=null?Integer.valueOf(request.getParameter("page")):1;
        int limit=request.getParameter("limit")!=null?Integer.valueOf(request.getParameter("limit")):1;
        JsonFromat success=hospitialService.pageFind(page,limit);
        OutPutJson.OutPutWriter(success,response);

    }

public JsonFromat pageFind(int page, int limit) {
        System.out.println(page+" "+limit);
        String sql="select * from hospitial ";
        JsonFromat jsonFromat=JsonFromat.success();
        jsonFromat.setCount(DBUtil.getCount(sql));
        System.out.println("jsonFromat"+jsonFromat);
        int pageCount =jsonFromat.getCount()%limit==0?(jsonFromat.getCount()/limit):(jsonFromat.getCount()/limit)+1;
        System.out.println(pageCount);
        if(page<1){
            page=1;
        }else if(page>pageCount){
            page=pageCount;
        }
        System.out.println(page);
        int startIndex =(page-1)*limit;
        System.out.println(page);
        List<Map> list =DBUtil.query(sql.concat("limit "+startIndex+","+limit));
        jsonFromat.setData(list);
        return jsonFromat;
    }

public static int getCount(String sql,Object...obj) {
        List<Map>list=DBUtil.query("select count(*) num from ("+ sql +") t",obj);
        if(list!=null&&list.size()>0){
            return Integer.valueOf(list.get(0).get("num").toString());
        }
        return 0;
    }

public class OutPutJson {
    public static void OutPutWriter(Object data, HttpServletResponse response){
        String json = JSON.toJSONString(data);
        PrintWriter pw =null;
        try {
            pw=response.getWriter();
            pw.write(json);
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            if (pw!=null){
                pw.close();
            }
        }
    }
}

package cn.hp.util;

import lombok.Data;

import java.util.List;
import java.util.Map;
@Data
public class JsonFromat {
   private Integer code;
   private  String msg;
   private Integer count;
   private Object data;

    public JsonFromat(Integer code, String msg) {
        this.code = code;
        this.msg = msg;
    }

    public JsonFromat(Integer code, String msg, Integer count, Object data) {
        this.code = code;
        this.msg = msg;
        this.count = count;
        this.data = data;
    }

    //成功的
    public static JsonFromat success(Integer code, String msg, Integer count, Object data) {
        return new JsonFromat(code, msg, count, data);
    }
    //传状态码说明和返回的数据
    public static JsonFromat success(String msg,Object data) {
        return success(200, msg, 0, data);
    }
    public static JsonFromat success(String mag) {
        return success(200, mag, 0, null);
    }
    public static JsonFromat success(Object data) {
        return success(200, "", 0, data);
    }
    public static JsonFromat success(Integer code) {
        return success(code, null, null, null);
    }
    public static JsonFromat success() {
        return success(200, null, null, null);
    }

    //失败的
    public static JsonFromat error(Integer code,String msg) {
        return new JsonFromat(code, msg);
    }
    public static JsonFromat error() {
        return new JsonFromat(505,null);
    }

}