1.DBUtil.java
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class DBUtil {
private static Connection connection=null;
private static Properties properties=null;
static {
properties=getProperties();
try {
Class.forName(properties.getProperty("driverClass"));
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Properties getProperties(){
InputStream is=DBUtil.class.getClassLoader().getResourceAsStream("db.properties");
Properties p=new Properties();
try {
p.load(is);
} catch (IOException e) {
e.printStackTrace();
}
return p;
}
public static Connection getConnection(){
try {
String url=properties.getProperty("url");
String user=properties.getProperty("user");
String password=properties.getProperty("password");
connection= DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void main(String[] args) {
System.out.println(getConnection());
}
public static void JDBCClose(Connection connection, Statement statement, ResultSet rs){
if (connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
2.db.properties
driverClass=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@x.x.x.x(ip地址):1521(端口号):XE
user=xx(用户名)
password=123456