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("出现异常"); } } }