Mybatis杂记

group by查询返回map类型 ¹,²

List<Map<String, Object>> getCount();

xml:

<select id="getCount" resultType="java.util.HashMap">SELECT company_id, ifnull(sum(count_a + count_b),0) ctFROM test.com_countWHERE `is_del`= 0 GROUP BY company_id having ct > 0
</select>

返回数据示例：

[{"company_id": "id1","ct": 10},{"company_id": "id2","ct": 12},...
]

---

1. https://blog.csdn.net/fgszdgbzdb/article/details/78017486 ↩︎

2. https://blog.csdn.net/weixin_44339331/article/details/105232544 ↩︎