2005/10/12 | Coldfusion读取数据库中的信息，Flex格式化这些信息(一)(制作一个guestbook)
类别(ColdFusion) | 评论(0) | 阅读(696) | 发表于 15:39
首先在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>
----------------
0

评论Comments

日志分类
首页[185]
Flash[123]
ColdFusion[2]
Flex[2]
FlashMedia[3]
RIA[4]
Other[43]
Python[0]
Design[8]