jdbc mysql resultset结果集获取 表 元数据 获取列 字段 名 类型

Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from weapon");
ResultSetMetaData md = rs.getMetaData();
int count = md.getColumnCount();
for (int i = 1; i <= count; i++) {  //字段从1开始
    System.out.print(md.getColumnName(i) + " ");    //字段名
    System.out.print(md.getColumnType(i) + " ");    //字段大小
    System.out.println(md.getColumnTypeName(i));    //字段类型
}