Where id = 12

Question

update fb_plist set inventory = "+txtInventory.getText()+" Where id = 12；

 

报错java.sql.SQLSyntaxErrorException: 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 'Where id = 12' at line 1

Answer 1

双引号两边加上单引号就正常了，改为如下代码：

String sql = "update fb_plist set inventory = '"+txtInventory.getText()+"' Where id = 12"；