public class DBUtil {
public static Connection getConn() {
//return getConn("D:\\superM\\Servlet_JSP_ARCH\\src\\db.properties");
return getConn("db.properties");
}
public static Connection getConn(String propertiesFile) {
Properties properties = new Properties();
try {
//properties.load(new FileInputStream(new File(propertiesFile)));
properties.load(DBUtil.class.getResourceAsStream(propertiesFile));
} catch (Exception e) {
e.printStackTrace();
}
String host = properties.getProperty("db.host");
String port = properties.getProperty("db.port");
String database = properties.getProperty("db.database");
String username = properties.getProperty("db.username");
String password = properties.getProperty("db.password");
return getConn(host, port, database, username, password);
}
public static Connection getConn(String host, String port, String database,
String username, String password) {
String driver = "oracle.jdbc.driver.OracleDriver";
Connection connection = null;
try {
Class.forName(driver);
String url = "jdbc:oracle:thin:@" + host + ":" + port + ":"
+ database;
connection = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return connection;
}
public static void close(ResultSet resultSet) {
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement statement) {
try {
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(Connection connection) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
db.properties文件如下
db.host = 172.16.10.216
db.port = 1521
db.database = orcl
db.username = zrz
db.password =zrzadmin