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 string
		String url = "jdbc:mysql://localhost:3306/test";
		String username = "root";
		String password = "root";

		// try to connect mysql server
		Connection con = DriverManager.getConnection(url, username, password);
		Statement sql_statement = con.createStatement();

		//execute query
		String 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 set
		while (result.next()) {
			int id = result.getInt("id");
			String name = result.getString("name");
			int age = result.getInt("age");
			System.out.println(" " + id + " " + name + " " + age);
		}

		// close connection
		sql_statement.close();
		con.close();

	}

}