前提是不能使用GROUP BY语句,只能使用JAVA代码实现
场景是不知集合中存在多少元素,有重复元素并且要计算出每个元素的数量
代码如下:
public List<Student> list(){
Student student = new Student("12","小王",5000);
Student student1 = new Student("22","小花",8000);
Student student2 = new Student("32","小李",9000);
Student student3 = new Student("42","小红",1000);
Student student4 = new Student("52","小王",4000);
Student student5 = new Student("52","小红",6000);
Student student6 = new Student("52","小李",2000);
ArrayList<Student> students = new ArrayList<>();
students.add(student);
students.add(student1);
students.add(student2);
students.add(student3);
students.add(student4);
students.add(student5);
students.add(student6);
return students;
}
@Test
public void Test3() {
//创建一个map集合
Map elementsCount = new HashMap();
for (Student s : list) {
//遍历map里面有没有当前这个name,没有返回null,有则返回数量
Integer i = (Integer) elementsCount.get(s.getName());
if (i == null) {
//如果==null,说明这个是第一个,赋值为1
elementsCount.put(s.getName(), 1);
} else {
//如果!=null,用当前数量+1即可
elementsCount.put(s.getName(), i + 1);
}
}
for(Object key:elementsCount.keySet()){
System.out.println(key+"出现了 " +elementsCount.get(key) +"次");
}
}
}
输出结果:
小李出现了 2次
小王出现了 2次
小红出现了 2次
小花出现了 1次