如题,我的查询语句如下:
hql = " select count(*),a.stationName,sum(a.pactArea),a.townName,a.villageName, a.teamName ,a.createyear from TDStationmanageFarmerinfo a group by a.teamName,a.villageName,a.townName,a.stationName,a.pactArea ,a.createyear "; a.createyear是我要处理的数据,请高手指教,多谢了
hql = " select count(*),a.stationName,sum(a.pactArea),a.townName,a.villageName, a.teamName ,a.createyear from TDStationmanageFarmerinfo a group by a.teamName,a.villageName,a.townName,a.stationName,a.pactArea ,a.createyear "; a.createyear是我要处理的数据,请高手指教,多谢了
List list = query.list();
注意:list元素是一个Object[],你可以遍历list,取出你想要的数据,再做处理。
SimpleDateFormat d = new SimpleDateFormat("yyyy");
System.out.println(d.format(d));