原本获取oracle的表结构可以使用desc 表名
,但使用ojdbc时却报错了,提示是“无效SQL”
Google了下发现用ojdbc时获取表结构的方法不一样:
PreparedStatement ps = conn.prepareStatement("select * from 表名" ); ResultSet rs = ps.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); for(int i=1;i<=rsmd.getColumnCount();i++){ System.out.println("No. of columns : " + rsmd.getColumnCount()); System.out.println("Column name of 1st column : " + rsmd.getColumnName(i)); System.out.println("Column type of 1st column : " + rsmd.getColumnTypeName(i)); }