- jdbc-mysql基础 注册驱动DriverManager.registerDriver:http://www.cnblogs.com/jizuiku/p/7843416.html
- JAVA JDBC(MySQL)驱动源码分析(一):https://blog.csdn.net/brilliancezhou/article/details/5425655
- MySQL的JDBC驱动源码解析:https://blog.csdn.net/c929833623lvcha/article/details/44517245
- 在Java中connection的常用方法及其描述是什么:https://wenda.so.com/q/1364074032061047?src=140
- jdbc的数据库驱动类DriverManager.getConnection()详解:https://blog.csdn.net/k_c123456/article/details/78728284
import java.sql.*;
public class Test {
public static void main(String[] arg) throws Exception{
String user = "root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=UTF8";
String driver = "com.mysql.jdbc.Driver";
Connection con = null;
Statement stmt = null;
ResultSet rSet = null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
stmt = con.createStatement();
rSet = stmt.executeQuery("select * from account");
while(rSet.next()){
System.out.println(rSet.getString(1)+" "+rSet.getString(2)+" "+rSet.getString(3));
}
}catch(SQLException e){
e.printStackTrace();
}finally{
if(rSet!=null) rSet.close();
if(con!=null) con.close();
if(stmt!=null) stmt.close();
}
}
}