数据库:
select CheckDateTime ,count(*)from DAILYCHECKRESULT
where CheckDateTime=TO_DATE('2017/11/9','YYYY-MM-DD')
group by CheckDateTime
mybatis:
<resultMap id="getDate" type="HashMap">
<result property="key" column="CheckDateTime" />
<result property="value" column="count(*)" />
</resultMap>
<select id="findByDate" parameterType="String" resultMap="getDate">
select CheckDateTime ,count(*)
from DAILYCHECKRESULT
where CheckDateTime=TO_DATE(#{date},'YYYY-MM-DD')
group by CheckDateTime
</select>