普通管理員管理：
新增普通管理員：
前端效果：
前端代碼：
<body>
<div class="layui-fluid"><div class="layui-row"><div class="layui-form"><div class="layui-form-item"><label for="loginname" class="layui-form-label"><span class="x-red">*</span>登錄名</label><div class="layui-input-inline"><input type="text" id="loginname" name="loginname" lay-verify="required|loginname" class="layui-input"></div></div><div class="layui-form-item"><label for="L_loginpassword" class="layui-form-label"><span class="x-red">*</span>設置登錄密碼</label><div class="layui-input-inline"><input type="password" id="L_loginpassword" name="loginpassword" lay-verify="required|loginpassword" class="layui-input"></div></div><div class="layui-form-item"><label for="L_confirmloginpassword" class="layui-form-label"><span class="x-red">*</span>確認密碼</label><div class="layui-input-inline"><input type="password" id="L_confirmloginpassword" name="confirmloginpassword" lay-verify="required|confirmloginpassword" class="layui-input"></div></div><div class="layui-form-item"><label class="layui-form-label"></label><button class="layui-btn" lay-filter="submit" lay-submit="">保存</button></div></div></div>
</div><script>layui.use(['form', 'layer', 'upload'], function () {$ = layui.jquery;var form = layui.form,upload = layui.upload,layer = layui.layer;//自定義驗證規則form.verify({loginname: function (value) {var code;$.ajax({url: "/smalladmin/checkloginname",type: "GET",async: false, //關閉異步，當success返回結果后才執行ajax之后的內容data: {"loginname": value},success: function (s) {code = s;}});if (code != true) {return '登錄名重復，請重新輸入！';}},loginpassword: [/(.+){6,12}$/, '密碼必須6到12位'],confirmloginpassword: function () {if ($('#L_confirmloginpassword').val() != $('#L_loginpassword').val()) {return '兩次密碼不一致';}}});//監聽提交form.on('submit(submit)', function (data) {console.log(data.field);$.ajax({url: "/smalladmin/addadmin",type: "post",data: data.field,success: function (s) {if (s == true) {layer.alert("新增普通管理員信息成功！", {icon: 6}, function () {parent.layer.closeAll();parent.location.href = "/admin/sysindex";});} else {layer.msg("登錄名重復！", function () {});}},error: function () {layer.msg("接口異常!", function () {});}});});});
</script></body>后端代碼：
SmalladminController
/*** 超級管理員，新增普通管理員頁面*/@GetMapping("/addadminpage")public String adduserpage() {return "smalladmin/addadminpage";}/*** 超級管理員新增普通管理員，判斷新增普通管理員登錄名是否重復*/@GetMapping("/checkloginname")@ResponseBodypublic boolean checkaddadminloginname(@RequestParam("loginname") String loginname) {return smalladminService.checkaddadminloginname(loginname);}/*** 超級管理員新增普通管理員信息*/@PostMapping("/addadmin")@ResponseBodypublic boolean addadmin(@RequestParam("loginname") String loginname,@RequestParam("loginpassword") String loginpassword,@RequestParam("confirmloginpassword") String confirmloginpassword) {return smalladminService.addadmin(loginname,loginpassword);}@GetMapping("/updateadminpage")public String updateadminpage() {return "smalladmin/updateadminpage";}
SmalladminService
/*** 超級管理員新增普通管理員，判斷新增普通管理員登錄名是否重復*/boolean checkaddadminloginname(String loginname);/*** 超級管理員新增普通管理員信息*/boolean addadmin(String loginname, String loginpassword);SmalladminServicelpml
/*** 超級管理員新增普通管理員，判斷新增普通管理員登錄名是否重復*/@Overridepublic boolean checkaddadminloginname(String loginname) {Smalladmin smalladmin=smalladminMapper.selectaddadminloginname(loginname);return smalladmin==null;}/*** 超級管理員新增普通管理員信息*/@Overridepublic boolean addadmin(String loginname, String loginpassword) {return smalladminMapper.addsmalladmin(loginname,loginpassword);}SmalladminMapper
/*** 超級管理員新增普通管理員時，檢查登錄名是否重復* @param loginname* @return*/Smalladmin selectaddadminloginname(String loginname);/*** 超級管理員新增普通管理員信息* @param loginname* @param loginpassword* @return*/boolean addsmalladmin(@Param("loginname") String loginname,@Param("loginpassword") String loginpassword);
SmalladminMapper.xml
<select id="selectaddadminloginname" resultType="com.homestay.pojo.Smalladmin">select<include refid="Base_Column_List"></include>from smalladminwhere sname=#{loginname}</select><insert id="addsmalladmin">insert into smalladmin(sname,spassword)values (#{loginname},#{loginpassword})</insert>測試：
登錄名重復：
必填項為空：
兩次密碼不一樣：
新增成功：
普通管理員分頁查詢：
前端效果：
前端代碼：
<body>
<div class="layui-fluid"><div class="layui-row layui-col-space15"><div class="layui-col-md12"><div class="layui-card"><div class="layui-card-body "><form class="layui-form layui-col-space5"><div class="layui-inline layui-show-xs-block"><input type="text" name="dname" placeholder="管理員名稱" autocomplete="off" class="layui-input"></div><div class="layui-inline layui-show-xs-block"><button class="layui-btn" lay-submit="" lay-filter="search_btn"><i class="layui-icon"></i></button></div><a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right" onclick="reload();" title="刷新"><i class="layui-icon layui-icon-refresh" style="line-height:30px"></i></a></form></div><div class="layui-card-body "><table id="departmenList" lay-filter="departmenList"></table></div></div></div></div>
</div><script type="text/html" id="departmenListBar"><a class="layui-btn layui-btn-xs" lay-event="edit" >編輯</a><a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="del">刪除</a>
</script><script type="text/javascript" th:inline="javascript">layui.use(['form', 'layer', 'table'], function () {var form = layui.form,layer = layui.layer,$ = layui.jquery,table = layui.table;var tableIns = table.render({elem: '#departmenList',url: '/smalladmin/pagequarysmalladmin',method: 'get',title: '管理員列表',page: true, //開啟分頁height: "full-110", //高度最大化減去差值110,高度將始終鋪滿// toolbar: true, //開啟工具欄limit:10, //每頁顯示的條數limits: [5,10,20,30], //每頁條數的選擇項cols:[[{type: 'checkbox', field: 'sid', fixed: "left"},{field: 'sid', title: '普通管理員id', align: "center", unresize: "true"},{field: 'sphoto',title: '普通管理員頭像',align: 'center',unresize: "true",templet: function(d) {// 如果 uphoto 是圖片URL，直接渲染為 <img> 標簽return '<img src="' + d.sphoto + '" style="width: 40px; height: 40px; border-radius: 50%;" />';}},{field: 'sname', title: '普通管理員名稱', align: 'center', unresize: "true"},{field: 'spassword',title: '普通管理員密碼',align: 'center',unresize: "true"},{title: '操作', align: "center", unresize: "true", toolbar: "#departmenListBar"}]]});//搜索form.on('submit(search_btn)', function (data) {tableIns.reload({url: '/smalladmin/listbyname',where: data.field, page: {curr: 1 //重新從第 1 頁開始}});return false;});//監聽工具條table.on('tool(departmenList)', function (obj) {var data = obj.data, //獲得當前行數據layEvent = obj.event; //獲得 lay-event 對應的值（也可以是表頭的 event 參數對應的值）switch (layEvent) {case 'del':layer.confirm('確定刪除此管理員？', {icon: 3, title: '提示信息'}, function (index) {$.post("/smalladmin/delete",{// "nid": $('#nid').val()"sid":data.sid},function (success) { // 直接接收布爾值if (success) {layer.msg('刪除管理員成功', {icon: 1});// 刪除成功后刷新父窗口setTimeout(function() {xadmin.father_reload();}, 1000);} else {layer.msg('刪除管理員失敗', {icon: 2});}});layer.close(index);});return false;// 阻止默認行為break;// case 'edit':// xadmin.open('管理員編輯', '/admin/checkadminpasswordpage?gid=' + data.gid, 450, 300);// break;case 'edit':// 構造完整的編輯URL，包含所有參數var editUrl = '/smalladmin/updatesmalladminpage?sid=' + data.sid+ '&sphoto=' + encodeURIComponent(data.sphoto || '')+ '&sname=' + encodeURIComponent(data.sname || '')+ '&spassword=' + encodeURIComponent(data.spassword || '');// 打開編輯窗口（調整彈窗大小以適應內容）xadmin.open('普通員工編輯', editUrl, 800, 550);break;default:break;}});});function reload() {$.get("/smalladmin/reload", function (data) {if (data) {location.reload();} else {parent.location.reload();}});}
</script>
</body>后端代碼：
SmalladminController：
/*** 超級管理員編輯普通管理員，分頁查詢*/@GetMapping("/pagequarysmalladmin")@ResponseBodypublic Result pagequarysmalladmin(@RequestParam Map<String,Object> map) {int page = Integer.parseInt(map.get("page").toString());int limit = Integer.parseInt(map.get("limit").toString());int start=(page-1)*limit;return smalladminService.getsmalladminList(start,limit);}SmalladminService
/*** 分頁查詢普通管理員* @param start* @param limit* @return*/Result getsmalladminList(int start, int limit);SmalladminServicelpml
/*** 分頁查詢普通管理員* @param start* @param limit* @return*/@Overridepublic Result getsmalladminList(int start, int limit) {int countsmalladmin=smalladminMapper.countsmalladmin();List<Smalladmin> smalladmins=smalladminMapper.selectsmalladmin(start,limit);Result result=new Result();result.setData(smalladmins);result.setCount(countsmalladmin);result.setMsg("查詢成功");result.setCode(0);return result;}SmalladminMapper：
/*** 獲取普通管理員總數* @return*/int countsmalladmin();/*** 分頁查詢，獲取數據* @param start* @param limit* @return*/List<Smalladmin> selectsmalladmin(@Param("start") int start, @Param("limit") int limit);
SmalladminMapper.xml
<select id="countsmalladmin" resultType="java.lang.Integer">select count(*) from smalladmin</select><select id="selectsmalladmin" resultType="com.homestay.pojo.Smalladmin">select<include refid="Base_Column_List"></include>from smalladminorder by sidlimit #{start},#{limit}</select>測試：
一頁5條：
一頁10條：
模糊查詢：
后端代碼：
SmalladminController
/*** 模糊查詢*/@GetMapping("/listbyname")@ResponseBodypublic Result listbyname(@RequestParam Map<String,Object> map) {int page = Integer.parseInt(map.get("page").toString());int limit = Integer.parseInt(map.get("limit").toString());int start=(page-1)*limit;String dname=map.get("dname").toString();return smalladminService.listbyname(dname,start,limit);}SmalladminService
/*** 模糊查詢* @param dname* @param start* @param limit* @return*/Result listbyname(String dname, int start, int limit);SmalladminServicelpml
/*** 模糊查詢* @param dname* @param start* @param limit* @return*/@Overridepublic Result listbyname(String dname, int start, int limit) {int countsmalladmin=smalladminMapper.countsmalladminbyname(dname);List<Smalladmin> smalladmins=smalladminMapper.selectsmalladminbyname(dname,start,limit);Result result=new Result();result.setData(smalladmins);result.setCount(countsmalladmin);result.setMsg("查詢成功");result.setCode(0);return result;}SmalladminMapper
/*** 模糊查詢獲取名總數* @param dname* @return*/int countsmalladminbyname(@Param("dname") String dname);/*** 模糊查詢* @param dname* @param start* @param limit* @return*/List<Smalladmin> selectsmalladminbyname(@Param("dname") String dname, @Param("start") int start, @Param("limit") int limit);
?SmalladminMapper.xml
<select id="countsmalladminbyname" resultType="java.lang.Integer">select count(*)from smalladminwhere sname like concat('%',#{dname},'%')</select><select id="selectsmalladminbyname" resultType="com.homestay.pojo.Smalladmin">select<include refid="Base_Column_List"></include>from smalladminwhere sname like concat('%',#{dname},'%')order by sidlimit #{start},#{limit}</select>測試：
刪除普通管理員
后端代碼：
SmalladminController
/*** 刪除普通管理員* @param sid* @return*/@PostMapping("/delete")@ResponseBodypublic boolean delete(@RequestParam("sid") int sid) {return smalladminService.deletesmalladmin(sid);}
SmalladminService
/*** 刪除普通管理員* @param sid* @return*/boolean deletesmalladmin(int sid);SmalladminServicelpml
/*** 刪除普通管理員* @param sid* @return*/@Overridepublic boolean deletesmalladmin(int sid) {return smalladminMapper.deletesmalladmin(sid);}
SmalladminMapper
/*** 刪除普通管理員* @param sid* @return*/boolean deletesmalladmin(int sid);SmalladminMapper.xml
<delete id="deletesmalladmin">delete from smalladminwhere sid = #{sid,jdbcType=INTEGER}</delete>測試
編輯普通管理員：
前端效果
前端代碼
<body>
<div class="layui-fluid"><div class="layui-row"><div class="layui-form"><div class="layui-form-item"><label class="layui-form-label">普通管理員頭像</label><div class="img-upload-area"><img class="layui-upload-img" id="nphoto" th:src="${session.smallphoto}"><div class="upload-btn-group"><button type="button" class="layui-btn layui-btn-primary" id="choiceImg"><i class="layui-icon"></i>選擇圖片</button><button type="button" class="layui-btn" id="uploadImg"><i class="layui-icon"></i>上傳圖片</button></div></div><p id="uploadErrorText" style="margin-left: 120px; color: var(--error-color);"></p></div><div class="layui-form-item"><label for="sid" class="layui-form-label"><span class="x-red">*</span>普通管理員id</label><div class="layui-input-inline"><input type="text" id="sid" name="sid" class="layui-input" readonly="readonly" th:value="${session.sid}"></div></div><div class="layui-form-item"><label for="updatesmallname" class="layui-form-label"><span class="x-red">*</span>修改登錄名</label><div class="layui-input-inline"><input type="text" id="updatesmallname" name="updatesmallname" lay-verify="required|loginname" class="layui-input" th:value="${sname}"></div></div><div class="layui-form-item"><label for="updatesmallloginpassword" class="layui-form-label"><span class="x-red">*</span>修改登錄密碼</label><div class="layui-input-inline"><input type="password" id="updatesmallloginpassword" name="updatesmallloginpassword" lay-verify="required|updatesmallloginpassword" class="layui-input" th:value="${spassword}"></div></div><div class="layui-form-item"><label for="confirmloginpassword" class="layui-form-label"><span class="x-red">*</span>確認密碼</label><div class="layui-input-inline"><input type="password" id="confirmloginpassword" name="confirmloginpassword" lay-verify="required|confirmloginpassword" class="layui-input"></div></div><div class="layui-form-item"><label class="layui-form-label"></label><button class="layui-btn" lay-filter="submit" lay-submit="" id="submit"><i class="layui-icon"></i> 保存修改</button></div></div></div>
</div>
<script>layui.use(['form', 'layer', 'upload'], function () {$ = layui.jquery;var form = layui.form,upload = layui.upload,layer = layui.layer;// 表單驗證form.verify({required: function(value) {if(value.trim() === '') {return '此項不能為空';}}});//選完文件后不自動上傳var uploadInst = upload.render({elem: '#choiceImg',url: '/smalladmin/upload/updatesmalladminphoto',auto: false,bindAction: '#uploadImg',choose: function (obj) {obj.preview(function (index, file, result) {$('#nphoto').attr('src', result);});},before: function() {layer.load(1, {shade: [0.1, '#fff']});},done: function (res) {layer.closeAll('loading');if (res == true) {layer.msg('上傳成功', {icon: 1});} else {layer.msg('上傳失敗', {icon: 2});}},error: function () {layer.closeAll('loading');var uploadErrorText = $('#uploadErrorText');uploadErrorText.html('<span style="color: var(--error-color);">上傳失敗，請重試</span>');}});//自定義驗證規則form.verify({// oldPwd: function (value) {// var code;// $.ajax({// url: "/admin/password",// type: "GET",// async: false, //關閉異步，當success返回結果后才執行ajax之后的內容// data: {"oldPwd": value},// success: function (s) {// code = s;// }// });// if (code != true) {// return '舊密碼錯誤，請重新輸入！';// }// },updatesmallloginpassword: [/(.+){6,12}$/, '密碼必須6到12位'],confirmloginpassword: function () {if ($('#updatesmallloginpassword').val() != $('#confirmloginpassword').val()) {return '兩次密碼不一致';}}});//監聽提交form.on('submit(submit)', function (data) {var loadIndex = layer.load(2, {shade: [0.1, '#fff']});$.ajax({url: "/smalladmin/updatesmalladmininformation",type: "post",data: data.field,success: function (s) {layer.close(loadIndex);if (s == true) {layer.alert("普通管理員信息修改成功！", {icon: 1,title: '成功',skin: 'layui-layer-molv'}, function () {parent.layer.closeAll();parent.location.reload();});} else {layer.msg("登錄名重復，普通管理員信息修改失敗！", {icon: 2});}},error: function () {layer.close(loadIndex);layer.msg("請求失敗，請檢查網絡連接", {icon: 2});}});return false;});});
</script>
</body>后端代碼：
SmalladminController
/*** 修改普通管理員頁面* @return*/@GetMapping("/updatesmalladminpage")public String updatesmalladminpage(@RequestParam("sid")String sid, @RequestParam("sname")String sname,@RequestParam("spassword")String spassword, HttpSession session,@RequestParam("sphoto")String sphoto, Model model) {model.addAttribute("sid", sid);model.addAttribute("sname", sname);model.addAttribute("spassword", spassword);model.addAttribute("sphoto", sphoto);session.setAttribute("smallphoto",sphoto);session.setAttribute("sid",sid);return "smalladmin/updatesmalladminpage";}/*** 修改普通管理員信息* @param sid* @param sname* @return*/@PostMapping("/updatesmalladmininformation")@ResponseBodypublic boolean updatesmalladmininformation(@RequestParam("sid")String sid,@RequestParam("updatesmallname")String sname,@RequestParam("updatesmallloginpassword")String spassword,HttpSession session){return smalladminService.updatesmalladmin(sid,sname,spassword);}@PostMapping({"/upload/updatesmalladminphoto"})@ResponseBodypublic boolean updatesmalladminphoto(HttpServletRequest request, @RequestParam("file")MultipartFile file, HttpSession session, Model model) throws IOException, URISyntaxException{/*1、給文件起一個新的文件名--------------------*/String suffixName = UploadFileUtils.getSuffixName(file);String newFileName = UploadFileUtils.getNewFileName(suffixName);/*-----------------------------------------*//*2.在本機（或服務器）創建一個文件夾-----------*/String realPath = System.getProperty("user.dir") + "\\upload\\";
//System.getProperty("user.dir")獲取該項目在本機上的絕對路徑，比如“C:\java\demo”
//realPath：圖片在服務器上的物理存儲地址，比如“C:\java\demo\\upload”File fileDirectory = new File(realPath); //在內存中創建文件夾映射對象，比如“C:\java\demo\\upload”File destFile = new File(realPath + newFileName); //在內存中創建文件映射對象，比如“C:\java\demo\\upload\xxxx.jpg”if (!fileDirectory.exists() && !fileDirectory.mkdirs()) {System.out.println("文件夾創建失敗！");return false;}/*-----------------------------------------*//*3.把file以新文件名形式存入本機（或服務器）文件夾-----*/file.transferTo(destFile);/*----------------------------------------------*//*4.創建能訪問該文件的URL地址（不是電腦的物理地址、不是絕對路徑）放入數據庫表-----*/
//new URI()生成一個統一資源定位地址，例如URL，如果語法不正確則拋出異常URI uri = new URI(request.getRequestURL() + "");
//http://localhost:8081/admin/upload/userImg/uri = UploadFileUtils.getHost(uri); //http://localhost:8081String sqlImg = uri + "/upload/" + newFileName; //sqlImg：存入數據庫表中的圖片地址，比如“http://localhost:8081/upload/xxxx.jpg”if (smalladminService.updatesmalladminphoto(session.getAttribute("sid").toString(), sqlImg)) {session.setAttribute("smalladminphoto", sqlImg);return true;} else {return false;}/*--------------------------------------------------------------------*/}SmalladminService
/*** 修改普通管理員信息* @param sid* @param sname* @param spassword* @return*/boolean updatesmalladmin(String sid, String sname, String spassword);/*** 改照片* @param sid* @param sqlImg* @return*/boolean updatesmalladminphoto(String sid, String sqlImg);
SmalladminServicelpml
/*** 修改普通管理員信息* @param sid* @param sname* @param spassword* @return*/@Overridepublic boolean updatesmalladmin(String sid, String sname, String spassword) {try {int countsmalladminname=smalladminMapper.countsmalladminname(sid,sname);//判斷登錄名是否重復if(countsmalladminname>0){throw new RuntimeException("登錄名重復");}} catch (RuntimeException e) {return false;}smalladminMapper.updatesmalladmin(sid,sname,spassword);return true;}/*** 修改頭像* @param sid* @param sqlImg* @return*/@Overridepublic boolean updatesmalladminphoto(String sid, String sqlImg) {return smalladminMapper.updatesmalladminphoto(sid,sqlImg);}SmalladminMapper
/*** 修改頭像* @param sid* @param sqlImg* @return*/boolean updatesmalladminphoto(@Param("sid")String sid,@Param("sqlImg") String sqlImg);/*** 檢查登錄名是否重復* @param sid* @param sname* @return*/int countsmalladminname(@Param("sid")String sid,@Param("sname") String sname);/*** 修改普通管理員信息* @param sid* @param sname* @param spassword*/void updatesmalladmin(@Param("sid") String sid,@Param("sname") String sname,@Param("spassword") String spassword);
SmalladminMapper.xml
<update id="updatesmalladminphoto">update smalladminset sphoto=#{sqlImg}where sid=#{sid}</update><select id="countsmalladminname" resultType="java.lang.Integer">select count(*)from smalladminwhere sname=#{sname} and sid!=#{sid}</select><update id="updatesmalladmin">update smalladminset sname=#{sname},spassword=#{spassword}where sid=#{sid}</update>
測試：
登錄名重復
密碼不一樣
必填項為空
修改成功
的解析)
 — 探針和鉤子)
