Map遍历

来源:互联网 发布:为什么手机开不了淘宝 编辑:程序博客网 时间:2024/05/16 06:06
Map<String, SqlFileBean> mapSqlFiles=store.getSqlFiles();        HashMultiset<String> mapSqlFormat=HashMultiset.create();                Iterator iter=mapSqlFiles.entrySet().iterator();        while (iter.hasNext()) {            Map.Entry<String, SqlFileBean> entry = (Map.Entry<String, SqlFileBean>)iter.next();            String sql=ParameterizedOutputVisitorUtils.parameterize(entry.getValue().getSql(), JdbcUtils.MYSQL);            mapSqlFormat.add(sql);                  }        HashMultiset<String> mapTableCount=HashMultiset.create();        StringBuilder sBuilder=new StringBuilder();        Iterator iter2=mapSqlFormat.elementSet().iterator();        while (iter2.hasNext()) {            String sqlFormat = (String) iter2.next();            sBuilder.append(sqlFormat+"\r\n"+mapSqlFormat.count(sqlFormat)+"\r\n\r\n");            Set<String> arrTable=SqlUtil.parseSelectTables(sqlFormat);            if(arrTable==null){                continue;            }            for (String table : arrTable) {                mapTableCount.add(table,mapSqlFormat.count(sqlFormat));            }                   }   
0 0
原创粉丝点击