DatabaseMetaData meta ;
ResultSet rs = meta.getTables( null, "%", "%", null );
ParameterList result = new ParameterList( ); while ( rs.next( ) )
{
String name = rs.getString( 3 );
String type = rs.getString( 4 );
DBTableStruct table = new DBTableStruct( );
table.name = name;
table.type = type;
result.append( table );
}
ResultSet rs = meta.getTables( null, "%", "%", null );
ParameterList result = new ParameterList( ); while ( rs.next( ) )
{
String name = rs.getString( 3 );
String type = rs.getString( 4 );
DBTableStruct table = new DBTableStruct( );
table.name = name;
table.type = type;
result.append( table );
}
不过你的解决方法也还有一点问题
就是用户建的表一般都是TABLE但是在ORACLE中有一部分TABLE
却是系统建的
还要加上SCHEMA才行完整提取出来