String driver = "com.mysql.jdbc.Driver";
// URL指向要訪問的數據庫名mydb
String url = "jdbc:mysql://127.0.0.1:3306/mydb";
// 用戶名
String user = "root";
// Java連接MySQL密碼
String password = "root";
try {
// 加載驅動
Class.forName(driver);
// 連續數據庫
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("connecting to the Database Succee!");
// statement用來執行SQL語句
Statement statement = conn.createStatement();
// 要執行的SQL語句
String sql = "select * from student";
ResultSet rs=statement .executeQuery(sql);
while(rs.hasNext()){
//遍歷取得結果
}