<select id="getCountByDateList" resultType="com.guc.wo.protal.collection.domain.CollectionDateCount" > select DATE_FORMAT(create_time, '%Y-%m-%d') dayTime, count(*) countNumber from ugc_sys_wocollection GROUP BY DATE_FORMAT(create_time, '%Y-%m-%d') </select>
package com.guc.wo.protal.collection.domain; public class CollectionDateCount { private String dayTime; private Integer countNumber; public String getDayTime() { return dayTime; } public void setDayTime(String dayTime) { this.dayTime = dayTime; } public Integer getCountNumber() { return countNumber; } public void setCountNumber(Integer countNumber) { this.countNumber = countNumber; } }