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

public ArrayListgetDBTables(StringdbName) throws Exception { //数据库表名List ArrayList<String>tbList= new ArrayList<String>(); //获取数据库元数据 DatabaseMetaDatadbMetaData= new DatabaseMetaData((com.mysql.jdbc.Connection)getConn(),dbName); //类型() String[]types={ "TABLE" , "VIEW" }; rs=dbMetaData.getTables( null ,dbName, "%" ,types); while (rs.next()) { tbList.add(rs.getString( 3 )); } return tbList; }