layui之数据表格--与后台交互获取数据

小咪咪 2022-03-26 02:16 541阅读 0赞

jsp或html

1 js

//用户列表  
var tableIns = table.render(\{  
elem: ‘\#userList’,  
url : ‘userAction\_findAll.action’,  
cellMinWidth : 95,  
page : true,  
height : “full-125”,  
limits : \[10,15,20,25\],  
limit : 10,  
id : “userListTable”,  
cols : \[\[  
\{type: “checkbox”, fixed:“left”, width:50\},  
\{field: ‘userName’, title: ‘用户名’, minWidth:100, align:“center”\},  
\{field: ‘userEmail’, title: ‘用户邮箱’, minWidth:200, align:‘center’,templet:function(d)\{  
return ‘[’+d.userEmail+’][d.userEmail]’;  
\}\},  
\{field: ‘userSex’, title: ‘用户性别’, align:‘center’\},  
\{field: ‘userStatus’, title: ‘用户状态’, align:‘center’,templet:function(d)\{  
return d.userStatus == ‘0’ ? “正常使用”:“限制使用”;  
\}\},  
\{field: ‘userGrade’, title: ‘用户等级’, align:‘center’\},  
\{field: ‘userEndTime’, title: ‘最后登录时间’, align:‘center’,minWidth:150\},  
\{title: ‘操作’, minWidth:175, templet:’\#userListBar’,fixed:“right”,align:“center”\}  
\]\]  
\});

UserAction.java

// 接收前端发送来的分页参数  
private int page = 1;  
public void setPage(int page) \{  
this.page = page;  
\}  
public int getPage() \{  
return page;  
\}  
private int limit = 2;  
public int getLimit() \{  
return limit;  
\}  
public void setLimit(int limit) \{  
this.limit = limit;  
\}

public String findAll()\{  
List allUser = this.getUserService().findAllUser(this.getPage(), this.getLimit());  
Map<String, Object> result = new HashMap<String, Object>();  
result.put(“code”, 0);  
result.put(“msg”, “”);  
result.put(“count”, this.getUserService().findTotalRecord(key));  
JSONArray array = JSONArray.fromObject(allUser);  
result.put(“data”, array);  
// 将其转换为JSON数据，并压入值栈返回  
ActionContext.getContext().getValueStack().set(“jsonData”, JSONObject.fromObject(result));  
return “success”;  
\}

struts.xml配置

jsonData

返回JSON数据格式，也是layui数据表格要求的格式

\{  
“code”: 0,  
“msg”: “”,  
“count”: 15,  
“data”: \[  
\{  
“usersId”: “1”,  
“userName”: “user12”,  
“userEmail”: ["123@qq.com][123_qq.com]",  
“userSex”: “女”,  
“userStatus”: “0”,  
“userGrade”: “倔强青铜”,  
“userEndTime”: “2018-11-11 15:22:33”  
\},\{  
“usersId”: “2”,  
“userName”: “asd”,  
“userEmail”: ["123@qq.com][123_qq.com]",  
“userSex”: “男”,  
“userStatus”: “1”,  
“userGrade”: “秩序白银”,  
“userEndTime”: “2018-11-11 15:22:33”  
\},  
\]  
\}

注意：

## 1.js中table的field需要与返回的数据key相对应，比如field: “userName”与“userName”: “asd”   2.layui的数据表格向url发送请求时，会附上page以及limit这两个参数，所以服务端需要接收并以此为条件查找数据 ##

作者：张育嘉  
来源：CSDN  
原文：[https://blog.csdn.net/code\_shadow/article/details/80459080][https_blog.csdn.net_code_shadow_article_details_80459080]  
版权声明：本文为博主原创文章，转载请附上博文链接！

[d.userEmail]: mailto:'%20rel=
[123_qq.com]: mailto:%22123@qq.com
[https_blog.csdn.net_code_shadow_article_details_80459080]: https://blog.csdn.net/code_shadow/article/details/80459080