如下是sql的update语句语法报错，请问该怎么解决？

Question

String sql = "UPDATE `menu`.`chifood` SET " +"id = '" + menu.getName() + "'," +"price = " + menu.getPrice() + "'," +"amount = '" + menu.getAmount() + "'," +"WHERE id = '" + menu.getId().trim() +"'";(ps:menu是数据库名，chifood是表名）

Answer 1

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

Answer 2

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

Answer 3

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