<select id="selectCmsDevelopmentHistoryListWithTime" resultMap="CmsDevelopmentHistoryResult">
select id,time,development_history_txt, DATE_FORMAT(time,'%Y') as year,DATE_FORMAT(time,'%m') as month
from cms_development_history
where status = '1' and del_flag = '0'
order by time desc
</select>
从数据库表中取time(日期格式"yyyy-MM-dd"), DATE_FORMAT(time,’%Y’) as year是从time中取年并取别名。默认排序是升序,order by time desc是通过时间格式降序。
通过执行SQL语句从表中查出降序排列的time,year,month.
//通过时间降序查询排列 取的是年月日
List<CmsDevelopmentHistory> times = iCmsDevelopmentHistoryService.selectCmsDevelopmentHistoryListWithTime();
//从times中取年得集合