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

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; }