Mapping Java ResultSet to Flex

[Anurag Mishra]

I finally got java and flex working together as a team yesterday. After
creating simple programs such as fetching string and calculating factorial, I
went over to sql.

I fetched some sql records and displayed them in a datagrid successfully.
Unfortunately, I didnt save the results and I can't reaccomplish that again.
Here's the code I used (as far as I know)

I am not sure what did I change, as it worked before and populated the
datagrid with the sql data. Now when I print result, all I see is lots of
[object Object]. So the data is coming through, just not sure if its the right
data, or how to map it to datagrid.

Thanks



[Java function to fetch sql records]

public List getStudents() {
List students = new ArrayList();
try {
String sql = "SELECT * FROM student";
Statement stmt = db.createStatement();
ResultSet results = stmt.executeQuery(sql);
while (results.next()) {
students.add(results);
}
}
catch (Exception e) { e.printStackTrace(); }

return students;
}


[flex code to map it to datagrid]

<mx:RemoteObject id="studentRecords" destination="studentsService"/>

<mx:Button label="get data" click="Student.getStudents()"/>
<mx:DataGrid dataProvider="{studentRecords.getStudents.result}" >
<mx:columns>
<mx:DataGridColumn headerText="first name" dataField="firstname"/>
<mx:DataGridColumn headerText="last name" dataField="lastname"/>
<mx:DataGridColumn headerText="middle name" dataField="middlename"/>
<mx:DataGridColumn headerText="email" dataField="email"/>
</mx:columns>
</mx:DataGrid>

[Faisal]

Hi,
Please use <mx:DataGrid dataProvider="{studentRecords.getStudents.lastResu lt}" >
insetead of <mx:DataGrid dataProvider="{studentRecords.getStudents.result}" >

This will resolve your issue.