Access 的 insert 语句

[xiaojiit]

Connection conn = null;
Statement stmt = null;
//ResultSet rs = null;

int i = 0;
String sql = "INSERT INTO [dindan] ([username],[phone],[type],[city],[zq],[time1],[huanchecity],[quchefangshi],[huanchemendian],[memory1]) values ('"
+ adindan.getUsername()
+ "','"
+ adindan.getPhone()
+ "','"
+ adindan.getType()
+ "','"
+ adindan.getCity()
+ "','"
+ adindan.getZq()
+ "','"
+ adindan.getTime()
+ "','"
+ adindan.getHuanchecity()
+ "','"
+ adindan.getQuchefangshi()
+ "','"
+ adindan.getHuanchemendian()
+ "','"
+ adindan.getMemory() + "'";

try {
conn = conndb.getConn();
stmt = conn.createStatement();
i = stmt.executeUpdate(sql);

stmt.close();
conndb.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
我这样写怎么提示insert into 语句语法错误呀？谢谢各位了。

[daizheng17]

首先你把这些SQL合在一起生成出来，放到你的数据库中运行一下。马上就能知道你哪里错。可能是空格啊。。什么。

生成SQL语句一看就明白。

[xiaojiit]

呵呵，问题已经解决，谢谢了，少写了个")".

[sxn19811006]

ai

[daizheng17]

遇到SQL错误。这是解决的好办法。其二是调试