整个过程
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/blog?..........";
String username = "root";
String password = "wanghao";
Connection conn = null;
try {
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url, username, password);
PreparedStatement ps = conn.prepareStatement("select * from blogdemo");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Integer id = rs.getInt("ID");
System.out.println("id:" + id);
}
} catch (Exception e) {
e.printStackTrace();
}
1 、 driver 通过 Class.forName 方式,实际加载的是 mysql-connector-java.jar下面 com.mysql.jdbc.Driver的类.
2 、 通过 DriverManager 获取到connection,此时的 connection是 jdk 的sql包下面的接口,具体实现在 mysql-connector-java.jar 里面 com.mysql.fabric.jdbc.FabricMySQLDriver,在 mysql