默认的话为自动提交,
当没执行一个update ,delete或者insert的时候都会自动提交到数据库,无法回滚事务。
设置connection.setautocommit(false);只有程序调用connection.commit()的时候才会将先前执行的语句一起提交到数据库,这样就实现了数据库的事务。
当没执行一个update ,delete或者insert的时候都会自动提交到数据库,无法回滚事务。
设置connection.setautocommit(false);只有程序调用connection.commit()的时候才会将先前执行的语句一起提交到数据库,这样就实现了数据库的事务。
true:sql命令的提交(commit)由驱动程序负责 false:sql命令的提交由应用程序负责,程序必须调用commit或者rollback方法
setAutoCommit
void setAutoCommit(boolean autoCommit) throws SQLException
Sets this connection's auto-commit mode to the given state. If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the methodcommit
or the methodrollback
. By default, new connections are in auto-commit mode.The commit occurs when the statement completes. The time when the statement completes depends on the type of SQL Statement:
- For DML statements, such as Insert, Update or Delete, and DDL statements, the statement is complete as soon as it has finished executing.
- For Select statements, the statement is complete when the associated result set is closed.
- For
CallableStatement
objects or for statements that return multiple results, the statement is complete when all of the associated result sets have been closed, and all update counts and output parameters have been retrieved.
NOTE: If this method is called during a transaction and the auto-commit mode is changed, the transaction is committed. If
setAutoCommit
is called and the auto-commit mode is not changed, the call is a no-op.-
Parameters:
-
autoCommit
-true
to enable auto-commit mode;false
to disable it
Throws:
-
SQLException
- if a database access error occurs, setAutoCommit(true) is called while participating in a distributed transaction, or this method is called on a closed connection
See Also:
-
getAutoCommit()