How to close a JDBC database connection?
After connecting to the database using JDBC, it is necessary to manually close the database connection. This can be done by calling the `close()` method to close the database connection. The specific steps are as follows: 1. Create a `Connection` object to establish a connection with the database. 2. After completing database operations, call the `close()` method of the `Connection` object to close the database connection. Here is an example code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class CloseConnectionExample {
public static void main(String[] args) {
Connection conn = null;
try {
// 创建数据库连接
conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/mydatabase”,
“username”, “password”);
// 执行数据库操作
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
// 关闭数据库连接
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
In the example above, the method conn.close() is called in the finally block to ensure that the database connection is properly closed regardless of whether an exception occurs.