我在創建商品添加到數據庫時,使用insertSelective()方法,也設置主鍵自增了,為何會報下面的錯誤,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
請問這個問題最終怎么解決的?