【Java/Oracle】利用user_tab_comments获取oracle表注释
代码:
package com.hy.lab.colcomment; import java.sql.*; public class Test2 { public static Connection getConnection() { Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; String user = "luna"; String pass = "1234"; conn = DriverManager.getConnection(url, user, pass); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void main(String[] args) { String sql = "select comments from user_tab_comments where table_name='EMP524'"; try (Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql)) { ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { System.out.println("EMP524 表注释=" + rs.getString(1)); } rs.close(); } catch (Exception e) { e.printStackTrace(); } } }
输出:
表注释=雇员表
建表语句:
create table emp524( id number(12), name nvarchar2(20), age number(3), primary key(id) ); COMMENT ON TABLE emp524 IS '雇员表'; COMMENT ON COLUMN emp524.id IS 'ID'; COMMENT ON COLUMN emp524.name IS '姓名'; COMMENT ON COLUMN emp524.age IS '年龄';
END