EasyUI分页过滤查询

最新推荐文章于 2019-10-22 21:15:06 发布

shijiaolong0

最新推荐文章于 2019-10-22 21:15:06 发布

阅读量308

点赞数

CC 4.0 BY-SA版权

分类专栏： EasyUI 文章标签： EasyUI

本文链接：https://blog.youkuaiyun.com/shijiaolong0/article/details/100678918

EasyUI 专栏收录该内容

1 篇文章

订阅专栏

该博客介绍了如何使用EasyUI进行分页和过滤查询，提供了详细的增删改查全套解决方案的参考链接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前端
Html

         <div  region="center" border="false"  style="padding:0px 3px 0px 3px;margin:0px;"> 

              <table id="test"></table> 

    </div>

 

 

初置化gird

$(function(){ 

                   

                  loadgrid();    

                  //loadcombobox(null); 

       });

function loadgrid(){

       $('#test').datagrid({

              title:'任免信息列表',

              fit:true,

              nowrap: false,

              striped:false,

              //url:'rm.json',

              url:'http://127.0.0.1:8080/web/AppAndRemoveServer.server',

              queryParams:{},

              sortName: 'appandremove_id',

              sortOrder: 'asc',

              remoteSort: false,

              idField:'appandremove_id',

              frozenColumns:[[

                    {field:'ck',checkbox:true}

              ]],

              columns:[[{field:'appandremove_id',title:'任免批次编号',width:200,sortable:true},

              {field:'batch_name',title:'任免批次名称',width:240,sortable:true},

              {field:'batch_no',title:'任免批次编号',width:100,sortable:true},

              {field:'recorder_date',title:'登记时间',width:120,sortable:true},

              {field:'recorder_id',title:'登记人',width:100,sortable:true},

              {field:'state',title:'状态',width:100,sortable:true},

              {field:'memo',title:'备注',width:300}

          

              ]],

              pagination:true,

              pageNumber:1,

              pageSize:5,

              pageList:[5,10],           

              //singleSelect:true,

              rownumbers:true  

           });

    }

 

服务端接收rows、page、order、sort参数
    参数名称是easyui起的，值也是自动绑定

    可以在服务端通过request.getParameterNames();查看有什么参数

    接收参数值

    if(null!=request.getParameter("rows")) {             pageRows=Integer.parseInt(request.getParameter("rows").toString());  

       }  

       if(null!=request.getParameter("page")) {  

           page=Integer.parseInt(request.getParameter("page").toString());  

       } 

       if(null!=request.getParameter("order")) {  

           order=request.getParameter("order").toString();  

       }

       if(null!=request.getParameter("sort")) {  

           order=request.getParameter("sort").toString();  

         }

    然后拼装sql语句实现分页。

 增加查询参数，重新加载表格
function reloadgrid (stateVal)  {  

       //查询参数直接添加在url中         

       /* var url =$('#test').datagrid('options').url;

        url = "http://127.0.0.1:8080/web/AppAndRemoveServer.server?state=" +stateVal;   

//重新赋值url 属性

        $('#test').datagrid('options').url=url;

        $("#test").datagrid('reload'); 

        */

        

        //查询参数直接添加在queryParams中    

        var queryParams = $('#test').datagrid('options').queryParams;  

         queryParams.state = stateVal;  

         $('#test').datagrid('options').queryParams=queryParams;        

         $("#test").datagrid('reload'); 

        

    }
后端
import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSON;
import net.sf.json.JSONObject;
import net.sf.json.JSONSerializer;

import com.advice.dao.OpinionDao;
import com.advice.entity.OpinionPo;
import com.advice.util.PageBean;
import com.advice.util.ResponseUtil;

public class ShowAdminWwqyxycServlet extends HttpServlet {

    private static final long serialVersionUID = 1L;
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        int total = 0;//记录总数
        String page=request.getParameter("page")==null?"1":request.getParameter("page");
        String rows=request.getParameter("rows")==null?"50":request.getParameter("rows");
        //处理筛选条件
        String isAudit = request.getParameter("isAudit")==null?"0":request.getParameter("isAudit").toString();//
        String isAnswer = request.getParameter("isAnswer")==null?"":request.getParameter("isAnswer").toString();//
        OpinionPo OpinionXX = new OpinionPo();
        OpinionXX.setIsAudit(isAudit);
        OpinionXX.setIsAnswer(isAnswer);
        PageBean pageBean = new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
        try{
            JSONObject result =  new JSONObject();
            OpinionDao sd = new OpinionDao();
            JSON json = JSONSerializer.toJSON(sd.selectOpinionListALL(pageBean,2,OpinionXX));//数据查询
            total = sd.selectOpinionCountAll(2,OpinionXX);
            result.put("rows", json);
            result.put("total", total);
            ResponseUtil.write(response, result);
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}

参考链接：增删改查全套https://blog.youkuaiyun.com/z865785437029/article/details/78368962