public List<Map<String,Object>> getOrdersYear(){
return jdbcTemplate.queryForList("select DATE_FORMAT(o.exchangeTime,'%Y') as year from tb_orders o
where o.`status`='1'
group by DATE_FORMAT(o.exchangeTime,'%Y')
order by DATE_FORMAT(o.exchangeTime,'%Y')");
}
举个例子,比如现在我需要返回数据库中tb_orders表中的日期年份public List> getOrdersYear(){ return jdbcTemplate.queryForList("select DATE_FORMAT(o.exchangeTime,'%Y') as year from tb_orders o where o.`status`='1' group by DA