easy-ui的datagrid排序

两种
1.本地排序

$(function(){
            $('#MHManagementDataGrid').datagrid({
            url: "${pageContext.request.contextPath}/qurey_all_member.do",
            rownumbers:true,//序列号,显示在第一列
            remoteSort:false,
            width: '970',
            height: '420',
            onBeforeSelect:function(){//单继不选中
                return false;
                },
            pagination:true,//分页条
            pageSize:10,//每页显示的数目
            pagelist:[10,20,30,40],//选择每页加载的数目,这个要和pagesize的数目成倍数
            fitColumns:false,//自动改变行列比例,把表格撑起来,显得好看点
            //这是每一列定义的内容,field最重要,一定要和返回的数据名称一致,表格就是靠这个名字自动填充数据的
            columns:[[
                {field:'id',title:'序号',width:40,sortable:true},
                {field:'member_num',title:'会员号码',width:120},
                {field:'member_name',title:'会员姓名',width:80},
                {field:'member_phone',title:'会员电话',width:120},
                {field:'member_times',title:'登记次数',width:40},
                {field:'remarks',title:'备注',width:100},
                {field:'member_start',title:'开始时间',width:130},
                {field:'member_end',title:'结束时间',width:130},

配置remoteSort:false和sortable:true
2.服务器排序

$(function(){
            $('#MHManagementDataGrid').datagrid({
            url: "${pageContext.request.contextPath}/qurey_all_member.do",
            rownumbers:true,//序列号,显示在第一列
            remoteSort:true,
            width: '970',
            height: '420',
            onBeforeSelect:function(){//单继不选中
                return false;
                },
            pagination:true,//分页条
            pageSize:10,//每页显示的数目
            pagelist:[10,20,30,40],//选择每页加载的数目,这个要和pagesize的数目成倍数
            fitColumns:false,//自动改变行列比例,把表格撑起来,显得好看点
            //这是每一列定义的内容,field最重要,一定要和返回的数据名称一致,表格就是靠这个名字自动填充数据的
            columns:[[
                {field:'id',title:'序号',width:40,sortable:true},
                {field:'member_num',title:'会员号码',width:120},
                {field:'member_name',title:'会员姓名',width:80},
                {field:'member_phone',title:'会员电话',width:120},
                {field:'member_times',title:'登记次数',width:40},
                {field:'remarks',title:'备注',width:100},
                {field:'member_start',title:'开始时间',width:130},
                {field:'member_end',title:'结束时间',width:130},

配置remoteSort:true和sortable:true
前端自动传值排序参数给后端
后台通过获取要排列的字段以及order查询数据库时进行排序
sort-要排列的字段
order-asc/desc排序顺序

String sort= request.getParameter("sort");
String order= request.getParameter("order");
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
<div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建</div></td><td field="linkTel"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-linkTel">13842929049</div></td><td field="workCompanyCod"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-workCompanyCod">金海粮油</div></td><td field="cargoNam" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-cargoNam"></div></td><td field="consignCod" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-consignCod"></div></td><td field="planDte"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-planDte">2023-05-01</div></td><td field="validTyp"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-validTyp">当天有效</div></td><td field="ifEnd"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-ifEnd">x</div></td><td field="individualId" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-individualId">0</div></td><td field="rejectReason"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-rejectReason"></div></td><td field="checkNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkNam">jhly</div></td><td field="checkTim"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkTim">2023-04-29 21:09</div></td>以上代码为网页源码,帮我写一段python程序从以上代码中找出drivernam和checkTim并保存数据库中
06-13
可以使用BeautifulSoup和pymysql库来实现该功能。以下是示例代码: ``` python from bs4 import BeautifulSoup import pymysql # 解析网页源码 html = """ <div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建</div></td><td field="linkTel"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-linkTel">13842929049</div></td><td field="workCompanyCod"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-workCompanyCod">金海粮油</div></td><td field="cargoNam" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-cargoNam"></div></td><td field="consignCod" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-consignCod"></div></td><td field="planDte"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-planDte">2023-05-01</div></td><td field="validTyp"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-validTyp">当天有效</div></td><td field="ifEnd"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-ifEnd">x</div></td><td field="individualId" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-individualId">0</div></td><td field="rejectReason"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-rejectReason"></div></td><td field="checkNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkNam">jhly</div></td><td field="checkTim"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkTim">2023-04-29 21:09</div></td> """ soup = BeautifulSoup(html, 'html.parser') # 获取driverNam和checkTim的值 driverNam = soup.find('td', {'field': 'driverNam'}).text.strip() checkTim = soup.find('td', {'field': 'checkTim'}).text.strip() # 将数据保存到数据库中 conn = pymysql.connect(host='localhost', user='root', password='password', database='test') cur = conn.cursor() sql = "INSERT INTO table_name (driverNam, checkTim) VALUES (%s, %s)" values = (driverNam, checkTim) cur.execute(sql, values) conn.commit() cur.close() conn.close() ``` 需要将代码中的`table_name`替换为实际表名,以及修改数据库连接参数。

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值