mysql驱动加载理解

• 环境

ideal
mysql驱动5.1.46
jdk8

• 加载驱动

public static void main(String[] args) {
        try {
        	//这里加载驱动①
            Class clzz = Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            Connection conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","root");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

package com.mysql.jdbc;

import java.sql.DriverManager;
import java.sql.SQLException;
//①部分会加载类，触发Driver类的static部分
public class Driver extends NonRegisteringDriver implements java.sql.Driver {
    public Driver() throws SQLException {
    }
    //执行Class clzz = Class.forName("com.mysql.jdbc.Driver")这里触发
    static {
        try {
        	//可以看到，这里调用DriverManager的注册方法，将生产商提供的驱动注入
            DriverManager.registerDriver(new Driver());
        } catch (SQLException var1) {
            throw new RuntimeException("Can't register driver!");
        }
    }
}
//DriverManager类中的注册驱动方法
public static void registerDriver(Driver driver) throws SQLException {
     registerDriver(driver, (DriverAction)null);
}

public static void registerDriver(Driver driver, DriverAction da) throws SQLException {
     if (driver != null) {
            registeredDrivers.addIfAbsent(new DriverInfo(driver, da));
            println("registerDriver: " + driver);
     } else {
           throw new NullPointerException();
      }
}

//分析DriverManager.getConnection方法
@CallerSensitive
    public static Connection getConnection(String url, String user, String password) throws SQLException {
        Properties info = new Properties();
        if (user != null) {
            info.put("user", user);
        }

        if (password != null) {
            info.put("password", password);
        }
		//这里Reflection.getCallerClass()获取调用当前方法的类class对象
        return getConnection(url, info, Reflection.getCallerClass());
    }

private static Connection getConnection(String url, Properties info, Class<?> caller) throws SQLException {
		//判断当前class的类加载器是否为null，如果为null，则当前类是bootstrap类加载器
        ClassLoader callerCL = caller != null ? caller.getClassLoader() : null;
        //如果类加载器是tootstrap类加载器（callerCL == null）或者类加载器是ext类加载器
        if (callerCL == null || callerCL == ClassLoader.getPlatformClassLoader()) {
        	//则将加载当前调用类的类加载器赋值,即系统类加载器（app类加载器，这里是线程后门）
            callerCL = Thread.currentThread().getContextClassLoader();
        }

        if (url == null) {
            throw new SQLException("The url cannot be null", "08001");
        } else {
            println("DriverManager.getConnection(\"" + url + "\")");
            ensureDriversInitialized();
            SQLException reason = null;
            //registeredDrivers中存储了可用的驱动，在开始的时候已经加入
            Iterator var5 = registeredDrivers.iterator();

            while(true) {
                while(var5.hasNext()) {
                    DriverInfo aDriver = (DriverInfo)var5.next();
                    if (isDriverAllowed(aDriver.driver, callerCL)) {
                        try {
                            println("    trying " + aDriver.driver.getClass().getName());
                            //获取数据库连结
                            Connection con = aDriver.driver.connect(url, info);
                            //获取到，直接返回驱动
                            if (con != null) {
                                println("getConnection returning " + aDriver.driver.getClass().getName());
                                return con;
                            }
                        } catch (SQLException var8) {
                        	//获取失败，记录失败原因，reason则不为null，继续循环
                            if (reason == null) {
                                reason = var8;
                            }
                        }
                    } else {
                        println("    skipping: " + aDriver.getClass().getName());
                    }
                }
				//循环结束，reason不为null，说明获取Connection失败
                if (reason != null) {
                    println("getConnection failed: " + reason);
                    //抛出异常sql异常
                    throw reason;
                }
				//registeredDrivers注册的驱动为0个，抛异常
                println("getConnection: no suitable driver found for " + url);
                throw new SQLException("No suitable driver found for " + url, "08001");
            }
        }
    }