[as3.0]FLEX 中将OPENAMF返回的结果绑定到DataGrid中

前几天开始学习FLEX,想将从OPENAMF返回的数据绑定到DataGrid中,尝试了两种方法:

方法一:

OPENAMF代码(JAVA):

 

// 查询会员
     public  List QueryMember(String userid) ... {
        String sql="";
        if(userid.equals(""))...{
            sql="select * from "+sysTableName;
        }else...{
            sql="select * from "+sysTableName+" where suserid='"+userid+"'";
        }
        Connection connection=null;
        Statement stmt=null;
        ResultSet rs=null;
        List<Object> managerInfoList = new ArrayList<Object>();
        try...{
            Driver theDriver=(Driver)Class.forName(driverName).newInstance();
            connection=DriverManager.getConnection(url);
            stmt=connection.createStatement();
            rs=stmt.executeQuery(sql);
            while (rs.next())...{
                List<Object> infoList = new ArrayList<Object>();
                infoList.add(rs.getObject("suserid"));
                infoList.add(rs.getObject("susername"));
                infoList.add(rs.getObject("ssex"));
                infoList.add("");
                infoList.add(rs.getObject("stype"));
                infoList.add(rs.getObject("susermoney"));
                infoList.add(rs.getObject("semail"));
                infoList.add(rs.getObject("sqq"));
                infoList.add(rs.getObject("surl"));
                infoList.add(rs.getObject("sdate"));
                infoList.add(rs.getObject("sphoto"));
                managerInfoList.add(infoList);
            }

        }catch(Exception e)...{
            System.out.println(e);
        }finally...{
            try...{
                rs.close();
                stmt.close();
                connection.close();
            }catch(Exception e)...{
            }
        }
        return managerInfoList;
    }

 这样返回的结果是一个二维数组,这个二维数组在FLEX是不能直接绑定到DataGrid中的,要做一次转换:

 

function  onQueryAllMemberResult(result:Object): void   ... {
                var memberTableName:Array=["帐号","呢称","性别","密码","类型","S币","E-MAIL","QQ","个人网站","注册时间","头像"];
                for(var what:* in result)...{
                    for(var that:* in result[what])...{
                        trace(that+"result:"+result[what][that]);
                    }
                }
                trace("aa:"+result[0]["性别"]);
                var dataArray:Array=new Array();
                for(var i:uint=0;i<result.length;i++)...{
                    var temp:Dictionary=new Dictionary();
                    for(var j:uint=0;j<result[i].length;j++)...{
                        temp[memberTableName[j]]=result[i][j];
                    }
                    dataArray.push(temp);
                }
                memberManager_dg.dataProvider=dataArray;
            }

之所以加上memberTableName这个数组是因为我的DataGrid是这样定义的:

< mx:DataGrid width = " 98% "  height = " 90% "  horizontalCenter = " -1 "  id = " memberManager_dg "  fontSize = " 12 "  textAlign = " center "   y = " 10 " >
                         < mx:columns >
                             < mx:DataGridColumn headerText = " 帐号 "  dataField = " 帐号 " />
                             < mx:DataGridColumn headerText = " 呢称 "  dataField = " 呢称 "  width = " 100 " />
                             < mx:DataGridColumn headerText = " 性别 "  dataField = " 性别 "  width = " 35 " />
                             < mx:DataGridColumn headerText = " 密码 "  dataField = " 密码 "  width = " 35 " />
                             < mx:DataGridColumn headerText = " 类型 "  dataField = " 类型 "  width = " 35 " />
                             < mx:DataGridColumn headerText = " S币 "  dataField = " S币 "  width = " 100 " />
                             < mx:DataGridColumn headerText = " E-MAIL "  dataField = " E-MAIL "  width = " 180 " />
                             < mx:DataGridColumn headerText = " QQ "  dataField = " QQ "  width = " 100 " />
                             < mx:DataGridColumn headerText = " 个人网站 "  dataField = " 个人网站 "  width = " 200 " />
                             < mx:DataGridColumn headerText = " 注册时间 "  dataField = " 注册时间 "  width = " 180 " />
                             < mx:DataGridColumn headerText = " 头像 "  dataField = " 头像 "  width = " 90 " />
                         </ mx:columns >
                     </ mx:DataGrid >

很显然,这样转换一次比较麻烦,如果要直接将数组绑定到DataGrid的dataProvider上,就要在JAVA来改变了,要使用哈希表来处理:

 

// 查询会员
    public List QueryMember(String userid) ... {
        String sql="";
        if(userid.equals(""))...{
            sql="select * from "+sysTableName;
        }else...{
            sql="select * from "+sysTableName+" where suserid='"+userid+"'";
        }
        Connection connection=null;
        Statement stmt=null;
        ResultSet rs=null;
        List<Object> managerInfoList = new ArrayList<Object>();
        try...{
            Driver theDriver=(Driver)Class.forName(driverName).newInstance();
            connection=DriverManager.getConnection(url);
            stmt=connection.createStatement();
            rs=stmt.executeQuery(sql);
            while (rs.next())...{
                //List<Object> infoList = new ArrayList<Object>();
                Map<Object,Object> infoListHashMap=new HashMap<Object,Object>();
                infoListHashMap.put("帐号",rs.getObject("suserid"));
                infoListHashMap.put("呢称",rs.getObject("susername"));
                infoListHashMap.put("性别",rs.getObject("ssex"));
                infoListHashMap.put("密码","");
                infoListHashMap.put("类型",rs.getObject("stype"));
                infoListHashMap.put("S币",rs.getObject("susermoney"));
                infoListHashMap.put("E-MAIL",rs.getObject("semail"));
                infoListHashMap.put("QQ",rs.getObject("sqq"));
                infoListHashMap.put("个人网站",rs.getObject("surl"));
                infoListHashMap.put("注册时间",rs.getString("sdate"));
                infoListHashMap.put("头像",rs.getObject("sphoto"));
                System.out.println(infoListHashMap);
                managerInfoList.add(infoListHashMap);
            }
            
            System.out.println(managerInfoList);
            
        }catch(Exception e)...{
            System.out.println(e);
        }finally...{
            try...{
                rs.close();
                stmt.close();
                connection.close();
            }catch(Exception e)...{
            }
        }
        return managerInfoList;
    }

这样就直接绑定到DataGrid的dataProvider上就可以了