[问答] 大佬们，在后端48节的时候评论出错，说是user_id不能为空，我查看了user_id是有数据的，望大佬告知！ BUGHibernate:insertintotb_refresh_token(create_time,refresh_token,token_key,update_time,user_id,id)values(?,?,?,?,?,?)Hibernate:insertintotb_comment(article_id,content,create_time,parent_content,state,update_time,user_avatar,user_id,user_name,id)values(?,?,?,?,?,?,?,?,?,?)[2021/02/03-11:58:22][http-nio-8080-exec-6][WARN][org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:SQLError:1048,SQLState:23000[2021/02/03-11:58:22][http-nio-8080-exec-6][ERROR][org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:Column'user_id'cannotbenull[2021/02/03-11:58:22][http-nio-8080-exec-6][ERROR][org.hibernate.internal.ExceptionMapperStandardImpl]:HHH000346:Errorduringmanagedflush[org.hibernate.exception.ConstraintViolationException:couldnotexecutestatement][2021/02/03-11:58:22][http-nio-8080-exec-6][ERROR][org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/].[dispatcherServlet]]:Servlet.service()forservlet[dispatcherServlet]incontextwithpath[]threwexception[Requestprocessingfailed;nestedexceptionisorg.springframework.dao.DataIntegrityViolationException:couldnotexecutestatement;SQL[n/a];constraint[null];nestedexceptionisorg.hibernate.exception.ConstraintViolationException:couldnotexecutestatement]withrootcausecom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:Column'user_id'cannotbenull源码/****@paramresponse*@paramuserFromDb*@return返回token_key*/privateStringcreateToken(HttpServletResponseresponse,SobUseruserFromDb){intdeleteResult=refreshTokenDao.deleteAllByUserId(userFromDb.getId());log.info("deleteResultofrefreshtoken..."+deleteResult);//生成tokenMap<String,Object>claims=newClaimsUtils().sobUser2Claims(userFromDb);//token默认是两个小时Stringtoken=JwtUtil.createToken(claims);//返回token的md5的值，token会保存到redis里//前端访问的时候，携带token的md5key，从redis中获取即可StringtokenKey=DigestUtils.md5DigestAsHex(token.getBytes());//保存到redis中，有效期是2小时，key是tokenKeyredisUtils.set(Constants.User.KEY_TOKEN+tokenKey,token,Constants.TimeValue.HOUR_2);//把tokenKey写到cookies里面//这个要动态获取，可以从request里面获取//后面提供一个工具类使用CookieUtils.setUpCookie(response,Constants.User.COOKIE_TOKE_KEY,tokenKey);//生成refreshTokenStringrefreshTokenValue=JwtUtil.createRefreshToken(userFromDb.getId(),Constants.TimeValue.MONTH);//TODO:保存到数据库里面//refreshToken,tokenKey,用户ID，创建时间，更新时间RefreshTokenrefreshToken=newRefreshToken();refreshToken.setId(idWorker.nextId()+"");refreshToken.setRefreshToken(refreshTokenValue);refreshToken.setUserId(userFromDb.getId());refreshToken.setTokenKey(tokenKey);refreshToken.setCreateTime(newDate());refreshToken.setUpdateTime(newDate());refreshTokenDao.save(refreshToken);returntokenKey;}/***本质：通过携带的token_key检查用户是否有登陆，如果登陆就返回用户信息*@paramrequest*@paramresponse*@return*/@OverridepublicSobUsercheckSobUser(HttpServletRequestrequest,HttpServletResponseresponse){//拿到token_keyStringtokenKey=CookieUtils.getCookie(request,Constants.User.COOKIE_TOKE_KEY);log.info("checkSobUsertokenKey==>"+tokenKey);SobUsersobUser=parseByTokenKey(tokenKey);if(sobUser==null){//1、说明解析出错，token过期了,去mysql查询refreshTokenRefreshTokenrefreshToken=refreshTokenDao.findOneByTokenKey(tokenKey);//2、如果不存在，就是当前访问没有登陆if(refreshToken==null){log.info("refreshtokenisnull...");returnnull;}//3、如果存在，就解析refreshTokentry{JwtUtil.parseJWT(refreshToken.getRefreshToken());//5、如果refreshToken有效，创建新的token，和新的refreshTokenStringuserId=refreshToken.getUserId();SobUseruserFromDb=userDao.findOneById(userId);//删掉refreshToken的记录StringnewTokenKey=createToken(response,userFromDb);//返回tokenlog.info("createnewtokenandrefreshtoken...");returnparseByTokenKey(newTokenKey);}catch(Exceptione1){log.info("refreshtokenis过期...");//4、如果refreshToken过期了，提示当前访问没有登陆，提示用户登录returnnull;}}returnsobUser;}privateSobUserparseByTokenKey(StringtokeKey){Stringtoken=(String)redisUtils.get(Constants.User.KEY_TOKEN+tokeKey);log.info("parseByTokenKeytoken==>"+token);if(token!=null){//不为空，解析tokentry{Claimsclaims=JwtUtil.parseJWT(token);returnClaimsUtils.claims2SobUser(claims);}catch(Exceptione){log.info("parseByTokenKey==>"+tokeKey+"token过期了...");returnnull;}}returnnull;}@PostMapping("/comment")publicResponseResulttestComment(@RequestBodyCommentcomment,HttpServletRequestrequest,HttpServletResponseresponse){Stringcontent=comment.getContent();log.info("commentcontent==>"+content);//还有得知评论的是谁，对这个评论，身份进行确定StringtokenKey=CookieUtils.getCookie(request,Constants.User.COOKIE_TOKE_KEY);if(tokenKey==null){returnResponseResult.FAILED("账号未登录");}SobUsersobUser=userService.checkSobUser(request,response);if(sobUser==null){returnResponseResult.FAILED("账号未登录");}comment.setUserId(sobUser.getId());comment.setUserAvatar(sobUser.getAvatar());comment.setUserName(sobUser.getUserName());comment.setCreateTime(newDate());comment.setUpdateTime(newDate());comment.setId(idWorker.nextId()+"");commentDao.save(comment);returnResponseResult.SUCCESS("评论成功!");}是我数据库的原因吗？
