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));
}
浙公网安备 33010602011771号