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));
}
}
Map遍历
最新推荐文章于 2022-01-28 11:45:15 发布