java JDBC连接MySQL

1.下载MySQL驱动。http://www.mysql.com/downloads/connector/j/

2.把文件放入一个目录，然后把这个目录添加到环境变量的classpath里。

  如我的目录：E:\mysql-driver\mysql-connector-java-5.1.22\mysql-connector-java-5.1.22-bin.jar

3.自己在数据库中新建一些测试数据。

4.编写java代码测试。注：需要在工程build path中添加上面的jar.

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

public class Main {
	private static final String DRIVER = "com.mysql.jdbc.Driver";
	private static final String ADDRESS = "jdbc:mysql://127.0.0.1:3306/test";
	private static final String USER = "root";
	private static final String PASSWORD = "hejinwei";
	
	public static void main(String[] args) {
		try {
			Class.forName(DRIVER);	// 加载驱动
			Connection conn = DriverManager.getConnection(ADDRESS, USER, PASSWORD);
			if (conn != null && !conn.isClosed()) {
				System.out.println("MySQL Connection Succeeded!");
			} else {
				System.err.println("MySQL Connection Failed!");
				return;
			}
			Statement statement = conn.createStatement();
			String sql = "select * from student";
			ResultSet rs = statement.executeQuery(sql);
			if (rs == null) {
				System.err.println("ResultSet rs is null!");
				return;
			}
			
			while (rs.next()) {
				System.out.println(rs.getString("name"));
			}
			rs.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			System.err.println("Load MySQL Driver Failed!");
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
}