Re: Re: Re: jdbc
Thank you all guys! I just do it with Map. Especially thanks to Leo.Erlandsson! 2010/2/15 leo.erlands...@tyringe.com: Should be no different when using JDBC than using it when using Domain Objects. Check out Wicket Phonebook Example that uses FilterToolbar: http://wicketstuff.org/confluence/display/STUFFWIKI/wicket-phonebook Source Code Example: https://wicket-stuff.svn.sourceforge.net/svnroot/wicket-stuff/trunk/wicketstuff-core/phonebook/src/main/java/wicket/contrib/phonebook/web/page/ListContactsPage.java Thank you! I just discovered this sample: http://www.brettdutton.com/blog/?p=4 What i can do.. if i want to use FilterToolbar with DataTable? - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: Re: jdbc
now problem is not accessing object fields.. problem is transform resultset to these objects.. You could just work with Maps in Wicket instead of Domain Objects. The transformation from ResultSet to a Map containing the Column name as Key and the data as Value should be trivial (if not; reply and I'll provide sample code) using MetaData (this is how we do it in our JSP pages today). Or you could write / find a software that does the mapping from JDBC ResultSet to Domain Objects... But why not use an ORM such as Hibernate / Cayenne / iBatis then.. ?
Re: Re: jdbc
If you want to use a Map and display it in a Datatable there's no
difference from using an Object in Wicket.
You access the key/values using PropertyColumn as usual (i.e. you don't
really need to make any changes to your code). For Objects you use e. g.
name for the getName() method. When using Maps name will return the
value corresponding to the key name.
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 ListMilk 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 }
}
Re: Re: jdbc
Thank you!
I just discovered this sample:
http://www.brettdutton.com/blog/?p=4
What i can do.. if i want to use FilterToolbar with DataTable?
2010/2/15 leo.erlands...@tyringe.com:
If you want to use a Map and display it in a Datatable there's no
difference from using an Object in Wicket.
You access the key/values using PropertyColumn as usual (i.e. you don't
really need to make any changes to your code). For Objects you use e. g.
name for the getName() method. When using Maps name will return the
value corresponding to the key name.
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 ListMilk 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 }
}
-
To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org
For additional commands, e-mail: users-h...@wicket.apache.org
Re: Re: Re: jdbc
Should be no different when using JDBC than using it when using Domain Objects. Check out Wicket Phonebook Example that uses FilterToolbar: http://wicketstuff.org/confluence/display/STUFFWIKI/wicket-phonebook Source Code Example: https://wicket-stuff.svn.sourceforge.net/svnroot/wicket-stuff/trunk/wicketstuff-core/phonebook/src/main/java/wicket/contrib/phonebook/web/page/ListContactsPage.java Thank you! I just discovered this sample: http://www.brettdutton.com/blog/?p=4 What i can do.. if i want to use FilterToolbar with DataTable?
