                        课程
                    
                        /后端开发
                        
                            /Java
                        
                        /SpringBoot构建电商基础秒杀项目

自己在后台拼凑一个userModel，但是数据插入失败

上面是拼凑好的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喝喝茶？

斯基姆斯

2019-01-21

源自：SpringBoot构建电商基础秒杀项目 3-11

关注问题我要回答

2029

操作

收起

1 回答

斯基姆斯提问者
2019-01-21

解决了，就是下面标黑的两个变量调换了，弄得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;
}