请高手帮忙看下这条sql语句

Java code:

String sql = "insert into merchant_extra_setting (setting) values ('"+this.Action+this.Time+"') where merchant_id='" + merchant_id + "'";



我加了where merchant_id='" + merchant_id + "' 这段        merchant_id关联之后就报错了，为什么呢


Java code:

String sql = "update merchant_extra_setting set setting = '"+this.Action+this.Time+"'" +
"' where merchant_id='" + merchant_id + "'";



update的也是一样加了merchant_id关联之后就报错

---

String sql = "insert into merchant_extra_setting (setting) values ('"+this.Action+this.Time+"') where merchant_id='" + merchant_id + "'";
System.out.println("sql is :"+sql);
把打印出来sql看看有没有问题

另外报错，报什么错啊？也不说明白点

---

先打印出来
看看sql语句可有错

---

报什么错吗，不一定这里报错啊，可能你取 merchant_id 的值的时候就报错了啊。

---

sql is :insert into merchant_extra_setting (setting) values ('confirm23')where merchant_id=''

---

You have an error in your SQL syntax