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

import org.junit.Test;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;

public class testconnction01 {
 
	
    /**
     * @throws SQLException
     */
    @Test
    //方式一
	public void testConnection011() throws SQLException {
		Driver driver = new com.mysql.jdbc.Driver();
		String url = "jdbc:mysql://localhost:3306/test";
		Properties info = new Properties();
		info.setProperty("user", "root");
		info.setProperty("password", "root");
		Connection collection = (Connection) driver.connect(url, info);
		System.out.println(collection);
	}
    
    @Test
    //方式二，對方式一的迭代，使得程序具有更好的可移植性
   	public void testConnection02() throws Exception {
   		//獲取Driver實現(xiàn)類對象；使用反射
   		Class clazz= Class.forName("com.mysql.jdbc.Driver");
   		Driver driver=(Driver) clazz.newInstance();
   		//提供要連接的數(shù)據(jù)庫
   		String url = "jdbc:mysql://localhost:3306/test";
   		//提供連接需要的用戶名和密碼
   		Properties info = new Properties();
   		info.setProperty("user", "root");
   		info.setProperty("password", "root");
   		//獲取連接
   		Connection collection = (Connection) driver.connect(url, info);
   		System.out.println(collection);
   	}
    
    @Test
    //方式三，使用DriverManager替換Driver
   	public void testConnection03() throws Exception {
    	Class clazz= Class.forName("com.mysql.jdbc.Driver");
   		Driver driver=(Driver) clazz.newInstance();
   		
   		//提供另外三個連接的基本信息；
   		String url ="jdbc:mysql://localhost:3306/test";
   		String user ="root";
   		String password ="root";
   		
    	//注冊驅(qū)動
    	DriverManager.registerDriver(driver);
    	
    	//獲取連接
    	Connection connection= (Connection) DriverManager.getConnection(url,user,password);
   		System.out.println(connection);
   	}
    
    @Test
    //方式四，可以只是加載驅(qū)動,不用是示的注冊驅(qū)動過了。
   	public void testConnection04() throws Exception {
   
   		//提供另外三個連接的基本信息；
   		String url ="jdbc:mysql://localhost:3306/test";
   		String user ="root";
   		String password ="root";
   		
   		Class.forName("com.mysql.jdbc.Driver");
   		
//   		Class clazz= Class.forName("com.mysql.jdbc.Driver");
//   		Driver driver=(Driver) clazz.newInstance();
//   		
//    	//注冊驅(qū)動
//    	DriverManager.registerDriver(driver);
//    	
    	//獲取連接
    	Connection connection= (Connection) DriverManager.getConnection(url,user,password);
   		System.out.println(connection);
   	}
    
    @Test
    //方式五，(final版):將數(shù)據(jù)庫連接需要的4個基本信息聲明在配置文件中，通過讀取配置文件的方式，獲取連接
    //實現(xiàn)了數(shù)據(jù)和代碼的分離(解耦）
   	public void testConnection05() throws Exception {
   
   	//讀取配置文件的4個基本信息
    InputStream is = testconnction01.class.getClassLoader().getResourceAsStream("jdbc.properties");
    
      Properties p =new Properties();
      p.load(is);
      
      String user = p.getProperty("user");
      String password = p.getProperty("password");
      String url = p.getProperty("url");
      String driverClass =p.getProperty("driverClass");
      
      Class.forName(driverClass);
      
        //獲取連接
  	    Connection connection= (Connection) DriverManager.getConnection(url,user,password);
 		System.out.println(connection);
   	}
}