使用Flex的组件调用Java List

2019-04-15 16:12发布

[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)"/>