JDBC获取表注释

代码部分：

@Before
    public void loadDriver() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    @Test
    public void testConn() {
        String url = "jdbc:oracle:thin:@10.0.0.7:1521:ddgx10g"; // orcl为数据库的SID
        String user = "njzjdbc";
        String password = "123";

        Properties props = new Properties();
        props.put("remarksReporting", "true");
        props.put("user", user);
        props.put("password", password);

        DatabaseMetaData dbmd = null;
        ResultSet rs = null;
        Connection dbConn = null;
        try {
            dbConn = DriverManager.getConnection(url, props);
        
            dbmd = dbConn.getMetaData();
        
            rs = dbmd.getColumns(dbConn.getCatalog(), "NJZJDBC", "O_NJZJWEB_AJQY_ALL", "%");
        
            while (rs.next()) {
                String columnName = rs.getString("COLUMN_NAME");
                String columnRemarks = rs.getString("REMARKS");
                System.out.println("columnName:" + columnName
                        + ",columnRemarks:" + columnRemarks);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JdbcUtil.close(rs, null, conn);
        }

运行结果：