ODBC

控制面板-->管理工具-->数据源 (ODBC)-->添加-->MySQL ODBC Driver

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Conn {
	public static void main(String[] args) {
		Connection connection = null;
		Statement statement;
		ResultSet resultSet;
		// 加载驱动程序以连接数据库
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");// 这个驱动不能是其他的..
			connection = DriverManager.getConnection("jdbc:odbc:MYSQLODBC", "root",
					"root"); // user是data Source ，root是用

			// 户名，123是进入mysql的密码
			System.out.println("open easy");
			String query = "Select * from user";
			statement = connection.createStatement();
			resultSet = statement.executeQuery(query);
			
			while(resultSet.next()){
				System.out.println("ID:"+resultSet.getString("id")+"|NAME:"+resultSet.getString("name")+"|AGE:"+resultSet.getString("age")+"|生日："+resultSet.getDate("birthday"));
//				resultSet.
			}
			connection.close();
			System.out.println("close easy");

		}
		// 捕获加载驱动程序异常
		catch (ClassNotFoundException cnfex) {
			System.err.println("装载 JDBC/ODBC 驱动程序失败。");
			cnfex.printStackTrace();
			System.exit(1); // terminate program
		}
		// 捕获连接数据库异常
		catch (SQLException sqlex) {
			System.err.println("无法连接数据库");
			sqlex.printStackTrace();
			System.exit(1); // terminate program
		} catch (Exception e) {
			System.out.println(e.toString());
		}
	}
}