> 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.
You want to swim without getting wet. Fine :) public class MyMilkFactory { public List<Milk> provideHoneyObjects() { // iterate over sql statement/REsultSet Milk milk = createMilk(rs); Honey honey provideHoney(rs.getInteger("honeyid")); } public Milk createMilk(ResultSet rs) { // do not use an OR/mapper here but do the dirty work on your own} public Honey provideHoney(int id) {//read from database, again do the dirty work on your own } } > 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/m > >> >>>>> ain > >> >>>>> /java/com/carmanconsulting/wicket/advanced/web/story3/page/Home.j > >> >>>>> ava > >> >>>>> > >> >>>>> 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 -- 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