所有開啟的 JDBC 連線都必須在 finally() 區塊中關閉。
import java.sql.*;
import javax.sql.*;
public class
ClassA
{{
public void method(){
Connection con = null;
Connection con2 = null;
try {
con = DriverManager.getConnection("database url");
con2 = DataSource.getConnection("database url");
}
finally {
con.close();
con2.close();
}
}
}
|
|