通过jdbc获取字段信息

    private static String driverName = "com.mysql.jdbc.Driver";
    private static String url = "jjdbc:mysql://localhost:3306/";
    private static String user = "root";
    private static String password = "root";

 

  Driver driver = DriverManager.getDriver(url);
  java.util.Properties info = new java.util.Properties();
   info.put("user", user);
   info.put("password", password);
   Connection conn = driver.connect(url, info); //获取链接

  DatabaseMetaData metaData = conn.getMetaData();//获取元数据
 

  ResultSet rs=metaData.getColumns(null, "ods.", "user","%");
                System.out.println(rs.next());
                while (rs.next()) {  
                    String columnName = rs.getString("COLUMN_NAME");  //字段名
                    String columnType = rs.getString("TYPE_NAME").toLowerCase(); //字段类型
                    String remarks = rs.getString("REMARKS");//字段描述
                    if(remarks==null){
                        remarks="";
                    }
                    System.out.println(columnName+" "+columnType+" 1"+remarks+"2"); 
                }