【java】sql的update语句语法报错

答案:4 悬赏:0

解决时间 2021-03-05 20:44

提问者网友：枫涩帘淞幕雨
2021-03-05 13:43

String sql = "UPDATE `menu`.`chifood` SET " +
"id = '" + menu.getName() + "'," +
"price = " + menu.getPrice() + "'," +
"amount = '" + menu.getAmount() + "'," +
"WHERe id = '" + menu.getId().trim() +"'";

(ps:menu是数据库名，chifood是表名）

最佳答案

二级知识专家网友：而你却相形见绌
2021-03-05 15:15

我觉得应该是：
"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上去？
表名上不需要引起来吧。

全部回答

1楼网友：瘾与深巷
2021-03-05 18:12

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() +"'";

2楼网友：飘零作归宿
2021-03-05 17:08

改为 String sql = "UPDATE menu.chifood SET " + "id = '" + menu.getName() + "'," + "price = "' + menu.getPrice() + "'," + "amount = '" + menu.getAmount() + "' " + "WHERe id = '" + menu.getId().trim() +"'";

3楼网友：桃花别处起长歌
2021-03-05 16:45

确定各列的类型，如果是数值类型则不能加''

我要举报

如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！