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

源自：3-11 用户模型管理--用户注册功能实现02

自己在后台拼凑一个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 16:43

个回答

斯基姆斯: 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;
}