數(shù)據(jù)庫表
這個sql是用pd生成的，具體內容大家自己看一下好了，很簡單，數(shù)據(jù)也自己填充一下。標題上說是用mysql，其實無所謂用啥數(shù)據(jù)庫了，這里我推薦Postgresql，現(xiàn)在有for win平臺了，不用cygwin來模擬unix環(huán)境，這個Postgresql一來小巧，二來功能齊全，看起來有點象Oracle，當然速度也很快了。

/*==============================================================*/
/* Table: tblmobile                                             */
/*==============================================================*/
create table tblmobile
(
   id                             integer(11)                    not null default 0,
   categoryid                     integer(11),
   name                           varchar(255),
   image                          varchar(255),
   price                          decimal(12,2),
   addtime                        datetime,
   primary key (id)
);

/*==============================================================*/
/* Index: i_tblMobile_categoryid                                */
/*==============================================================*/
create index i_tblMobile_categoryid on tblmobile
(
   categoryid
);

/*==============================================================*/
/* Index: pk_tblmobile                                          */
/*==============================================================*/
create unique index pk_tblmobile on tblmobile
(
   id
);

/*==============================================================*/
/* Index: i_tblmobile_addtime                                   */
/*==============================================================*/
create index i_tblmobile_addtime on tblmobile
(
   addtime
);


phonselist.jsp
Jsp服務器用的是Tomcat，順便做flex的服務器，版本沒啥大關系，我現(xiàn)在用的是5.0.28，Jsp功能是按手機分類id從mysql數(shù)據(jù)庫獲取手機列表，這里為方便起見直接在jsp頁面里進行數(shù)據(jù)庫訪問，正確的做法應該由javabean來分工，其后總jsp生成的是一個xml文件。
<?xml version="1.0" encoding="utf-8"?>
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<phonelist>
<%
    String sql = "";
    String url = "";

    String categoryID = request.getParameter("categoryID");

    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        url = "jdbc:mysql://localhost/web?user=flex&password=flex&useUnicode=true&characterEncoding=gb2312";
        Connection conn = DriverManager.getConnection(url);
        Statement stmt = conn.createStatement();

        sql = "select id, name, price, image from tblMobile where categoryid=" + categoryID;
        ResultSet rs = stmt.executeQuery(sql);

        while (rs.next()){
            out.println("<phone id=\"" + rs.getString(1) + "\">");
            out.println("<id>" + rs.getString(1) + "</id>");
            out.println("<name>" + rs.getString(2) + "</name>");
            out.println("<price>" + rs.getString(3) + "</price>");
            out.println("<image>" + rs.getString(4) + "</image>");
            out.println("</phone>");
        }

        rs.close();
        stmt.close();
        conn.close();

    } catch (Exception e) {
        out.println(e);
    }
%>
</phonelist>

mobile.mxml
這里要注意一下<mx:HTTPService>中的resultFormat="xml"的設置，在這里應該把這個取掉（我原來是用來做Tree用的）。phonelisg.jsp和mobile.mxml放在相同的目錄下，當然你也可以修改url的路徑。
<?xml version="1.0" encoding="utf-8"?>

<mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml"
    verticalGap="10"
    backgroundColor="#FFFFFF"
    pageTitle="手機"
    initialize="initApp()">
    
    <mx:Style source="main.css"/>

    <mx:HTTPService id="phoneService" url="phonelist.jsp" resultFormat="xml">
        <mx:request>
            <categoryID>{categoryId}</categoryID>
        </mx:request>
    </mx:HTTPService>

    <mx:Model id="phonelist">
        {phoneService.result.phonelist.phone}
    </mx:Model>


    <mx:Script>
        <![CDATA[

        var categoryId = 2;
        var categoryName = "Moto";
    
        function initApp() {
            phoneService.send();
        }

        ]]>
    </mx:Script>

    <mx:HBox>
        <mx:LinkBar styleName="title" width="500" click="" >
            <mx:dataProvider>
                <mx:Array>
                    <mx:Object label="首 頁" link="main"/>
                    <mx:Object label="手機分類" link="catagory"/>
                    <mx:Object label="論 壇" link="forum"/>
                    <mx:Object label="關 于" link="about"/>
                </mx:Array>
            </mx:dataProvider>
        </mx:LinkBar>
        <mx:Label text="搜索"/>
        <mx:TextInput id="key" width="120"/>
        <mx:Button label="Go"/>
    </mx:HBox>
    
    <mx:HBox>
        <mx:Image source="images/qd_2.jpg"/>
        <mx:Label id="debug" text="123"/>
    </mx:HBox>

    <mx:Effect>
        <mx:Zoom name="zoomBig" zoomTo="107" duration="100"/>
        <mx:Zoom name="zoomSmall" zoomTo="100" duration="100"/>
    </mx:Effect>

    <mx:HBox>
        <mx:Panel id="main" title="" height="360">            
                <mx:Tile width="520">
                    <mx:Repeater id="plist" dataProvider="{phonelist}" startingIndex="" count="">
                        <mx:VBox id="itemBox" verticalGap="0" horizontalAlign="center" mouseUp="">
                            <mx:Canvas width="100" height="100" clipContent="false">
                                <mx:Image width="90" height="90" source="{plist.currentItem.image}" toolTip="RMB {plist.currentItem.price}" mouseOverEffect="zoomBig" mouseOutEffect="zoomSmall" visible="false" complete="event.target.visible=true;"/>
                            </mx:Canvas>
                            <mx:Label id="itemName" text="{plist.currentItem.name}"/>
                            <mx:Label id="itemPrice" text="RMB{plist.currentItem.price}"/>
                        </mx:VBox>
                    </mx:Repeater>
                </mx:Tile>
            <mx:ControlBar>
                <mx:Button label="上一頁" click=""/>
                <mx:Button label="下一頁" click=""/>
                <mx:Button label="refresh" click="initApp()"/>
            </mx:ControlBar>
        </mx:Panel>
    </mx:HBox>


    <mx:HBox horizontalAlign="center">
        <mx:Label text="Copy Right 2004  dannyr‘s Studio "/>
    </mx:HBox>
</mx:Application>

 

最后：配置Flex服務器
flex-config.xml

<http-service-proxy>  
    <whitelist> 
            <unnamed>            
                <url>http://{localserver}/flex/phonelist.jsp</url>
            </unnamed>
    </whitelist>
         
         
      </http-service-proxy>