java方法,这里得注意方法的返回值
List<Map<String,Object>> findGroup(Integer user_id);
第一步编写resultMap
<resultMap id="map" type="java.util.Map">
<result column="assrotment" property="assortment"></result>
<result column="user_id" property="userId"></result>
<result column="counts" property="counts"></result>
</resultMap>
第二步编写select
<select id="findGroup" resultMap="map">
SELECT
assortment,user_id,count(assortment) as counts
FROM article GROUP BY assortment,user_id HAVING user_id=#{userId};
</select>
最后
这里就是测试调用了
@Test
public void testFindGroup(){
List<Map<String,Object>> list=articleDao.findGroup(1);
for (Map<String,Object> map:list){
System.out.println(map);
}
}