dao层
public interface XXXDao extends DevplatBaseDao<XXX,String> {
/**
* 根据年份统计数据
* @param beginYear 当前 年份 - 前 x 年的 数据
* @param currentYear 当前年份
* @return
*/
@Query(value = "select extract(year from create_time) as \"years\" ,count(id) as \"num\" from \"t_geoscience_products\" GROUP BY extract(year from create_time)" +
" HAVING extract(year from create_time) >= :beginYear and extract(year from create_time) <=:currentYear",nativeQuery = true)
List<Map<String,String>> getYearAndAreaData(@Param("beginYear")Integer beginYear, @Param("currentYear")Integer currentYear);
}
nativeQuery = true不要忘了