数据库为oracle数据库
package com.db;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DBConnection {
public static Connection conn = null;
public static Properties props = null;
static {
props = new Properties();
try {
props.load(DBConnection.class.getResourceAsStream("/db.properties"));// 加载properties文件
} catch (Exception e) {
e.printStackTrace();
}
// 加载驱动
try {
Class.forName(props.getProperty("driverClass"));
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConn() {
try {
conn = DriverManager.getConnection(props.getProperty("url"),
props.getProperty("username"),
props.getProperty("password"));
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void closeConn() {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
db.properties文件内容为:
driverClass=oracle.jdbc.driver.OracleDriver
url=jdbc\:oracle\:thin\:@localhost\:1521\:orcl
username=scott
password=tiger