在Java中如何使用try-with-resources安全关闭数据库连接_数据库资源异常处理技巧

String url = "jdbc:mysql://localhost:3306/testdb";
String user = "root";
String password = "123456";
<p>try (Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT id, name FROM users")) {</p><pre class='brush:java;toolbar:false;'>while (rs.next()) {
    System.out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name"));
}

try (Connection conn = getConnection()) {
    String sql = "SELECT * FROM users WHERE age > ?";
    try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setInt(1, 18);
        try (ResultSet rs = pstmt.executeQuery()) {
            while (rs.next()) {
                // 处理结果
            }
        }
    }
} catch (SQLException e) {
    // 统一异常处理
}

public class DatabaseUtil implements AutoCloseable {
    private Connection conn;
<pre class='brush:java;toolbar:false;'>public DatabaseUtil(String url, String user, String pwd) throws SQLException {
    this.conn = DriverManager.getConnection(url, user, pwd);
}

public ResultSet executeQuery(String sql) throws SQLException {
    return conn.createStatement().executeQuery(sql);
}

@Override
public void close() {
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException e) {
            System.err.println("关闭连接失败: " + e.getMessage());
        }
    }
}

try (DatabaseUtil db = new DatabaseUtil(url, user, pwd);
     ResultSet rs = db.executeQuery("SELECT * FROM users")) {
    // 使用结果集
}