package day_03;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class demo04 {
private static String DRIVER;
private static String URL;
private static String USERNAME;
private static String PASSWORD;
static {
InputStream in = demo04.class.getClassLoader().getResourceAsStream("db.properties");
Properties p = new Properties();
try{
p.load(in);
DRIVER = p.getProperty("driver");
URL = p.getProperty("url");
USERNAME = p.getProperty("username");
PASSWORD = p.getProperty("pwd");
Class.forName(DRIVER);
}catch(Exception e){
e.printStackTrace();
}
}
public static Connection getConn() throws SQLException {
Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
return conn;
}
public static void closeAll(Connection conn, Statement st, ResultSet rs){
try {
if(st!=null){
st.close();
//为了让垃圾回收机制立刻回收这片资源
st=null;
}
}catch (Exception e ){
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();
//为了让垃圾回收机制立刻回收这片资源
conn=null;
}
}catch (Exception e ){
e.printStackTrace();
}
try {
if(rs!=null){
rs.close();
//为了让垃圾回收机制立刻回收这片资源
rs=null;
}
}catch (Exception e ){
e.printStackTrace();
}
}
}
JDBC配置文件
最新推荐文章于 2024-02-04 11:08:02 发布