1. 加载驱动方法
- Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
- DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- System.setProperty(“jdbc.drivers”, “com.mysql.jdbc.Driver”);
2. 加载JDBC的流程
- 加载驱动 DriverManager. registerDriver(Driver driver)
- 获取连接 Connection conn = DriverManager.getConnection(url,user,pass);
- 通过连接创建statement Statement st = conn.createStatement();
- 解析sql获取结果集 ResultSet rs = st.excuteQuery(sql);
- 遍历结果集,获得数据 rs.getobject(xx)
- 释放资源,关闭连接