| | |
| | | public UserInf findPasswordByUserName(String userName) { |
| | | UserInf userInf = null; |
| | | QueryWrapper<UserInf> queryWrapper = Wrappers.query(); |
| | | queryWrapper.select("uid","uname","usnid","udownload_role").eq("uname",userName); |
| | | queryWrapper.select("uid","uname","usnid","urole").eq("uname",userName); |
| | | userInf = userMapper.selectOne(queryWrapper); |
| | | |
| | | return userInf==null?new UserInf(0,"用户不存在"):userInf; |
| | |
| | | //查询所有用户信息(不分页用于包机组) |
| | | public Response getUinf() { |
| | | QueryWrapper wrapper=new QueryWrapper(); |
| | | wrapper.select("uid","uname","udownload_role"); |
| | | wrapper.select("uid","uname","urole"); |
| | | wrapper.orderByAsc("uid"); |
| | | List<UserInf> list=mapper.selectList(wrapper); |
| | | return new Response().setII(1,list!=null,list,"查询所有用户信息(不分页用于包机组)"); |
| | |
| | | .map(AreaInf::getAreaUname) // 提取名字 |
| | | .collect(Collectors.toList()); // 转换为列表*/ |
| | | QueryWrapper wrapper=new QueryWrapper(); |
| | | wrapper.select("uname","uid","real_name","udownload_role","create_time"); |
| | | wrapper.select("uname","uid","real_name","urole","create_time"); |
| | | wrapper.eq("area_id",0); |
| | | wrapper.gt("uid",100); |
| | | List<UserInf> list=mapper.selectList(wrapper); |
| | |
| | | select count(*) from db_user.tb_user_inf where uid>100 |
| | | </select> |
| | | <select id="getAllUser" resultType="UserInf"> |
| | | select uid,uname,udownload_role,create_time from db_user.tb_user_inf |
| | | select uid,uname,urole,create_time from db_user.tb_user_inf |
| | | <where> |
| | | 1=1 |
| | | <if test="uname!=null"> |