用户管理

whyclxw

2025-05-14 0c7f8a8d3ecc3d9f5467def429650390a3de415a

用户管理

 src/main/java/com/whyc/controller/UserController.java

@@ -23,8 +23,8 @@

    @ApiOperation(value = "查询所有用户信息",notes = "排除uid在100以内的(100以内默认是管理员)")
    @GetMapping("getAllUser")
    public Response getAllUser(@RequestParam(required = false) String uname,@RequestParam(required = false) String realName,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllUser(uname,realName,pageCurr,pageSize);
    public Response getAllUser(@RequestParam(required = false) String uname,@RequestParam int pageCurr, @RequestParam int pageSize){
        return service.getAllUser(uname,pageCurr,pageSize);
    }

    @ApiOperation(value = "查询所有用户信息(不分页除内置用户外用于下拉)")

 src/main/java/com/whyc/mapper/UserMapper.java

@@ -11,7 +11,7 @@
    //判断是否存在普通用户(uid>100)，若无,初始为10001
    int judgeUname();
    //查询所有用户信息
    List<User> getAllUser(@Param("uname") String uname,@Param("realName")String realName);
    List<User> getAllUser(@Param("uname") String uname);
    //查询100~1000中最大的uid
    String getIn10000();
    //创建100~1000的id表,不存在则创建

 src/main/java/com/whyc/service/UserService.java

@@ -50,9 +50,9 @@
    private PermitGroupUserMapper pergroupUserMapper;

    //查询所有用户信息
    public Response getAllUser(String uname, String realName, int pageCurr, int pageSize) {
    public Response getAllUser(String uname, int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        List<User> list=mapper.getAllUser(uname,realName);
        List<User> list=mapper.getAllUser(uname);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"查询所有用户信息");
    }
@@ -68,8 +68,8 @@
        }
        String pwd= RSAUtil.encrypt("123456", RSAUtil.getPublicKey());
        uinf.setPwd(pwd);
        wrapper.select("uid","uname");
        wrapper.eq("uname",uinf.getName());
        wrapper.select("id","name");
        wrapper.eq("name",uinf.getName());
        User user=mapper.selectOne(wrapper);
        if(user!=null){
            return new Response().setII(1,false,user,"用户名已存在");
@@ -134,16 +134,16 @@
        }else {
            int uid=User.getId();
            UpdateWrapper wrapper=new UpdateWrapper();
            wrapper.eq("uname",uname);
            wrapper.eq("name",uname);
            int bl=mapper.delete(wrapper);
            if(bl>0){
                //删除权限组下的用户
                UpdateWrapper wrapper1=new UpdateWrapper();
                wrapper1.eq("uid",uid);
                wrapper1.eq("id",uid);
                pergroupUserMapper.delete(wrapper1);
                //删除包机组下的用户
                UpdateWrapper wrapper2=new UpdateWrapper();
                wrapper2.eq("uid",uid);
                wrapper2.eq("id",uid);
                bjgroupUsrMapper.delete(wrapper2);
            }
            return new Response().setII(1,bl>0,bl,"删除成功");
@@ -209,8 +209,8 @@
            return new Response().set(1,false,"管理员个数超过上限");
        }
        UpdateWrapper wrapper =new UpdateWrapper();
        wrapper.set("uid",minUid);
        wrapper.eq("uid",uid);
        wrapper.set("id",minUid);
        wrapper.eq("id",uid);
        int flag= mapper.update(null,wrapper);
        return new Response().set(1,flag>0,flag>0?"身份变更成功":"身份变更失败");
    }
@@ -223,13 +223,13 @@
        }
        //根据用户id查询用户信息
        QueryWrapper qWrapper=new QueryWrapper();
        qWrapper.eq("uid",uid);
        qWrapper.eq("id",uid);
        qWrapper.last("limit 1");
        User uinf=mapper.selectOne(qWrapper);
        //编辑
        UpdateWrapper wrapper =new UpdateWrapper();
        wrapper.set("uid",Integer.valueOf(maxUid)+1);
        wrapper.eq("uid",uid);
        wrapper.set("id",Integer.valueOf(maxUid)+1);
        wrapper.eq("id",uid);
        int flag= mapper.update(null,wrapper);
        //如果是普通用户自己强退，将用户名对应的sessionId变更
        ServletContext servletContext = request.getServletContext();
@@ -239,7 +239,7 @@

    public Response getUserNameList() {
        QueryWrapper<User> query = Wrappers.query();
        query.select("uname");
        query.select("name");
        List<String> userNameList = mapper.selectList(query).stream().map(User::getName).collect(Collectors.toList());
        return new Response().set(1,userNameList);
    }
@@ -274,10 +274,9 @@
    //查询所有用户信息(不分页用于下拉)
    public Response getUinf() {
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.select("uid","uname","urole");
        wrapper.gt("uid",100);
        //wrapper.eq("urole",0);//普通用户
        wrapper.orderByAsc("uid");
        wrapper.select("id","name");
        wrapper.gt("id",100);
        wrapper.orderByAsc("id");
        List<User> list=mapper.selectList(wrapper);
        return new Response().setII(1,list!=null,list,"查询所有用户信息(不分页用于下拉)");
    }
@@ -301,21 +300,12 @@

        return new Response().set(1,true,"编辑用户信息成功");
    }
    //根据Ukey查询用户
    public User getUserByUKeyId(String ukeyId){
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.select("uid","uname","real_name","urole","create_time","phone_number","address","face_id","ukey_id");
        queryWrapper.eq("ukey_id",ukeyId);
        queryWrapper.last("limit 1");
        User User = mapper.selectOne(queryWrapper);
        return User;
    }

    //根据uname查询用户
    public User getUserByUserName(String uname){
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.select("uid","uname","real_name","urole","create_time","phone_number","address","face_id","ukey_id");
        queryWrapper.eq("uname",uname);
        queryWrapper.select("id","name","create_time","phone_number");
        queryWrapper.eq("name",uname);
        queryWrapper.last("limit 1");
        User User = mapper.selectOne(queryWrapper);
        return User;

 src/main/resources/mapper/UserMapper.xml

@@ -46,7 +46,7 @@
        FROM db_user.tb_user  where id>10000
    </select>
    <select id="getUinfByUname" resultType="com.whyc.pojo.db_user.User">
        select name,id from db_user.tb_user where name=#{name} limit 1
        select name,id from db_user.tb_user where name=#{uname} limit 1
    </select>
    <select id="getBaojiUserByUid" resultType="com.whyc.pojo.db_user.User">
        SELECT id,name FROM  db_user.tb_user