/**
 * 1.通過java.sql.Driver接口獲取數(shù)據(jù)庫連接
 * 2.使用配置文件讀取連接信息，使程序更加靈活
 */
package com.pack02;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;

import org.junit.Test;

public class TestDriver {

 @Test
 public void testDriver() throws Exception {
  
  //1.將配置文件中的連接信息獲取到Properties對象中
  InputStream is = 
    this.getClass().getClassLoader().getResourceAsStream("setting.properties");
  
  Properties setting = new Properties();
  setting.load(is);
  
  //2.從Properties對象中讀取需要的連接信息
  String driverName = setting.getProperty("driver");
  String url = setting.getProperty("url");
  String user = setting.getProperty("user");
  String password = setting.getProperty("password");
  
  //3.創(chuàng)建Driver對象
  Driver driver = (Driver)Class.forName(driverName).newInstance();
  
  Properties info = new Properties(); //driver的connect方法中需要一個Properties型的參數(shù)
  info.put("user", user);
  info.put("password", password);
  
  //4.使用driver的connect方法獲取數(shù)據(jù)庫連接
  Connection conn = driver.connect(url, info);
  System.out.println( conn );
 }
} 

/**
 * 1.通過java.sql.DriverManager(驅(qū)動程序管理類)獲取數(shù)據(jù)庫連接
 * 2.使用配置文件讀取連接信息，使程序更加靈活
 */
package com.pack02;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

import org.junit.Test;

public class TestDriverManager {
 
 @Test
 public void testDriverManager() throws Exception {
  
  //1.將配置文件中的連接信息獲取到Properties對象中
  InputStream is = 
    this.getClass().getClassLoader().getResourceAsStream("setting.properties");
    
  Properties setting = new Properties();
  setting.load(is);
    
  //2.從Properties對象中讀取需要的連接信息
  String driverName = setting.getProperty("driver");
  String url = setting.getProperty("url");
  String user = setting.getProperty("user");
  String password = setting.getProperty("password");
  
  //3.加載驅(qū)動程序，即將數(shù)據(jù)庫廠商提供的Driver接口實現(xiàn)類加載進(jìn)內(nèi)存；
  // 該驅(qū)動類中的靜態(tài)代碼塊包含有注冊驅(qū)動的程序，在加載類時將被執(zhí)行
  Class.forName(driverName);
  
  //4.通過DriverManager類的靜態(tài)方法getConnection獲取數(shù)據(jù)連接
  Connection conn = DriverManager.getConnection(url, user, password);
  System.out.println( conn );
 }
}

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/[....1....]?serverTimezone=GMT%2B8&useSSL=false
user=root
password=[....2....]