oracle会话关闭自动提交,JDBC 关闭数据库连接与自动提交【转】

最新推荐文章于 2025-02-08 16:28:58 发布

转载最新推荐文章于 2025-02-08 16:28:58 发布 · 914 阅读

文章标签：

#oracle会话关闭自动提交

本文详细探讨了在使用JDBC操作Oracle数据库时，关于关闭连接时的自动提交行为。通过示例代码展示了如何关闭自动提交，并在不提交事务时，关闭连接会触发默认提交。此外，还解释了在未明确提交事务的情况下，数据库操作会默认立即提交的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

// Jdbc关闭数据库连接时,会隐含一个提交事务的操作

private final static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";

private final static String DB_CONNECTION = "jdbc:oracle:thin:@127.0.0.1:1521:mydb01";

private final static String DB_NAME = "scott";

private final static String DB_PWd = "scott";

//jdbc关闭自动提交. 在对数据库的操作未提交时,当conn.close()时,会默认先提交事务,再关闭连接.

public static void test1() {

Connection conn = null;

CallableStatement callStmt = null;

PreparedStatement ps = null;

try {

Class.forName(DB_DRIVER);

conn = DriverManager.getConnection(DB_CONNECTION, DB_NAME, DB_PWd);

conn.setAutoCommit(false); //关闭自动提交

ps = conn.prepareStatement("insert into t_user values (?, ?, ?)");

ps.setString(1, "1");

ps.setString(2, "1");

ps.setString(3, "1");

int results = ps.executeUpdate();

//conn.commit();//不手动提交

System.out.println("插入了" + results + "条: ");

} catch (Exception e) {

try {

conn.rollback();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

e.printStackTrace(System.out);

} finally {

try {

conn.setAutoCommit(true);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if (null != callStmt) {

try {

callStmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if (null != conn) {

try {

conn.close();// jdbc关闭自动提交. 在jdbc未提交时,当conn.close()时,会默认先提交事务,再关闭连接.

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

//jdbc默认自动提交. 在对数据库的操作未手动提交时,也会立即提交到数据库并生效

public static void test2() {

Connection conn = null;

CallableStatement callStmt = null;

PreparedStatement ps = null;

try {

Class.forName(DB_DRIVER);

conn = DriverManager.getConnection(DB_CONNECTION, DB_NAME, DB_PWd);

// conn.setAutoCommit(false); //jdbc默认自动提交

ps = conn.prepareStatement("insert into t_user values (?, ?, ?)");

ps.setString(1, "1");

ps.setString(2, "1");

ps.setString(3, "1");

int results = ps.executeUpdate(); //注意,这一步操作就被提交到数据库了!!!

//conn.commit();//不手动提交

System.out.println("插入了" + results + "条: ");

} catch (Exception e) {

try {

conn.rollback();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

e.printStackTrace(System.out);

} finally {

try {

conn.setAutoCommit(true);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if (null != callStmt) {

try {

callStmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

if (null != conn) {

try {

conn.close();// jdbc关闭连接

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}