2019-06-03 21:56:29.690? WARN 36608 --- [nio-8080-exec-3] .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.UserPasswordDOMapper.insertSelective-Inline

### The error occurred while setting parameters

### SQL: insert into user_password

### 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]

上面是報(bào)的錯(cuò)

<insert?id="insertSelective"?parameterType="com.miaoshaproject.dataObject.UserPasswordDO">
??insert?into?user_password
??<trim?prefix="("?suffix=")"?suffixOverrides=",">
????<if?test="id?!=?null">
??????id,
????</if>
????<if?test="encrptPassword?!=?null">
??????encrpt_password,
????</if>
????<if?test="userId?!=?null">
??????user_id,
????</if>
??</trim>
??<trim?prefix="values?("?suffix=")"?suffixOverrides=",">
????<if?test="id?!=?null">
??????#{id,jdbcType=INTEGER},
????</if>
????<if?test="encrptPassword?!=?null">
??????#{encrptPassword,jdbcType=VARCHAR},
????</if>
????<if?test="userId?!=?null">
??????#{userId,jdbcType=INTEGER},
????</if>
??</trim>
</insert>

上面是我對(duì)應(yīng)的mappper里面的sql語(yǔ)句

這個(gè)是本人創(chuàng)建的數(shù)據(jù)庫(kù)

class?UserPasswordDO?{
????private?Integer?id;

????private?String?encrptPassword;

????private?Integer?userId;

????public?UserPasswordDO(Integer?id,?String?encrptPassword,?Integer?userId)?{
????????this.id?=?id;
????????this.encrptPassword?=?encrptPassword;
????????this.userId?=?userId;
????}

????public?UserPasswordDO()?{
????????super();
????}

????public?Integer?getId()?{
????????return?id;
????}

????public?void?setId(Integer?id)?{
????????this.id?=?id;
????}

????public?String?getEncrptPassword()?{
????????return?encrptPassword;
????}

????public?void?setEncrptPassword(String?encrptPassword)?{
????????this.encrptPassword?=?encrptPassword?==?null???null?:?encrptPassword.trim();
????}

????public?Integer?getUserId()?{
????????return?userId;
????}

????public?void?setUserId(Integer?userId)?{
????????this.userId?=?userId;
????}
}

這是對(duì)應(yīng)的dataObjext?

難受啊