往access中插入数据出错
代码如下:
private final String insert_gb =
"insert into guestbook(id,title,body,poster,time) values (?,?,?,?,?)";
public void insert(GuestBook info){
Connection con = null;
PreparedStatement pstmt = null;
//Statement stmt = null;
ResultSet rs = null;
GuestBook gb = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:guestbook","","");
System.out.println("begin");
pstmt = con.prepareStatement(insert_gb);
//stmt = con.createStatement();
pstmt.setInt(1,info.getId());
System.out.println("1");
pstmt.setString(2,info.getTitle());
System.out.println("2");
pstmt.setString(3,info.getBody());
System.out.println("3");
pstmt.setString(4,info.getposter());
System.out.println("4");
pstmt.setString(5,String.valueOf(info.getTime()));
System.out.println("5");
pstmt.executeUpdate();
}
catch(Exception e){
//System.out.println(e.getMessage());
e.printStackTrace();
}
finally{
try{
con.close();
pstmt.close();
}
catch(Exception e){
}
}
}
执行到System.out.println("5");都没有问题,但executeupdate出错。
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语
句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3104)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedState
ment.java:214)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPrepare
dStatement.java:136)
at GuestBookMap.insert(GuestBookMap.java:99)
at GuestBookManager.insert_gb(GuestBookManager.java:16)
at GuestBookManager.main(GuestBookManager.java:12)
请各位帮忙看看,谢了