package com.shaocoder.connection;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionTest {
	public static void main(String[] args) {
		Connection conn = null;
		try {
			//1.數(shù)據(jù)庫連接的4個基本要素
			//①JDBC URL用于標識一個被注冊的驅動程序，驅動程序管理器通過這個URL選擇正確的驅動程序，從而建立到數(shù)據(jù)庫的連接；
			//jdbc：表示URL中的協(xié)議
			//mysql：子協(xié)議，用于標識mysql數(shù)據(jù)庫驅動程序
			//localhost:本機的IP地址
			//3306：端口號
			//test：表示訪問test數(shù)據(jù)庫
			String url = "jdbc:mysql://localhost:3306/test";
			//user:登錄數(shù)據(jù)庫的用戶名
			String user = "root";
			//password:用戶名對應的密碼，這些都是自己之前設定的
			String password = "123456";
			//mySql的驅動：com.mysql.jdbc.Driver
			String driverName = "com.mysql.jdbc.Driver";
			
			//2.實例化Driver
			Class clazz = Class.forName(driverName);
			Driver driver = (Driver) clazz.newInstance();
			
			//3.通過DriverManager來注冊驅動
			DriverManager.registerDriver(driver);
			//4.通過DriverManager的getConnection方法，獲取Connection類的對象
			conn = DriverManager.getConnection(url, user, password);
			//5.打印出conn對象
			System.out.println(conn);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				//當conn不為空時
				if(conn != null) 
					//關閉conn資源
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}

package com.shaocoder.connection;

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

public class ConnectionTest {

	public static void main(String args[]) {
		InputStream is = null;
		Connection conn = null;
		try {
			//通過類加載器訪問jdbc.properties文件，轉化為輸入流
			is = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
			Properties pros = new Properties();
			pros.load(is);
			
			String user = pros.getProperty("user");
			String password = pros.getProperty("password");
			String url = pros.getProperty("url");
			String driverClass = pros.getProperty("driverClass");
			
			Class.forName(driverClass);
			
			conn = DriverManager.getConnection(url, user, password);
			
			System.out.println(conn);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			
			try {
				if(conn != null)
					conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				if(is != null)
					is.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
				
		}
		
	}
}