Flex调用Java List 教程

[color=green]看懂此教程需要了解的JavaEE知识及ActionScript,MXML,blazeDS框架。[/color]

[img]http://dl.iteye.com/upload/picture/pic/116077/56030a6f-ac24-35cd-b8cf-e91fec245774.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/116079/0678f068-2eae-3f69-97e8-0f61f641c5e6.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/116073/704e5b17-b82a-36e3-bba3-8c027ebfbe0d.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/116075/7caaae4f-5f21-3fdb-84c1-eefe0bbd4a8c.png[/img]

[img]http://dl.iteye.com/upload/picture/pic/116071/fd7c7e10-a68d-3038-9147-a0d9b3806fe3.png[/img] [color=green]成功！[/color]

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<RankingModel> resultList = new ArrayList<RankingModel>();

		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;
	}
}

<?xml version="1.0" encoding="UTF-8"?>
<service id="remoting-service" class="flex.messaging.services.RemotingService">

	<destination id="RankingService">
		<properties>
			<source>com.demo.hibernate.service.RankingService</source>
		</properties>
	</destination>


	<adapters>
		<adapter-definition id="java-object"
			class="flex.messaging.services.remoting.adapters.JavaAdapter"
			default="true" />
	</adapters>

	<default-channels>
		<channel ref="my-amf" />
	</default-channels>

</service>

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" 
			   xmlns:s="library://ns.adobe.com/flex/spark" 
			   xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" 
			   creationComplete="init()">
	<fx:Script>
		<![CDATA[
			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; 
			}
		]]>
	</fx:Script>
	<fx:Declarations>
		<!-- 将非可视元素（例如服务、值对象）放在此处 -->
		<mx:RemoteObject destination="RankingService" id="RankingService" 
						 result="RankingService_resultHandler(event)" 
						 endpoint="/RankingSystem/messagebroker/amf"/>

	</fx:Declarations>
	<s:DataGrid id="grid1" x="149" y="122" width="234" requestedRowCount="10">
		<s:columns>
			<s:ArrayList>
				<s:GridColumn dataField="card_num" headerText="卡号"></s:GridColumn>
				<s:GridColumn dataField="sumMoney" headerText="金额"></s:GridColumn>
			</s:ArrayList>
		</s:columns>
	</s:DataGrid>
</s:Application>