A simple JDBC - MySQL

public class Tester {

	public static void main(String[] args) {
		try {
			// 这个字符串信息可以在mysql-connector-java-5.1.18-bin.jar下的META-INF ->
			// services -> java.sql.Driver中发现
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		java.sql.Connection conn = null;
		java.sql.Statement stmt = null;
		java.sql.ResultSet rs = null;
		java.sql.ResultSetMetaData md = null;

		try {
			// 连接的URL字符串，我们可以在eclipse的Add Library -> Connectivity Driver
			// Definition中设置和查看
			// jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK
			conn = java.sql.DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/test", "root", "password");
			stmt = conn.createStatement();

			rs = stmt.executeQuery("select * from users");
			md = rs.getMetaData();
			for(int i = 1; i <= md.getColumnCount(); i++){
				System.out.print(md.getColumnName(i) + "\t");
			}
			System.out.println();
			while (rs.next()) {
				for(int i = 1; i <= md.getColumnCount(); i++){
					System.out.print(rs.getString(i) + "\t");
				}
				System.out.println();
			}
		} catch (java.sql.SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (conn != null) {
					conn.close();
					conn = null;
				}
				if (stmt != null) {
					stmt.close();
					stmt = null;
				}
				if (rs != null) {
					rs.close();
					rs = null;
				}
			} catch (java.sql.SQLException e) {
				e.printStackTrace();
			}

		}

	}

}