jqueryeaysui datagrid自己封装js实现源码.docx

Jqueryeasyui自己封装的jsfunction createTable(tableId,rows) $(#+tableId).datagrid(loadFilter : pagerFilter).datagrid(loadData, rows);function pagerFilter(data) if (typeof data.length = number & typeof data.splice = function) data = total : data.length,rows : datavar dg = $(this);var opts = dg.datagrid(options);var pager = dg.datagrid(getPager);pager.pagination(onSelectPage : function(pageNum, pageSize) opts.pageNumber = pageNum;opts.pageSize = pageSize;pager.pagination(refresh, pageNumber : pageNum,pageSize : pageSize);dg.datagrid(loadData, data););if (!data.originalRows) data.originalRows = (data.rows);var start = (opts.pageNumber - 1) * parseInt(opts.pageSize);var end = start + parseInt(opts.pageSize);data.rows = (data.originalRows.slice(start, end);return data;Java类/* * 查询 * return * throws Exception */public String showAdminList() throws Exception/构造json对象JSONObject result = new JSONObject();JSONArray oldjyjson = new JSONArray();db=new DBUtil();db.getConn();String sql1=select username, address,email,mobile from tb_customer ;rs=db.select(sql1); List list =new ArrayList(); try while(rs.next()JSONObject re = new JSONObject();Customer u = new Customer(); u.setUsername( rs.getString(username);u.setAddress( rs.getString(address);u.setMobile( rs.getString(mobile);u.setEmail( rs.getString(email);JSONObject jo=re.fromObject(u);oldjyjson.add(jo); catch (SQLException e) e.printStackTrace();finallydb.close(); HttpServletRequest request = ServletActionContext.getRequest(); request.setAttribute(list, oldjyjson.toArray(); request.setAttribute(result, oldjyjson.toString();return ADLIST;/返回后台管理页面页面 $(document).ready(function() initDataGrid(); /初始化用户分页列表 $(#w).window(close); $(#ad).window(close); ); function initDataGrid() var rows = new Array(); var result=document.getElementById(jg).innerHTML; var resul=eval(result); for(var i=0;iresul.length;i+) var res=resuli; rows.push( id:i+1,username : res.username,email : res.email,address :res.address,mobile : res.mobile); createTable(myGrid,rows); function deleteUser() var ids; var rows = $(#myGrid).datagrid(getSelections); for(var i=0; irows.length; i+) ids=rowsi.username; document.getElementById(deus).value =ids; document.getElementById(dele).submit(); / var url=/Shop/administrator_deleteUser?username=+ids; / window.open(url); */ /* /window.location.href(/administrator_deleteUser.do?username=+ids+); */ function editUser() var checkLength = $(#myGrid).datagrid(getChecked).length; if (checkLength != 1) $.messager.alert(提示,请选择一条记录!,error); return; var username = $(#myGrid).datagrid(getChecked)0.username; var email= $(#myGrid).datagrid(getChecked)0.email; var address= $(#myGrid).datagrid(getChecked)0.address; var mobile= $(#myGrid).datagrid(getChecked)0.mobile; document.getElementById(edus).value =username; document.getElementById(email).value =email; document.getElementById(address).value =address; document.getElementById(mobile).value =mobile; $(#w).window(open); /document.getElementById(edit).submit(); /生成编译文本 var editIndex = undefined;function endEditing()if (editIndex = undefined)return trueif ($(#myGrid).datagrid(validateRow, editIndex)$(#myGrid).datagrid(endEdit, editIndex);editIndex = undefined;return true; else return false;/双击选择项 function onClickRow(index) if (editIndex != index)if (endEditing()$(#myGrid).datagrid(selectRow, index).datagrid(beginEdit, index);editIndex = index; else $(#myGrid).datagrid(selectRow, editIndex);function addUser()$(#ad).window(open);function doSearch() var yh=$(#yhs).val(); var dz=$(#dzs).val(); if(yh=&dz=) $.messager.alert(提示,请至少输入一个选择条件,无条件时默认显示全部,error); else document.getElementById(yhm)