DatabaseMetaData 获取oracle字段注释

    Properties props = new Properties();
    props.put("remarksReporting","true");
    Class.forName("oracle.jdbc.driver.OracleDriver");
    dbConn = DriverManager.getConnection("jdbc:oracle:thin:test/test@localhost:1521:orcl", props);
    DatabaseMetaData dbmd = dbConn.getMetaData();
    rs = dbmd.getColumns(null, null,"表名", null);
    if (rs.next()) {
      System.out.println("Remarks: " + rs.getObject(12));
    }

 

posted @ 2016-04-12 09:12  IAMME  阅读(1040)  评论(0编辑  收藏  举报