EasyUi,hibernate后台分页

最新推荐文章于 2019-07-14 19:38:37 发布

wxhwangxiaohua

最新推荐文章于 2019-07-14 19:38:37 发布

阅读量220

点赞数 1

文章标签： easyui 分页 hibernate

本文链接：https://blog.csdn.net/qq_38661902/article/details/84879964

版权

1,准备工具类pageBean

2,通用的方法，将数据以json格式返回

@ResponseBody //将数据以json格式返回
public String searchworkgrid(HttpServletRequest request,HttpServletResponse response,PageBean pageBean)throws IOException{
   //获取当前页
    String page = request.getParameter("page");
    //获取每页显示数
    String rows = request.getParameter("rows");
    pageBean.setCurrentPage(Integer.parseInt(page));
    pageBean.setPageSize(Integer.parseInt(rows));
    supervisionService.pageQuery(pageBean,request);
    this.writePageBean(pageBean,response);
    return null;
}

3，writePageBean方法

/**
 * 分页方法
 * @param pageBean
 * @param response
 */
public void writePageBean(PageBean pageBean, HttpServletResponse response) throws IOException {
    JsonConfig jsonConfig = new JsonConfig();
    jsonConfig.setCycleDetectionStrategy(CycleDetectionStrategy.LENIENT);
    JSONObject jsonObject = JSONObject.fromObject(pageBean, jsonConfig);
    String  json = jsonObject.toString();
    response.setContentType(
            "text/json;charset=UTF-8");
    response.getWriter().print(json);
}

4,pageQuery方法

public void pageQuery(PageBean pageBean, HttpServletRequest request) {
    int currentPage = pageBean.getCurrentPage();
    int pageSize = pageBean.getPageSize();
    //设置编码
    try {
        request.setCharacterEncoding("utf-8");
        //得到离线查询对象
        DetachedCriteria cri = DetachedCriteria.forClass(TRecieveEntity.class);
       //修改查询方式 select count(*) from table
        cri.setProjection(Projections.rowCount());
        //查询总行数
        Session session = systemService.getSession();
        Query query = session.createQuery("select count(*) from  TRecieveEntity tRecieve");
        Long total= (Long) query.list().get(0);
        pageBean.setTotal(total.intValue());//设置总数据量
        //修改查询状态 
        cri.setProjection(null);
        int firstResult = (currentPage - 1) * pageSize;
        int maxResults = pageSize;
        List<TRecieveEntity> rows= this.pageList(cri, firstResult, maxResults);
        pageBean.setRows(rows);
        //当前页展示的数据集合

    } catch (UnsupportedEncodingException e) {
        e.printStackTrace();
    }

}

5,js页面

<body class="easyui-layout">
<div data-options="region:'center'">
    <table class="easyui-datagrid" title="工单列表" style="width:1338px;height:550px"
           data-options="striped:true,rownumbers:true,singleSelect:false,
           pagination:true,autoRowHeight:false, pageList: [15,30,50],toolbar:'#tb',
           url:'supervisionController.do?searchworkgrid',method:'post'" id="dg">
        <thead>
        <tr>
            <th data-options="field:'ck',checkbox:true"></th>
            <th data-options="field:'id'" width="150" hidden="hidden">主键</th>
            <th data-options="field:'recieveNum',width:150,formatter:titleformater">96005工单编号</th>
            <th data-options="field:'hotlineNum'" width="150">12345工单编号</th>
            <th data-options="field:'proStatus'" width="150">工单状态</th>
            <th data-options="field:'recieveFrom'"  width="150">工单来源</th>
            <th data-options="field:'msgTitle'" width="160">工单标题</th>
            <th data-options="field:'description'" width="160">工单描述</th>
            <th data-options="field:'isSUPERVISE'" width="160">督办状态</th>
            <th data-options="field:'signMan'" width="160">签收员</th>
            <th data-options="field:'problemClass'" width="160" hidden="false">问题分类</th>
            <th data-options="field:'problemName'" width="160">问题分类</th>
            <th data-options="field:'label'" width="160">标签库</th>
        </tr>
        </thead>
    </table>
</div>

6,效果展示