From 37011d5918757e6248ba5f0fe0ef8650912d7428 Mon Sep 17 00:00:00 2001 From: lxw <810412026@qq.com> Date: 星期三, 15 十一月 2023 17:09:37 +0800 Subject: [PATCH] 用户升级和降级 --- src/main/java/com/whyc/service/UserInfService.java | 45 +++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 43 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/whyc/service/UserInfService.java b/src/main/java/com/whyc/service/UserInfService.java index 442cdea..a1beb90 100644 --- a/src/main/java/com/whyc/service/UserInfService.java +++ b/src/main/java/com/whyc/service/UserInfService.java @@ -53,7 +53,7 @@ //鍒ゆ柇鏄惁瀛樺湪鏅�氱敤鎴�(uid>100)锛岃嫢鏃�,鍒濆涓�1001 int judgecount=mapper.judgeUname(); if(judgecount==0){ - uinf.setUid(101); + uinf.setUid(1001); } String pwd= RSAUtil.encrypt("123456", RSAUtil.getPublicKey()); uinf.setUsnid(pwd); @@ -125,9 +125,50 @@ request.getSession().setAttribute("user", userDB); return response.setII(1,true, userDB,"鐧诲綍鎴愬姛"); } - + //绛夊嚭 public void logout() { Subject subject = SecurityUtils.getSubject(); subject.logout(); } + //灏嗙敤鎴锋坊鍔犺嚦100~1000绠$悊鍛� + public Response improveRole(int uid) { + //鍒ゆ柇琛ㄦ槸鍚﹀瓨鍦� + String tableName = mapper.existTable(); + if(tableName==null){ + ///鍒涘缓100~1000鐨刬d琛�,涓嶅瓨鍦ㄥ垯鍒涘缓 + mapper.createNumber(); + //鎻掑叆榛樿鏁版嵁 + String sql=" INSERT INTO temp_numbers(unumber) " + + " VALUES "; + for(int i=101;i<=1000;i++){ + sql+="("+i+")"; + if(i!=1000){ + sql+=","; + } + } + mapper.setUnumber(sql); + } + String minUid=mapper.getIn1000(); + if(minUid==null){ + return new Response().set(1,false,"绠$悊鍛樹釜鏁板凡缁忕敤瀹�"); + } + UpdateWrapper wrapper =new UpdateWrapper(); + wrapper.set("uid",minUid); + wrapper.eq("uid",uid); + int flag= mapper.update(null,wrapper); + return new Response().set(1,flag>0,flag>0?"鍗囩骇绠$悊鍛樻垚鍔�":"鍗囩骇涓虹鐞嗗憳澶辫触"); + } + //灏嗙鐞嗗憳鍙樻垚鏅�氱敤鎴� + public Response dropRole(int uid) { + //鏌ヨ鏈�澶х殑uid + String maxUid=mapper.getMaxUid(); + if(maxUid==null){ + maxUid="1001"; + } + UpdateWrapper wrapper =new UpdateWrapper(); + wrapper.set("uid",Integer.valueOf(maxUid)+1); + wrapper.eq("uid",uid); + int flag= mapper.update(null,wrapper); + return new Response().set(1,flag>0,flag>0?"绠$悊鍛樺彉鎴愭櫘閫氱敤鎴锋垚鍔�":"绠$悊鍛樺彉鎴愭櫘閫氱敤鎴峰け璐�"); + } } -- Gitblit v1.9.1