删除和查找用户等功能

前言

🌞博主介绍：✌CSDN特邀作者、
多个成功系统案例：

代码参考

// 忽略权限验证的注解@IgnoreAuth@PostMapping(value ="/login")publicRlogin(Stringusername,Stringpassword,Stringcaptcha,HttpServletRequestrequest){// 查询用户信息UsersEntityuser =userService.selectOne(newEntityWrapper<UsersEntity>().eq("username",username));// 判断用户是否存在或密码是否正确if(user==null||!user.getPassword().equals(password)){returnR.error("账号或密码不正确");}// 生成tokenStringtoken =tokenService.generateToken(user.getId(),username,"users",user.getRole());returnR.ok().put("token",token);}// 生成token@OverridepublicStringgenerateToken(Longuserid,Stringusername,StringtableName,Stringrole){// 查询是否存在已有tokenTokenEntitytokenEntity =this.selectOne(newEntityWrapper<TokenEntity>().eq("userid",userid).eq("role",role));// 生成随机token字符串Stringtoken =CommonUtil.getRandomString(32);// 设置token过期时间为1小时后Calendarcal =Calendar.getInstance();cal.setTime(newDate());cal.add(Calendar.HOUR_OF_DAY,1);if(tokenEntity!=null){// 更新token信息tokenEntity.setToken(token);tokenEntity.setExpiratedtime(cal.getTime());this.updateById(tokenEntity);}else{// 新建token记录this.insert(newTokenEntity(userid,username,tableName,role,token,cal.getTime()));}returntoken;}/** * 权限(Token)验证拦截器 */@ComponentpublicclassAuthorizationInterceptorimplementsHandlerInterceptor{// 定义Token在请求Header中的键名publicstaticfinalStringLOGIN_TOKEN_KEY ="Token";@AutowiredprivateTokenServicetokenService;@OverridepublicbooleanpreHandle(HttpServletRequestrequest,HttpServletResponseresponse,Objecthandler)throwsException{// 支持跨域请求response.setHeader("Access-Control-Allow-Methods","POST, GET, OPTIONS, DELETE");response.setHeader("Access-Control-Max-Age","3600");response.setHeader("Access-Control-Allow-Credentials","true");response.setHeader("Access-Control-Allow-Headers","x-requested-with,request-source,Token, Origin,imgType, Content-Type, cache-control,postman-token,Cookie, Accept,authorization");response.setHeader("Access-Control-Allow-Origin",request.getHeader("Origin"));// 跨域时会首先发送一个OPTIONS请求，这里我们给OPTIONS请求直接返回正常状态if(request.getMethod().equals(RequestMethod.OPTIONS.name())){response.setStatus(HttpStatus.OK.value());returnfalse;}// 获取HandlerMethod注解IgnoreAuthannotation;if(handler instanceofHandlerMethod){annotation =((HandlerMethod)handler).getMethodAnnotation(IgnoreAuth.class);}else{returntrue;}// 从header中获取tokenStringtoken =request.getHeader(LOGIN_TOKEN_KEY);/**         * 不需要验证权限的方法直接放过         */if(annotation!=null){returntrue;}// 根据token获取token实体TokenEntitytokenEntity =null;if(StringUtils.isNotBlank(token)){tokenEntity =tokenService.getTokenEntity(token);}if(tokenEntity !=null){// 将用户信息存入sessionrequest.getSession().setAttribute("userId",tokenEntity.getUserid());request.getSession().setAttribute("role",tokenEntity.getRole());request.getSession().setAttribute("tableName",tokenEntity.getTablename());request.getSession().setAttribute("username",tokenEntity.getUsername());returntrue;}// 验证失败，返回401错误和提示信息PrintWriterwriter =null;response.setCharacterEncoding("UTF-8");response.setContentType("application/json; charset=utf-8");try{writer =response.getWriter();writer.print(JSONObject.toJSONString(R.error(401,"请先登录")));}finally{if(writer !=null){writer.close();}}returnfalse;}}

数据库参考

DROPTABLEIFEXISTS`address`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATETABLE`address`(`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT'主键',`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT'创建时间',`userid`bigint(20)NOTNULLCOMMENT'用户id',`address`varchar(200)NOTNULLCOMMENT'地址',`name`varchar(200)NOTNULLCOMMENT'收货人',`phone`varchar(200)NOTNULLCOMMENT'电话',`isdefault`varchar(200)NOTNULLCOMMENT'是否默认地址[是/否]',PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=9DEFAULTCHARSET=utf8 COMMENT='地址';DROPTABLEIFEXISTS`forum`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATETABLE`forum`(`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT'主键',`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT'创建时间',`title`varchar(200)DEFAULTNULLCOMMENT'帖子标题',`content`longtextNOTNULLCOMMENT'帖子内容',`parentid`bigint(20)DEFAULTNULLCOMMENT'父节点id',`userid`bigint(20)NOTNULLCOMMENT'用户id',`username`varchar(200)DEFAULTNULLCOMMENT'用户名',`avatarurl`longtextCOMMENT'头像',`isdone`varchar(200)DEFAULTNULLCOMMENT'状态',`istop`int(11)DEFAULT'0'COMMENT'是否置顶',`toptime`datetimeDEFAULTNULLCOMMENT'置顶时间',PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=79DEFAULTCHARSET=utf8 COMMENT='交流论坛';DROPTABLEIFEXISTS`yonghu`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATETABLE`yonghu`(`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT'主键',`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT'创建时间',`zhanghao`varchar(200)NOTNULLCOMMENT'账号',`mima`varchar(200)NOTNULLCOMMENT'密码',`xingming`varchar(200)NOTNULLCOMMENT'姓名',`xingbie`varchar(200)DEFAULTNULLCOMMENT'性别',`shouji`varchar(200)DEFAULTNULLCOMMENT'手机',`touxiang`longtextCOMMENT'头像',`jf`doubleDEFAULT'0'COMMENT'积分',`money`doubleDEFAULT'0'COMMENT'余额',PRIMARYKEY(`id`),UNIQUEKEY`zhanghao`(`zhanghao`))ENGINE=InnoDBAUTO_INCREMENT=19DEFAULTCHARSET=utf8 COMMENT='用户';

– 向数据库插入数据示例

INSERTINTO`product`(`name`,`price`,`description`,`stock`)VALUES('iPhone 13',999.99,'A powerful and advanced smartphone',100);INSERTINTO`product`(`name`,`price`,`description`,`stock`)VALUES('Samsung Galaxy S21',899.99,'A flagship Android smartphone',150);INSERTINTO`product`(`name`,`price`,`description`,`stock`)VALUES('Sony PlayStation 5',499.99,'Next-gen gaming console',50);

测试用例参考

另外，本系统还进行了用户管理功能的测试。就业辅导、资深全栈开发程序员，曾在互联网大厂担任高级职位、我们将继续进行测试工作，发现并修复潜在问题，为用户提供功能完善的系统体验。MyBatis的核心思想是将SQL语句和Java代码分离，通过XML或注解的方式来描述数据库操作，从而实现了数据访问层的解耦和灵活性。更新等操作更加灵活和可控。