加上con.setAutoCommit(false);后编译通过,运行时出现错误如下: java.sql.SQLException: [Microsoft][ODBC Microsoft Access 驱动程序]现在无法设置属性 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:4458) at sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(JdbcOdbcConnection.java:649) at bysj.Query.del_mes_in(Query.java:129) at bysj.Query.main(Query.java:150)
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:XXXX"); conn.setAutoCommit(false); PreparedStatement stmt1 = con.prepareStatement( "delete from mes_in where id like ?"); stmt1.setString(1,id); stmt1.executeUpdate(); con.commit(); } catch(SQLException e){ conn.rollback(); }
java.sql.SQLException: [Microsoft][ODBC Microsoft Access 驱动程序]现在无法设置属性 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:4458) at sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(JdbcOdbcConnection.java:649) at bysj.Query.del_mes_in(Query.java:129) at bysj.Query.main(Query.java:150)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:XXXX");
conn.setAutoCommit(false);
PreparedStatement stmt1 = con.prepareStatement(
"delete from mes_in where id like ?");
stmt1.setString(1,id);
stmt1.executeUpdate();
con.commit();
}
catch(SQLException e){
conn.rollback();
}