您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
JSp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>" rel="external nofollow" > <meta charset="utf-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <title>用户信息表</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css" rel="external nofollow" > --> <link rel="stylesheet" type="text/css" href="js/layui-v2.2.6/layui/css/layui.css" rel="external nofollow" media="all"> </head> <script type="text/javascript" src="js/jquery-3.1.1.min.js"></script> <script type="text/javascript" src="js/layui-v2.2.6/layui/layui.all.js"></script> <script type="text/html" id="barDemo"> <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">查看</a> <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a> <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a> </script> <script type="text/javascript"> $(function(){ layui.use(['laydate', 'laypage', 'layer', 'table', 'carousel', 'upload', 'element'], function(){ var laydate = layui.laydate //日期 ,laypage = layui.laypage //分页 ,layer = layui.layer //弹层 ,table = layui.table //表格 ,carousel = layui.carousel //轮播 ,upload = layui.upload //上传 ,element = layui.element; //元素操作 //监听Tab切换 element.on('tab(demo)', function(data){ layer.msg('切换了:'+ this.innerHTML); console.log(data); }); //执行一个 table 实例 table.render({ elem: '#userList' ,height: 'full' ,url: 'user/selectUserList.do' //数据接口 ,method: 'POST' ,cellMinWidth: 80 //全局定义常规单元格的最小宽度,layui 2.2.1 新增 ,page: { //支持传入 laypage 组件的所有参数(某些参数除外,如:jump/elem) - 详见文档 layout: ['limit', 'count', 'prev', 'page', 'next', 'skip'] //自定义分页布局 //,curr: 5 //设定初始在第 5 页 ,groups: 5 //只显示 5 个连续页码 ,first: true //显示首页 ,last: true //显示尾页 } ,limits : [2,3] ,cols: [[ //表头 {checkbox : true} ,{field: 'id', title: 'ID', width:50, sort: true, fixed: 'left'} ,{field: 'name', title: '用户名', width:200} ,{field: 'username', title: '账号', width:200, sort: true} ,{field: 'tel', title: '电话', width:200} ,{field: 'QQ', title: 'QQ', width: 200} ,{field: 'WeChat', title: '微信', width: 200, sort: true} ,{field: 'role', title: 'role', width: 80, sort: true} ,{field: 'createDate', title: '创建时间', width: 200} ,{field: 'isDelete', title: '是否删除', width: 200, sort: true} ,{fixed: 'right', title:'操作' , width: 200, align:'center', toolbar: '#barDemo'} ]] ,where : { //传值 startDate : startDate, } ,response: { statusName: 'code' //数据状态的字段名称,默认:code ,statusCode: 200 //成功的状态码,默认:0 ,msgName: 'message' //状态信息的字段名称,默认:msg ,countName: 'totalCount' //数据总数的字段名称,默认:count ,dataName: 'data' //数据列表的字段名称,默认:data }/* , done: function(res, curr, count){ //如果是异步请求数据方式,res即为你接口返回的信息。 //如果是直接赋值的方式,res即为:{data: [], count: 99} data为当前页数据、count为数据总长度 console.log(res.data); //得到当前页码 console.log(curr); //得到数据总量 console.log(count); } */ }); //监听工具条 table.on('tool(userList)', function(obj){ //注:tool是工具条事件名,test是table原始容器的属性 lay-filter="对应的值" console.log(obj) var data = obj.data //获得当前行数据 ,layEvent = obj.event; //获得 lay-event 对应的值 if(layEvent === 'detail'){ layer.msg('查看操作'); } else if(layEvent === 'del'){ layer.confirm('真的删除行么', function(index){ obj.del(); //删除对应行(tr)的DOM结构 layer.close(index); //向服务端发送删除指令 }); } else if(layEvent === 'edit'){ layer.msg('编辑操作'); } }); }); }); </script> <body> <fieldset class="layui-elem-field layui-field-title" > <legend>默认表格</legend> </fieldset> <div> <table class="layui-hide" id="userList" lay-filter="userList"></table> </div> </body> </html>
Controller
package com.xiaoye.app.controller; import java.sql.SQLException; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.ResponseBody; import com.xiaoye.app.common.MsgReturn; import com.xiaoye.app.constant.passWordUtil; import com.xiaoye.app.entity.User; import com.xiaoye.app.service.UserService; import com.xiaoye.app.util.PropertyCodeMsgUtil; import com.xiaoye.app.util.StringUtil; @Controller(value = "userController") /** * * @author xiaoye * @date 2018年5月3日 * * 此类的全局访问 "user/xxx.do" */ @RequestMapping(value = "user/") public class UserController { @Autowired // @Qualifier("userService") private UserService userService; private static final Logger logger = Logger.getLogger(UserController.class); @RequestMapping(value = "login", method = RequestMethod.POST) @ResponseBody public MsgReturn login(User user) { if (user == null) { return MsgReturn.ERROR_PARAM; } String password = user.getPassword(); if (StringUtil.isEmpty(user.getUsername()) || StringUtil.isEmpty(password)) { return MsgReturn.ERROR_PARAM; } user.setPassword(passWordUtil.md5ToRandomMd5(password)); try { return userService.login(user); } catch (SQLException e) { e.printStackTrace(); logger.info(PropertyCodeMsgUtil.getPropertyValue(MsgReturn.EXCEPTION_SQL), e); } return MsgReturn.ERROR_ERROR; } @RequestMapping(value = "selectUserList", method = RequestMethod.POST) @ResponseBody public MsgReturn selectUserList(User user) { try { return userService.selectUserList(user); } catch (SQLException e) { e.printStackTrace(); logger.info(PropertyCodeMsgUtil.getPropertyValue(MsgReturn.EXCEPTION_SQL), e); } return MsgReturn.ERROR_ERROR; } }
返回类型
MsgReturn
package com.xiaoye.app.common; import com.xiaoye.app.util.PropertyCodeMsgUtil; /** * 前后台返回数据用的桥接 * * @author xiaoye * @date 2018年5月3日 * * */ public class MsgReturn { /** * 成功/错误码 */ private String code; /** * 提示信息 */ private Object message; /** * 返回数据 */ private Object data; // --------系统错误-------- /** * 系统繁忙 */ public static String ERROR = "0"; /** * 参数错误 */ public static String ERROR_PARAME = "1"; /** * 登录异常 */ public static String LOAD_ERROR = "2"; /** * 登录失败 */ public static String LOAD_EXCEPTION = "3"; /** * 無數據 */ public static String NODATA = "4"; // --------用户错误-------- /** * 验证码错误 */ public static String VERIFICATION_CODE_ERROR = "10"; /** * 用户名不存在 */ public static String USERNAME_NOT_EXIST = "11"; /** * 密码错误 */ public static String PASSWOR_ERROR = "12"; /** * 手机号码长度有误 */ public static String TEL_LENGTH_ERROR = "13"; /** * 请输入正确的手机号 */ public static String TEL_IS_FALSE = "14"; /** * 邮箱格式有误 */ public static String EMAIL_FORMAT_ERROR = "15"; /** ---------------300 异常 * 数据库异常 */ public static String EXCEPTION_SQL = "300"; /** * 成功 */ public static String SUCCESS = "200"; private Integer totalCount; /** * 系统繁忙 */ public static MsgReturn ERROR_ERROR = new MsgReturn(ERROR, PropertyCodeMsgUtil.getPropertyValue(ERROR)); /** * 参数错误 */ public static MsgReturn ERROR_PARAM = new MsgReturn(ERROR_PARAME, PropertyCodeMsgUtil.getPropertyValue(ERROR_PARAME)); /** * 操作成功 */ public static MsgReturn SuccessMsg = new MsgReturn(SUCCESS, PropertyCodeMsgUtil.getPropertyValue(SUCCESS)); public MsgReturn(String code, String message) { this.code = code; this.message = message; } public MsgReturn(String code, Object message, Object data) { super(); this.code = code; this.message = message; this.data = data; } public MsgReturn(String code, Object message, Object data, Integer totalCount) { super(); this.code = code; this.message = message; this.data = data; this.totalCount = totalCount; } public static MsgReturn success(Object data) { return new MsgReturn(SUCCESS, PropertyCodeMsgUtil.getPropertyValue(SUCCESS), data); } public static MsgReturn success(Object message, Object data) { return new MsgReturn(SUCCESS, message, data); } public static MsgReturn ERROR(Object data) { return new MsgReturn(ERROR_PARAME, null, data); } public static MsgReturn NODATA() { return new MsgReturn(NODATA, PropertyCodeMsgUtil.getPropertyValue(NODATA), null); } /** * 参数错误 * * @return */ public static MsgReturn PARAM_ERROR() { return new MsgReturn(ERROR_PARAME, PropertyCodeMsgUtil.getPropertyValue(ERROR_PARAME), null); } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public Object getMessage() { return message; } public void setMessage(String message) { this.message = message; } public Object getdata() { return data; } public void setdata(Object data) { this.data = data; } public Integer getTotalCount() { return totalCount; } public void setTotalCount(Integer totalCount) { this.totalCount = totalCount; } public void setMessage(Object message) { this.message = message; } @Override public String toString() { return "MsgReturn [code=" + code + ", message=" + message + ", data=" + data + ", totalCount=" + totalCount + "]"; } }
以上这篇layui table 参数设置方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持亿速云。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。