create table tblMobile (id int, name varchar(20), price decimal(10,2), image varchar(50), categoryid varchar(20))

<?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 .Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
        url = "jdbc:microsoft:sqlserver://myserver:1433;DatabaseName=flex;User=flex;Password=flex;";
        Connection conn = DriverManager.getConnection(url);
        Statement stmt = conn.createStatement();

        
        String strOut = new String(categoryID.getBytes("ISO8859-1"), "GBK"); 

        System.out.println("categoryID="+categoryID);
        System.out.println("categoryID="+strOut);

        sql = "select id, name, price, image from tblMobile where categoryid='" + strOut + "'";
        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>

<?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:HTTPService id="phoneService" url="phonelist.jsp" fault="alert(event.fault.faultstring)"/>

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


    <mx:Script>
        <![CDATA[

        var categoryId = 1;
        var categoryName = "Moto";
    
        function initApp() {
            System.useCodepage = true;
            categoryId = "目录1";
            var obj = new Object();
            obj["categoryID"] = categoryId;
            phoneService.send(obj);
        }

        ]]>
    </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" click="initApp();"/>
    </mx:HBox>
    
    <mx:DataGrid dataProvider="{phonelist}">
        <mx:columns>
            <mx:Array>
                <mx:DataGridColumn columnName="id" headerText="ID"/>
                <mx:DataGridColumn columnName="name"  headerText="Name"/>
                <mx:DataGridColumn columnName="image"  headerText="Image"/>
            </mx:Array>
        </mx:columns>
    </mx:DataGrid>

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

System.useCodepage

Availability

flash Player 6.

Usage

System.useCodepage:Boolean

Description

Property; a Boolean value that tells flash Player whether to use Unicode or the traditional code page of the operating system running the player to interpret external text files. The default value of System.useCodepage is false.

• When the property is set to false, flash Player interprets external text files as Unicode. (These files must be encoded as Unicode when you save them.)
• When the property is set to true, flash Player interprets external text files using the traditional code page of the operating system running the player.