HOld on
i have that too
*
public* *List* getCoeTownHallList() {
*List* result = *null*;
result = *this*.jdbcTemplate
.query(
"select distinct
(pw.MEETING_DATE),pw.CRITICAL,pw.AGENDA_OF_MEETING,pw.COE_TOWN_HALL_ID from
coe_town_hall pw, mp_coe_month_report mmr where pw.VD_ID = mmr.VD_ID and
pw.SO_ID = mmr.SO_ID and pw.KPI_ID = mmr.kpi_id and pw.mp_id = mmr.mp_id and
pw.COE_TYPE_ID = mmr.COE_TYPE_ID and pw.WEIGHT_START_MTH_ID =
mmr.WEIGHT_START_MTH_ID and pw.WEIGHT_END_MTH_ID = mmr.WEIGHT_END_MTH_ID and
pw.COE_ID = mmr.COE_ID",
*new* CoeTownHallMapper());
*return* result;
}
*private* *class* CoeTownHallMapper *implements* RowMapper {
*public* Object mapRow(ResultSet rs, *int* rowNum) {
CoeTownHallVO coeTownHallVO = *new* CoeTownHallVO();
*try* {
coeTownHallVO.setMeetingDate(rs.getDate("MEETING_DATE"));
coeTownHallVO.setAgenda(rs.getString("AGENDA_OF_MEETING"));
coeTownHallVO.setCritical(rs.getString("CRITICAL"));
} *catch* (SQLException e) {
// *TODO* Auto-generated catch block
e.printStackTrace();
}
*return* coeTownHallVO;
}
}
On Wed, Apr 7, 2010 at 10:57 AM, Shankar Ganesh.AP PitchaiMuthu <
[email protected]> wrote:
> Hi,
> Thanks for ur Help. But i need java code how to return a result set.
>
> On Wed, Apr 7, 2010 at 8:36 AM, Fehmina Kanuga <
> [email protected]> wrote:
>
>> HI,
>> i understand that u r going to fetch from DB right..
>> so make bindable array collection object
>>
>> [Bindable]
>>
>> *private* *var* _whitePaperCollection:ArrayCollection;
>>
>> and in
>>
>> datagrid
>>
>> <mx:DataGrid
>> x="3" y="159" width="580" dataProvider="{whitePaperCollection}"
>> alternatingItemColors="[#E2ECF0, #FFFFFF]" height="175" textAlign="center
>> ">
>> u can use this way.
>> u can define modal also and in that modal this arraycollection
>> and in datagrid's dataprovider u can use
>>
>> <mx:DataGrid
>> x="3" y="159" width="580" dataProvider="{
>> WhitepaperModel.getInstance().whitePaperCollection}"
>> alternatingItemColors="[#E2ECF0, #FFFFFF]" height="175" textAlign="center
>> ">
>>
>>
>>
>> hope this helps.
>>
>> Get back if u need more help
>>
>>
>>
>> On Thu, Apr 1, 2010 at 11:08 AM, Shankar Ganesh.AP PitchaiMuthu <
>> [email protected]> wrote:
>>
>>> Hi,
>>>
>>> In Java I am Fetching multiple row record, i need to pass this to flex
>>> So i am returning as object. In Flex I am nee to display it in Datagrid But
>>> i am not able to see anything.Any Help Appreciated.
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Flex India Community" group.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected]<flex_india%[email protected]>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/flex_india?hl=en.
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Flex India Community" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected]<flex_india%[email protected]>
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/flex_india?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Flex India Community" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<flex_india%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/flex_india?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en.
