mapper.xml文件配置返回类型为HashMap
<!-- 该日建房统计 -->
<select id="findTotalRooms" parameterType="java.lang.String" resultType="java.util.HashMap">SELECT ss.t AS room,COUNT(ss.r) AS num FROM
(
SELECT room_type AS t,room_uuid AS r FROM game_player_log WHERE create_date=DATE_FORMAT(#{time},'%Y-%m-%d') GROUP BY room_type,room_uuid
)ss GROUP BY ss.t;
</select>
2、如果返回的是多条数据,需要用list的map集合接收数据:
List<Map<String, Object>> list = dao.findTotalRooms(time);
否则会报错。