自己在后台拼凑一个userModel，但是数据插入失败
斯基姆斯
2019-01-21 16:43
上面是拼凑好的userModel，传给userServiceImpl，执行到下面这一步就。。。。
报错如下：
=======================================================================
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喝喝茶？
1回答
-
- 斯基姆斯
- 2019-01-21 18:31:22
解决了，就是下面标黑的两个变量调换了，弄得userDO里的变量都为null，在写入mysql时报错如题所示
// 实现userModel->user data object方法 private UserDO convertFromUserModel(UserModel userModel) { if (userModel == null) { return null; } UserDO userDO = new UserDO(); // 将userModel的属性赋予给userDO BeanUtils.copyProperties(); return userDO; }
SpringBoot构建电商基础秒杀项目
49065 学习 · 954 问题
相似问题