源码分析之JDBC实现原理与SPI机制

JDBC实现原理与SPI机制

JDBC实现原理分析

JDBC常见的代码一般是这么写：

String url = "jdbc:mysql:///consult?serverTimezone=UTC";
String user = "root";
String password = "root";

Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, user, password);
……

Class.forName()本地方法，暂时先放放。

DriverManager源码中，有个静态代码块loadInitialDrivers，意味着上来就会执行loadInitialDrivers执行初始化操作。

关键：

//检查system properties中的jdbc.properties，调用ServiceLoader加载
static {
   
        loadInitialDrivers();
        println("JDBC DriverManager initialized");
}

 private static void loadInitialDrivers() {
   
        String drivers;
        try {
   
            drivers = AccessController.doPrivileged(new PrivilegedAction<String>() {
   
                public String run() {
   
                    return System.getProperty("jdbc.drivers");
                }
            });
        } catch (Exception ex) {
   
            drivers = null;
        }

        AccessController.doPrivileged(new PrivilegedAction<Void>() {
   
            public Void run() {
   

                ServiceLoader<Driver> loadedDrivers = ServiceLoader.load(Driver.class);
                Iterator<Driver> driversIterator = loadedDrivers.iterator();

                try{
   
                    while(driversIterator.hasNext()) {
   
                        driversIterator.next();
                    }
                } catch(Throwable t) {
   
                // Do nothing
                }
                return null;
            }
        });

        println("DriverManager.initialize: jdbc.drivers = " + drivers);

        if (drivers == null || drivers.equals("")) {
   
            return;
        }
        String[] driversList = drivers.split(":");
        println("number of Drivers:" + driversList.length);
        for (String aDriver : driversList) {
   
            try {
   
                println("DriverManager.Initialize: loading " + aDriver);
                Class.forName(aDriver, true,
                        ClassLoader.getSystemClassLoader());
            } catch (Exception ex) {
   
                println("DriverManager.Initialize: load failed: " + ex