Java連接Mysql 數(shù)據(jù)庫主要分為四個(gè)步驟：
- 加載數(shù)據(jù)庫驅(qū)動(dòng)陵吸。通常使用Class類的forName()靜態(tài)方法來加載驅(qū)動(dòng)
Class.forName("com.mysql.jdbc.Driver");
- 通過DriverManager 獲取數(shù)據(jù)庫連接
Connection conn = DriverManager.getConnection(String url,String user,String pass);
mysql的URL寫法為:
jdbc:mysql://hostname:port/databasement
-通過Connection 創(chuàng)建Statement 對(duì)象
Statement stmt = conn.createStatement();
- 使用Statement執(zhí)行SQL語句
ResultSet rs = stmt.executeQuery(SQL)
完整代碼為
package com.learning;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws Exception{
// TODO Auto-generated method stub
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/crm"
,"root","root");
Statement stmt = conn.createStatement();
String sql = "select * from sys_user" ;
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
System.out.println( rs.getString(1) + "\t"
+ rs.getString(2) + "\t"
+ rs.getString(3));
}
}
}
