String sql = "UPDATE `menu`.`chifood` SET " +"id = '" + menu.getName() + "'," +"price = " + menu.getPrice() + "'," +"amount = '" + menu.getAmount() + "'," +"WHERE id = '" + menu.getId().trim() +"'";(ps:menu是數據庫名，chifood是表名）
3 回答
動漫人物
TA貢獻1815條經驗 獲得超10個贊
price 應該是數值，不需要加‘號，
price = " + menu.getPrice() + "'," （多了一個單引號）
amount = '" + menu.getAmount() + "'," + 也多了一個單引號
String sql = "UPDATE [menu].[chifood] SET " +
"id = '" + menu.getName() + "'," +
"price = " + menu.getPrice() + "," +
"amount = '" + menu.getAmount() + "'," +
"WHERE id = '" + menu.getId().trim() +"'";
牧羊人nacy
TA貢獻1862條經驗 獲得超7個贊
我覺得應該是：
"UPDATE menu.chifood t SET " +
"t.name = '" + menu.getName() + "'," +
" t.price = " + menu.getPrice() + "', " +
" t.amount = '" + menu.getAmount() + "'," +
"WHERE t.id = '" + menu.getId().trim() +"'";
你的"id = '" + menu.getName() + "'," 這個東西id你是使用什么規則的？怎么會把get到的name插入到id上去？
表名上不需要引起來吧。
繁星coding
TA貢獻1797條經驗 獲得超4個贊
改為
String sql = "UPDATE menu.chifood SET " +
"id = '" + menu.getName() + "'," +
"price = "' + menu.getPrice() + "'," +
"amount = '" + menu.getAmount() + "' " +
"WHERE id = '" + menu.getId().trim() +"'";
添加回答
舉報
0/150
提交
取消