万急!jdbc获取oracle数据库用户表名列表
public class OracleConnection {
private Connection conn=null;
private DatabaseMetaData DMD=null;
public List getAllTableName(String Database,String User,String Passward) throws SQLException{
try{
Class.forName("oracle.jdbc.driver.OracleDriver"); conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:"+Database,User,Password);
}
catch(Exception ex){
ex.printStackTrace();
}
DMD=conn.getMetaData();
String[] types={"TABLE"};
ResultSet rs=DMD.getTables(null,DMD.getUserName(),"%", types);
List tables=new ArrayList();
while(rs.next()){
tables.add(rs.getObject("TABLE_NAME"));
}
System.out.println(tables);
return tables;
}
这样输出发现里面含有许多出我自己创建的表之外的其他表,该怎么办呀~~
求大侠帮忙