BottomlineJDBC底層驅(qū)動(dòng)

Bottomline 是一個(gè)底層的JDBC接口，用于直接從jar文件中加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序，其結(jié)構(gòu)如下圖所示

示例代碼

Class.forName("xeus.bottomline.BottomlineDriver");

Properties props = new Properties();
props.put("user", "root");
props.put("password", "root");
props.put("jar","D:\\database-drivers\\mysql-connector-java-5.0.3\\mysql-connector-java-5.0.3-bin.jar");
props.put("class", "com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:bottomline:mysql://localhost:3306/myDB", props);

/*
In version 1.2 or later.
The connection parameters can be passed as Query String to the connection URL
*/

Connection conn1 = DriverManager.getConnection("jdbc:bottomline:mysql://localhost:3306/myDB?user=root&password=root"
                         + "&jar=D:\\database-drivers\\mysql-connector-java-5.0.3\\mysql-connector-java-5.0.3-bin.jar"
                         + "&class=com.mysql.jdbc.Driver");

// And also like the following

Connection conn2 = DriverManager.getConnection("jdbc:bottomline:mysql://localhost:3306/myDB?"
                        + "&jar=D:\\database-drivers\\mysql-connector-java-5.0.3\\mysql-connector-java-5.0.3-bin.jar"
                        + "&class=com.mysql.jdbc.Driver", "root", "root");

編者：我覺(jué)得這個(gè)項(xiàng)目實(shí)在有點(diǎn)脫褲子放屁！