包含静态代码块及数据库对象关闭方法。
properties文件数据格式:Key=Value
public class ConnectionUtil {
private static String driver;
private static String uri;
private static String user;
private static String password;
static {
Properties props = new Properties();
try {
props.load(ConnectionUtil.class.getClassLoader()
.getResourceAsStream("properties文件路径"));
driver = props.getProperty("driver");
uri = props.getProperty("uri");
user = props.getProperty("user");
password = props.getProperty("password");
Class.forName(driver);
} catch (Exception e) {
}
}
/**
* 获得Connection对象
* @return
* @throws Exception
*/
public static Connection getConnection() throws Exception {
Connection con = DriverManager.getConnection(uri, user, password);
return con;
}
/**
* 关闭ResultSet对象
* @param rs
*/
public static void closeResultSet(ResultSet rs) {
if (rs != null)
try {
rs.close();
} catch (SQLException e) {
}
}
/**
* 关闭Statement对象
* @param stmt
*/
public static void closeStatement(Statement stmt) {
if (stmt != null)
try {
stmt.close();
} catch (SQLException e) {
}
}
/**
* 关闭Connection对象
* @param con
*/
public static void closeConnection(Connection con) {
if (con != null)
try {
con.close();
} catch (SQLException e) {
}
}
}