[img]http://dl.iteye.com/upload/picture/pic/116071/fd7c7e10-a68d-3038-9147-a0d9b3806fe3.png[/img]
package com.demo.hibernate.service; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import org.hibernate.Session; import com.demo.hibernate.service.model.RankingModel; import com.demo.hibernate.utils.HibernateSessionFactory; public class RankingService { public List getTop10(String beginTime, String endTime) { List resultList = new ArrayList(); Session session = HibernateSessionFactory.getSession(); List list = session.createSQLQuery( "SELECT T_CARD.CARD_NUM,SUM(T_CARD_EXPENSE.MONEY) " + "FROM T_CARD_EXPENSE,T_CARD " + "WHERE T_CARD_EXPENSE.CARD_ID=T_CARD.ID " + "AND TO_CHAR(T_CARD_EXPENSE.CREATE_DT, 'yymmdd') " + "BETWEEN '" + beginTime + "' AND '" + endTime + "' " + "GROUP BY T_CARD.CARD_NUM " + "ORDER BY SUM(T_CARD_EXPENSE.MONEY) DESC") .setMaxResults(10).list(); session.close(); for (Iterator iter = list.iterator(); iter.hasNext();) { Object[] obj = (Object[]) iter.next(); RankingModel m = new RankingModel(obj[0].toString(), obj[1] .toString()); resultList.add(m); } return resultList; } }
package com.demo.hibernate.service.model; public class RankingModel { private String card_num; private String sumMoney; public RankingModel(String card_num,String sumMoney){ this.card_num=card_num; this.sumMoney=sumMoney; } public String getCard_num() { return card_num; } public void setCard_num(String cardNum) { card_num = cardNum; } public String getSumMoney() { return sumMoney; } public void setSumMoney(String sumMoney) { this.sumMoney = sumMoney; } }
com.demo.hibernate.service.RankingService class="flex.messaging.services.remoting.adapters.JavaAdapter" default="true" />
xmlns:s="library://ns.adobe.com/flex/spark" xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" creationComplete="init()"> import mx.collections.IList; import mx.rpc.events.ResultEvent; public function init():void{ RankingService.getTop10("120701", "120707"); } protected function RankingService_resultHandler(event:ResultEvent):void { grid1.dataProvider = event.result as IList; } ]]> result="RankingService_resultHandler(event)" endpoint="/RankingSystem/messagebroker/amf"/>
xmlns:s="library://ns.adobe.com/flex/spark" xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" creationComplete="init()"> import mx.collections.IList; import mx.rpc.events.ResultEvent; [Bindable] private var rankingList:IList; public function init():void{ RankingService.getRTRankingList(); } protected function RankingService_resultHandler(event:ResultEvent):void { rankingList = event.result as IList; } ]]> endpoint="/XMercury/spring/messagebroker/amf" result="RankingService_resultHandler(event)"/>