If you look at the Wicket Examples, the ones online, in the Repeaters category (http://www.wicket-library.com/wicket-examples/repeater), many examples show sorting, and you can download the working examples. The second-to-last example demonstrates a DataTable with sortable column headers. The example doesn't even use a RDMS -- it allows the user to sort data that is stored in the application object. (That's where I got the idea for my approach.)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vincent Jenks Sent: Tuesday, July 18, 2006 5:26 PM To: wicket-user@lists.sourceforge.net Subject: Re: [Wicket-user] More examples of sorting? I appreciate it Frank, however I'm not familiar w/ DataTable or the SortableDataProvider - this is my first run. Really what I need is to see sorting working and I haven't even gotten that far. I'd be willing to take a look....it might be easier to see it working w/ plain JDBC to get a view of this w/ a different perspective, if anything. Thanks! On 7/18/06, Frank Silbermann <[EMAIL PROTECTED]> wrote: > If your SLSBs were not coded with paging and sorting in mind, you'll > probably have to implement a layer that understands sorting and paging > to stand between your SortableDataProvider and your SLSBs. To do that > in an ad-hoc way relevant to one specific set of data is probably time > consuming at worst, but a general approach doesn't sound very easy to > me. > > Is your data set too large to keep in the WebPage on the server while > your user plays with it, sorting it this way and that? Must you throw > away the data between postbacks, re-querying each time? If not, why > don't you take a look at the classes I posted to the group last week > (and sent you in private e-mail as well)? Even if you're not > interested in getting your data via vanilla JDBC SQL SELECT queries, > I'm sure my approach can be adapted. > > My code is not difficult to read if you are at all familiar with > DataTable and SortableDataProvider. I'd be happy to answer any > questions. /Frank > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Vincent Jenks > Sent: Tuesday, July 18, 2006 4:50 PM > To: wicket-user@lists.sourceforge.net > Subject: Re: [Wicket-user] More examples of sorting? > > Well, I don't have DAOs in this particular project - it's an EJB3 > project where I'm simply using SLSBs as DAOs....so I have the > EntityManager to work from and I should be able to bring the two > together to facilitate this... > > This may be easier than I thought.... > > On 7/18/06, Igor Vaynberg <[EMAIL PROTECTED]> wrote: > > yep, you have to code your daos with paging and sorting in mind, it > > cannot be slapped on as an afterthought. > > > > let me give you some clues > > > > see the attached QueryParam class, all my finder dao methods take it > > so that they can page/sort accordingly. > > > > hope it gets you started > > > > > > -Igor > > > > > > > > > > On 7/18/06, Vincent Jenks <[EMAIL PROTECTED] > wrote: > > > Currently I don't have anything like the ContactsDatabase class in > > > 'examples' - I'm just pulling a list of data and displaying in a > > > ListView....but it appears now that I'm browsing through I'm going > > > to have to create one and implement some of the methods like you > > > have in order to get paging/sorting. > > > > > > I'll play w/ it...it was just a little more than I expected once I > > > started digging into it. > > > > > > On 7/18/06, Igor Vaynberg <[EMAIL PROTECTED]> wrote: > > > > what could be simpler then the dataview? its just like a > > > > listview only instead of being fed off the list it is fed from > > > > the > idataprovider. > > > > > > > > class mydataprovider implements idataprovider() { > > > > iterator iterator(int first, int count) { > > > > return mydao.findcontacts(first, count).iterator(); > > > > } > > > > > > > > int size() { > > > > return mydao.countcontacts(); > > > > } > > > > > > > > model model(object o) { > > > > Contact contact=(Contact)o; > > > > return new ContactDetachableModel(contact); > > > > //or return new Model(contact); > > > > } > > > > } > > > > > > > > and that gets you paging, sorting is like this > > > > > > > > mydataprovider extends sortabledataprovider { > > > > // ditto from above > > > > > > > > iterator iterator(int first, int last) { > > > > return mydao.findcontacts(first, last, > > > > getsort().getproperty(), getsort().getcount(); > > > > } > > > > > > > > } > > > > > > > > > > > > if you have more specific questions i will be happy to help you > > > > > > > > -Igor > > > > > > > > > > > > > > > > > > > > > > > > On 7/18/06, Vincent Jenks <[EMAIL PROTECTED]> wrote: > > > > > > > > > Is there something smaller & simpler out there I could refer to > > > > for sorting? I've glanced at the DataView example a few times > > > > and > > > > > once I start digging in it just seems unwieldly to me. I'm > > > > simply > > > > > trying to sort a List of entities and the getContactsDB() stuff > > > > in the examples is a bit complicated to try and pick through. > > > > > > > > I gave paging a shot yesterday but quickly figured out it > > > > wouldn't > > > > > be a snap to throw together like most wicket stuff I've done so > > > > far....I'm in a crunch or I'd spend more time banging my head on > > > > the table. > > > > > > > > I think if I just had a couple real-world examples I'd pick it > > > > up > > faster. > > > > > > > > How's that book coming along? :D > > > > > > > > Thanks! > > > > > > > > > > -------------------------------------------------------------------- > > -- > > --- > > > > Take Surveys. Earn Cash. Influence the Future of IT Join > > > > SourceForge.net's Techsay panel and you'll get the chance to > > > > share > > your > > > > opinions on IT & business topics through brief surveys -- and > > > > earn > > > > > cash > > > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D > > EV > > DEV > > > > _______________________________________________ > > > > Wicket-user mailing list > > > > Wicket-user@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/wicket-user > > > > > > > > > > > > > > -------------------------------------------------------------------- > > -- > > --- > > > > Take Surveys. Earn Cash. Influence the Future of IT Join > > > > SourceForge.net's Techsay panel and you'll get the chance to > > > > share > > your > > > > opinions on IT & business topics through brief surveys -- and > > > > earn > > > > > cash > > > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D > > EV > > DEV > > > > > > > > _______________________________________________ > > > > Wicket-user mailing list > > > > Wicket-user@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/wicket-user > > > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > > -- > > --- > > > Take Surveys. Earn Cash. Influence the Future of IT Join > > > SourceForge.net's Techsay panel and you'll get the chance to share > > your > > > opinions on IT & business topics through brief surveys -- and earn > > > cash > > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D > > EV > > DEV > > > _______________________________________________ > > > Wicket-user mailing list > > > Wicket-user@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wicket-user > > > > > > > > > -------------------------------------------------------------------- > > -- > > --- Take Surveys. Earn Cash. Influence the Future of IT Join > > SourceForge.net's Techsay panel and you'll get the chance to share > > your opinions on IT & business topics through brief surveys -- and > > earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D > > EV > > DEV > > > > _______________________________________________ > > Wicket-user mailing list > > Wicket-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wicket-user > > > > > > > > > > ---------------------------------------------------------------------- > -- > - > Take Surveys. Earn Cash. Influence the Future of IT Join > SourceForge.net's Techsay panel and you'll get the chance to share > your opinions on IT & business topics through brief surveys -- and > earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV > DE > V > _______________________________________________ > Wicket-user mailing list > Wicket-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wicket-user > > ---------------------------------------------------------------------- > --- Take Surveys. Earn Cash. Influence the Future of IT Join > SourceForge.net's Techsay panel and you'll get the chance to share > your opinions on IT & business topics through brief surveys -- and > earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV > DEV _______________________________________________ > Wicket-user mailing list > Wicket-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wicket-user > ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE V _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
