81,095
社区成员
发帖
与我相关
我的任务
分享
<table id="table_list_2"></table>
<div id="pager_list_2"></div>
$(document).ready(function () {
var mydata=${json1};
$.jgrid.defaults.styleUI = 'Bootstrap';
// Examle data for jqGrid
// Configuration for jqGrid Example 2
$("#table_list_2").jqGrid({
data: mydata,
datatype: "local",
height: 450,
autowidth: true,
shrinkToFit: true,
rowNum: 10,
rowList: [10, 20, 30],
colNames: ['收银员编号', '手机号码', '收银员姓名', '所属商户', '所属部门', '员工编号', '邮箱','职务','状态'],
colModel: [
{
name: 'cashierNo',
index: 'cashierNo',
editable: true,
width: 60,
sorttype: "int",
search: true
},
{
name: 'phone',
index: 'phone',
editable: true,
width: 90,
sorttype: "string",
formatter: "string"
},
{
name: 'cashierName',
index: 'cashierName',
editable: true,
width: 100
},
{
name: 'merchantName',
index: 'merchantName',
editable: true,
width: 80,
align: "right",
sorttype: "string",
formatter: "string"
},
{
name: 'departmentName',
index: 'departmentName',
editable: true,
width: 80,
align: "right",
sorttype: "float"
},
{
name: 'staffNo',
index: 'staffNo',
editable: true,
width: 80,
align: "right",
sorttype: "float"
},
{
name: 'email',
index: 'email',
editable: true,
width: 100,
sortable: false
},
{
name: 'position',
index: 'position',
editable: true,
width: 100,
sortable: false
},
{
name: 'status',
index: 'status',
editable: true,
width: 100,
sortable: false
}
],
pager: "#pager_list_2",
viewrecords: true,
caption: "收银员管理",
add: true,
edit: true,
addtext: 'Add',
edittext: 'Edit',
hidegrid: false
});
String current = request.getParameter("page"); // 取得当前页数,注意这是jqgrid自身的参数
String pagesize = request.getParameter("rows"); // 取得每页显示行数,,注意这是jqgrid自身的参数
public Map<String, Object> selectByExample(HttpServletRequest request,String page,String rows, String type) throws Exception {
if (page == null) page = "1";
if (rows == null) rows = "15";