Can you give me an example, how i can use ResultSet transformed into
Map with for example datatable component?
I think i can write method transforming ResultSet to a Map.

I do not want to use any ORM, because web tier for my app is just
"control panel" and main features implemented in the backend.


2010/2/15 Ilja Pavkovic <ilja.pavko...@binaere-bauten.de>:
> use any preferred OR mapper like hibernate, toplink, ....
>
>> now problem is not accessing object fields..
>>
>> problem is transform resultset to these objects..
>>
>> 2010/2/12 James Carman <jcar...@carmanconsulting.com>:
>> > You could create a reference from Honey to Milk, since you have a
>> > "milkid" field there.  Then, you'd use a list of Honey objects and
>> > you'd display these properties:
>> >
>> > id
>> > milk.id
>> > name
>> > milk.name
>> >
>> > On Fri, Feb 12, 2010 at 3:58 AM, Ivan Dudko <ivan.du...@gmail.com> wrote:
>> >> For example..
>> >> class Honey {
>> >> int id;
>> >> int milkid;
>> >> String name;
>> >> // getters and setters
>> >> }
>> >> class Milk {
>> >> int id;
>> >> String name;
>> >> // getters and setters
>> >> }
>> >>
>> >> and my query:
>> >> SELECT honey.id ID, honey.milkid MILKID, honey.name HONEYNAME,
>> >> milk.name MILKNAME FROM honey, milk
>> >> WHERE  honey.milkid=milk.id;
>> >>
>> >> And i want to display table with these fields.
>> >>
>> >> Which object i must use?
>> >>
>> >> 2010/2/11 James Carman <jcar...@carmanconsulting.com>:
>> >>> Well, what sort of object do you want to display?  Are you going to
>> >>> just create an Object[] for each row in the table?  Or, are you
>> >>> creating a DTO of some sort?
>> >>>
>> >>> On Thu, Feb 11, 2010 at 10:50 AM, Ivan Dudko <ivan.du...@gmail.com>
> wrote:
>> >>>> Thank you.
>> >>>> I already do simple things with hibernate and spring ioc.
>> >>>> Now i want to use plain old jdbc.
>> >>>> I already get the datatable wich works with one pojo (table).
>> >>>> Now i am in trouble.. how i can get table for two joined tables, for
>> >>>> example?
>> >>>>
>> >>>> 2010/2/11 James Carman <jcar...@carmanconsulting.com>:
>> >>>>> Yeah, but this doesn't give them an example of how to get the results
>> >>>>> out of a JDBC result set.  This is based on a static, in-memory list
>> >>>>> of Contact objects.  What I would recommend is to look at a
>> >>>>> Hibernate-based example and come up with the JDBC analog.  Here's an
>> >>>>> example from my Advanced Wicket talk I gave a while back:
>> >>>>>
>> >>>>> http://svn.carmanconsulting.com/public/wicket-advanced/trunk/src/main
>> >>>>> /java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.java
>> >>>>>
>> >>>>> At the bottom, there's a data provider which talks to a "repository"
>> >>>>> to get its data.
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> On Thu, Feb 11, 2010 at 10:11 AM, Giambalvo, Christian
>> >>>>>
>> >>>>> <christian.giamba...@excelsisnet.com> wrote:
>> >>>>>> http://cwiki.apache.org/WICKET/simple-sortable-datatable-example.htm
>> >>>>>> l
>> >>>>>>
>> >>>>>> -----Ursprüngliche Nachricht-----
>> >>>>>> Von: Ivan Dudko [mailto:ivan.du...@gmail.com]
>> >>>>>> Gesendet: Donnerstag, 11. Februar 2010 15:47
>> >>>>>> An: users@wicket.apache.org
>> >>>>>> Betreff: Re: jdbc
>> >>>>>>
>> >>>>>> I already have method that return my data from db as arraylist. And
>> >>>>>> i use this in iterator() method of dataprovider.
>> >>>>>> But which object (i think model) i must return?
>> >>>>>>
>> >>>>>> 2010/2/11 James Carman <jcar...@carmanconsulting.com>:
>> >>>>>>> You need to create a "provider" for your data.  Look at what the
>> >>>>>>> constructor takes and then implement the interface.
>> >>>>>>>
>> >>>>>>> On Thu, Feb 11, 2010 at 8:26 AM, Ivan Dudko <ivan.du...@gmail.com>
> wrote:
>> >>>>>>>> Hello!
>> >>>>>>>>
>> >>>>>>>> I can't understand how to populate data from a resultset object
>> >>>>>>>> into datatable. Anyone have an example?
>> >>>>>>>>
>> >>>>>>>> Thank you!
>> >>>>>>>>
>> >>>>>>>> ------------------------------------------------------------------
>> >>>>>>>> --- To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> >>>>>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>> >>>>>>>
>> >>>>>>> -------------------------------------------------------------------
>> >>>>>>> -- To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For
>> >>>>>>> additional commands, e-mail: users-h...@wicket.apache.org
>> >>>>>>
>> >>>>>> --------------------------------------------------------------------
>> >>>>>> - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For
>> >>>>>> additional commands, e-mail: users-h...@wicket.apache.org
>> >>>>>>
>> >>>>>>
>> >>>>>> --------------------------------------------------------------------
>> >>>>>> - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For
>> >>>>>> additional commands, e-mail: users-h...@wicket.apache.org
>> >>>>>
>> >>>>> ---------------------------------------------------------------------
>> >>>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> >>>>> For additional commands, e-mail: users-h...@wicket.apache.org
>> >>>>
>> >>>> ---------------------------------------------------------------------
>> >>>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> >>>> For additional commands, e-mail: users-h...@wicket.apache.org
>> >>>
>> >>> ---------------------------------------------------------------------
>> >>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> >>> For additional commands, e-mail: users-h...@wicket.apache.org
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> >> For additional commands, e-mail: users-h...@wicket.apache.org
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> > For additional commands, e-mail: users-h...@wicket.apache.org
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
>> For additional commands, e-mail: users-h...@wicket.apache.org
>
>
> --
> binaere bauten gmbh · tempelhofer ufer 1a · 10961 berlin
>
>   +49 · 171 · 9342 465
>
> Handelsregister: HRB 115854 - Amtsgericht Charlottenburg
> Geschäftsführer: Dipl.-Inform. Ilja Pavkovic, Dipl.-Inform. Jost Becker
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
> For additional commands, e-mail: users-h...@wicket.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org

Reply via email to