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