部分程序如下:
Connection con = null;
Statement sm = null;
....
sm = con.createStatement();
sm.executeUpdate("delete from test_table1");
String s = "hello";
sm.executeUpdate("insert into test_table1(name0) values("+ s +")");
sm.executeUpdate("insert into test_table1(name1) values("+ s +")");
错误提示:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'hello' in 'field list
这错误是什么意思呢??
------解决方案--------------------
sm.executeUpdate("insert into test_table1(name1) values('"+ s +"')"); 试试