快捷導(dǎo)航

layui之?dāng)?shù)據(jù)表格--與后臺交互獲取數(shù)據(jù)的方法

更新時間：2019年09月29日 09:37:47 作者：張育嘉

今天小編就為大家分享一篇layui之?dāng)?shù)據(jù)表格--與后臺交互獲取數(shù)據(jù)的方法，具有很好的參考價值，希望對大家有所幫助。一起跟隨小編過來看看吧

jsp或html

<table id="userList" lay-filter="userList"></table>

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 '<a class="layui-blue" href="mailto:'+d.userEmail+'" rel="external nofollow" >'+d.userEmail+'</a>';
  }},
  {field: 'userSex', title: '用戶性別', align:'center'},
  {field: 'userStatus', title: '用戶狀態(tài)', align:'center',templet:function(d){
   return d.userStatus == '0' ? "正常使用":"<span class='layui-red'>限制使用</span>";
  }},
  {field: 'userGrade', title: '用戶等級', align:'center'},
  {field: 'userEndTime', title: '最后登錄時間', align:'center',minWidth:150},
  {title: '操作', minWidth:175, templet:'#userListBar',fixed:"right",align:"center"}
 ]]
});

UserAction.java

// 接收前端發(fā)送來的分頁參數(shù)
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<User> 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);
 // 將其轉(zhuǎn)換為JSON數(shù)據(jù)，并壓入值棧返回
 ActionContext.getContext().getValueStack().set("jsonData", JSONObject.fromObject(result));
 return "success";
}

struts.xml配置

<!-- 用戶配置 -->
<package name="user" namespace="/" extends="common,json-default">
 <action name="userAction_*" class="userAction" method="{1}">
  <result name="success" type="json">
   <param name="root">jsonData</param>
  </result>
 </action>
</package>

返回JSON數(shù)據(jù)格式，也是layui數(shù)據(jù)表格要求的格式

{
 "code": 0,
 "msg": "",
 "count": 15,
 "data": [
 {
  "usersId": "1",
  "userName": "user12",
  "userEmail": "123@qq.com",
  "userSex": "女",
  "userStatus": "0",
  "userGrade": "倔強(qiáng)青銅",
  "userEndTime": "2018-11-11 15:22:33"
 },{
  "usersId": "2",
  "userName": "asd",
  "userEmail": "123@qq.com",
  "userSex": "男",
  "userStatus": "1",
  "userGrade": "秩序白銀",
  "userEndTime": "2018-11-11 15:22:33"
 },
 ......
 ]
}

注意：

1.js中table的field需要與返回的數(shù)據(jù)key相對應(yīng)，比如field: “userName”與“userName”: “asd”

2.layui的數(shù)據(jù)表格向url發(fā)送請求時，會附上page以及l(fā)imit這兩個參數(shù)，所以服務(wù)端需要接收并以此為條件查找數(shù)據(jù)

前端展示效果