java使用JDBC訪問MYSQL資料庫

1.首先，在eclipse中添加對mysql資料庫驅動jar的引用, 項目上右鍵Properties-> Java Build Path ->Libraries-> Add External JARs，導航到下載到的mysql驅動jar確定即可。

2. 存取碼樣本。

package demos;import java.sql.*;public class HelloMySQL {public static void main(String[] args) throws Exception {Class.forName("com.mysql.jdbc.Driver");//connection stringString url = "jdbc:mysql://localhost:3306/test";String username = "root";String password = "root";// try to connect mysql serverConnection con = DriverManager.getConnection(url, username, password);Statement sql_statement = con.createStatement();//execute queryString query = "select * from person";ResultSet result = sql_statement.executeQuery(query);System.out.println("Records in the person table:");System.out.println("------------------------");System.out.println("id" + " " + "name" + " " + "age ");System.out.println("------------------------");// browse the result setwhile (result.next()) {int id = result.getInt("id");String name = result.getString("name");int age = result.getInt("age");System.out.println(" " + id + " " + name + " " + age);}// close connectionsql_statement.close();con.close();}}