package com.entor.jdbc;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
public class DBUtil {
//返回数据库连接
public static Connection getConnection() {
Connection conn = null;
try {
Properties prop = new Properties();
prop.load(new FileInputStream("config/db.properties"));
Class.forName(prop.getProperty("driver"));
conn = DriverManager.getConnection(prop.getProperty("url"),
prop.getProperty("username"),
prop.getProperty("password"));
}catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 通过ResultSet关闭数据库连接
* @param rs
*/
public static void close(ResultSet rs) {
try {
Statement stmt = rs.getStatement();
Connection conn = stmt.getConnection();
rs.close();
stmt.close();
conn.close();
}catch (Exception e) {
e.printStackTrace();
}
}
/**
* 通过Statement关闭数据库连接
* @param stmt
*/
public static void close(Statement stmt) {
try {
Connection conn = stmt.getConnection();
stmt.close();
conn.close();
}catch (Exception e) {
e.printStackTrace();
}
}
}
所读取的文件信息为:
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:XE
username=scott
password=tiger