自己在后臺拼湊一個userModel,但是數(shù)據(jù)插入失敗
上面是拼湊好的userModel,傳給userServiceImpl,執(zhí)行到下面這一步就。。。。
報錯如下:
=======================================================================
2019-01-21 16:32:45.673? WARN 13744 --- [nio-8080-exec-2] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.jdbc.BadSqlGrammarException:?
### Error updating database.? Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
### The error may involve com.miaoshaproject.dao.UserDOMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into user_info
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
=======================================================================
這報錯什么鬼?我是誰?我在哪里?我要不要找UserDOMapper.insertSelective喝喝茶?
2019-01-21
解決了,就是下面標(biāo)黑的兩個變量調(diào)換了,弄得userDO里的變量都為null,在寫入mysql時報錯如題所示