根据数据库名获取所有表及视图名称

publicArrayListgetDBTables(StringdbName)throwsException

{

//数据库表名List

ArrayList<String>tbList=newArrayList<String>();

//获取数据库元数据

DatabaseMetaDatadbMetaData=newDatabaseMetaData((com.mysql.jdbc.Connection)getConn(),dbName);

//类型()

String[]types={"TABLE","VIEW"};

rs=dbMetaData.getTables(null,dbName,"%",types);

while(rs.next())

{

tbList.add(rs.getString(3));

}

returntbList;

}