首先在coldfusion端有名为:test.cfc的文件:本地地址是:
localhost/cf/test.cfc
在flex端有test.mxml文件 访问地址是
localhost/samples/flex/test.mxml
下面是截图:
图片如下:

coldfusion代码是:
<cfcomponent>
<cfquery name="Recordset1" datasource="mygb" >
SELECT * FROM mygb
</cfquery>
<cffunction name="readbase" access="remote" returntype="query">
<cfset var results=QueryNew("name,title,mdate,content")>
<cfloop query="Recordset1">
<cfset QueryAddRow(results)>
<cfset QuerysetCell(results,"name","#Recordset1.name#")>
<cfset QuerysetCell(results,"title","#Recordset1.title#")>
<cfset QuerysetCell(results,"mdate","#Recordset1.mdate#")>
<cfset QuerysetCell(results,"content","#Recordset1.content#")>
</cfloop>
<cfreturn results>
</cffunction>
</cfcomponent>
flex端代码是:
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" initialize="update()">
<mx:Script>
<![CDATA[
function update(){
showdata.readbase();
}
function addcon(){
getURL("javascript:void window.open('addcon.mxml','','width=300,height=260')");
}
]]>
</mx:Script>
<mx:WebService wsdl="http://localhost/cf/test.cfc?WSDL" id="showdata" showBusyCursor="true">
<mx:operation name="readbase"/>
</mx:WebService>
<mx:Binding source="showdata.readbase.result" destination="mapGrid.dataProvider"/>
<mx:Binding source="mapGrid.selectedItem.content" destination="con.text"/>
<mx:HBox label="Guestbook">
<mx:Label text="Guestbook" fontSize="15" color="#FFFFFF" width="100%"/>
<mx:Button label="Update" click="update()"></mx:Button>
<mx:Button label="Add" click="addcon()"></mx:Button>
</mx:HBox>
<mx:HBox label="Mappings">
<!-- Mappings grid -->
<mx:DataGrid id="mapGrid" editable="false">
<mx:columns>
<mx:Array>
<mx:DataGridColumn headerText="Name" columnName="name" />
<mx:DataGridColumn headerText="Title" columnName="title" />
<mx:DataGridColumn headerText="Date" columnName="mdate" />
</mx:Array>
</mx:columns>
</mx:DataGrid>
</mx:HBox>
<mx:TextArea id="con" width="322" height="200"></mx:TextArea>
</mx:Application>
----------------
localhost/cf/test.cfc
在flex端有test.mxml文件 访问地址是
localhost/samples/flex/test.mxml
下面是截图:
图片如下:

coldfusion代码是:
<cfcomponent>
<cfquery name="Recordset1" datasource="mygb" >
SELECT * FROM mygb
</cfquery>
<cffunction name="readbase" access="remote" returntype="query">
<cfset var results=QueryNew("name,title,mdate,content")>
<cfloop query="Recordset1">
<cfset QueryAddRow(results)>
<cfset QuerysetCell(results,"name","#Recordset1.name#")>
<cfset QuerysetCell(results,"title","#Recordset1.title#")>
<cfset QuerysetCell(results,"mdate","#Recordset1.mdate#")>
<cfset QuerysetCell(results,"content","#Recordset1.content#")>
</cfloop>
<cfreturn results>
</cffunction>
</cfcomponent>
flex端代码是:
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" initialize="update()">
<mx:Script>
<![CDATA[
function update(){
showdata.readbase();
}
function addcon(){
getURL("javascript:void window.open('addcon.mxml','','width=300,height=260')");
}
]]>
</mx:Script>
<mx:WebService wsdl="http://localhost/cf/test.cfc?WSDL" id="showdata" showBusyCursor="true">
<mx:operation name="readbase"/>
</mx:WebService>
<mx:Binding source="showdata.readbase.result" destination="mapGrid.dataProvider"/>
<mx:Binding source="mapGrid.selectedItem.content" destination="con.text"/>
<mx:HBox label="Guestbook">
<mx:Label text="Guestbook" fontSize="15" color="#FFFFFF" width="100%"/>
<mx:Button label="Update" click="update()"></mx:Button>
<mx:Button label="Add" click="addcon()"></mx:Button>
</mx:HBox>
<mx:HBox label="Mappings">
<!-- Mappings grid -->
<mx:DataGrid id="mapGrid" editable="false">
<mx:columns>
<mx:Array>
<mx:DataGridColumn headerText="Name" columnName="name" />
<mx:DataGridColumn headerText="Title" columnName="title" />
<mx:DataGridColumn headerText="Date" columnName="mdate" />
</mx:Array>
</mx:columns>
</mx:DataGrid>
</mx:HBox>
<mx:TextArea id="con" width="322" height="200"></mx:TextArea>
</mx:Application>
----------------
回复Comments
作者:
{commentrecontent}