一、ConnectionFactory: 连接工厂,工厂模式
jdbc->connection->DB 连接的四个参数;
1.Driver->驱动包:
2.URL
3.user
4.pass
(1)、ConnectionFactory的作用
1、利用工厂模式提升代码的重要性。
2、封装注册数据库的驱动和获得数据库的连接。
3、利用配置文件减少硬编码,便于维护。(添加:properties文件,设置变量的值)
(2)、ConnectionFactory的开发
1、配置文件jdbcinfo.properties
oracle.driver=oracle.jdbc.driver.OracleDriver
oracle.url=jdbc:oracle:thin:@localhost:1521:XE
2、配置文件信息的获取
ConnectionFactory.class.getResourceAsStream("jdbcinfo.properties");
3、数据库连接Connection的获取
public static Connertion getConnection();
注:ConnectionFactory实现jdbc连接类:
public class ConnectionFactory {
private static String DRIVER;
private static String URL;
private static String USER;
private static String PASSWORD;
static{
Properties props = new Properties();
InputStream is =
ConnectionFactory.class.getResourceAsStream("jdbcinfo.properties");
try {
props.load(is);
DRIVER = props .getProperty("oracle.driver");
URL = props.getProperty("oracle.url");
USER = props.getProperty("oracle.user");
PASSWORD = props.getProperty("oracle.password");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn = null;
try{
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USER, PASSWORD);
}catch(Exception e){
e.printStackTrace();
}
return conn;
}