这种Java连接数据库的方式在开发中比较容易使用,复用性高。
通过加载properties外部文件连接数据库
(记得导入包!!!)
properties外部文件
#oracle
driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
username=scott
password=123456
Java代码
package JDBC;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class Test3 {
public static void main(String[] args) {
try {
// 1 创建Properties对象
Properties properties = new Properties();
// 2 加载外部配置文件db.properties
properties.load(new FileInputStream("config/db.properties"));
// 3 加载驱动
Class.forName(properties.getProperty("driverClassName"));
// 4 定义连接
String url = properties.getProperty("url");
// 5 建立连接
String username = properties.getProperty("username");
String password = properties.getProperty("password");
Connection con = DriverManager.getConnection(url, username, password);
System.out.println(con);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
控制台输出
oracle.jdbc.driver.OracleConnection@7880cdf3
连接成功