Java查询MySQL数据库的字段及类型

Java查询MySQL数据库的字段及类型

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Hashtable;


public class GetDBFiled {
	public static void conn() {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/databaseName";
		String user = "root";
		String password = "密码";
		try {
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(url, user, password);
			if (!conn.isClosed()) {
				String sql = "select * from pic";
				System.out.println("Succeeded connecting to the Database!");
				Statement statement =conn.createStatement();
				ResultSet rs = statement.executeQuery(sql);
				if (rs.next()) {
					// 得到ResultSetMetaData
					ResultSetMetaData rsmd = rs.getMetaData();
					System.out.println(rsmd.getColumnCount());
					for (int i = 1; i <= rsmd.getColumnCount(); i++) {
						Hashtable hst = new Hashtable();
						// 把字段名放入Name
						String name = String.valueOf(rsmd.getColumnLabel(i));
						hst.put("Name", name);
						// 把字段类型放入Type
						String type = String.valueOf(rsmd.getColumnType(i));
						hst.put("Type", type);
						System.out.println(hst.get("Name")+"  "+hst.get("Type"));
					}
				}
			}
		} catch (Exception e) {

			System.out.println("出现异常");
		}

	}
}