Question

ResultSet rs = sm.executeQuery("select * from user_"+tablename+"where username='"+username+"';");

我在执行是总是报错：
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 ’'=lily'‘ at line 1

Answer 1

去掉你那个分号就可以了。

Answer 2

楼上正解 +1

Answer 3

引号用错了

追问

关键是：我原句复制到client里运行就没有问题！