我在創(chuàng)建商品添加到數(shù)據(jù)庫時(shí),使用insertSelective()方法,也設(shè)置主鍵自增了,為何會(huì)報(bào)下面的錯(cuò)誤,xml文件是代碼生成器生成的,useGeneratedKeys和keyProperty我也寫了
### The error may involve com.miaosha.dao.ItemMapper.insertSelective-Inline### The error occurred while setting parameters### SQL: > ? ? ? ? ?insert into item ? ? ?( title, ? ? ? ? ? ? ? ? ? ? ? price, ? ? ? ? ? ? ? ? ? ? ? description, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?img_url ) ? ? ? values ( ?, ? ? ? ? ? ? ? ? ? ? ? ?, ? ? ? ? ? ? ? ? ? ? ? ?, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>?
?insert into item ? ? ( title, ? ? ? ? ? ? ? ? ? ?price, ? ? ? ?' 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 MariaDB server version for the right syntax to use near '>
?insert into item ? ? ( title, ? ? ? ? ? ? ? ? ? ?price, ? ? ? ?' at line 1]
2020-05-23
請問這個(gè)問題最終怎么解決的？