I suppose it could go into: Wicket Wiki // Reference Library //// How To Do Things in Wicket ////// Database Interaction
-- though it would be much longer than any of the other articles (aside from those which are external links). Also, how would I create the new page into which I could enter my text? (Would I have to submit my words and code as HTML? Embarassing to say, but I don't have much experience with this, or with Wikis ...) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martijn Dashorst Sent: Wednesday, July 12, 2006 11:20 AM To: wicket-user@lists.sourceforge.net Subject: Re: [Wicket-user] DataView (extentions) Why don't you create a wiki article on this subject? Martijn On 7/12/06, Frank Silbermann <[EMAIL PROTECTED]> wrote: > > > Several months ago I mentioned that I was developing classes based on > WicketExtensions' DataTable and SortableDataProvider to display > arbitrary SQL SELECT result sets, with arbitrary sorting capability built-in. > > My approach is only appropriate for small result sets or for > prototyping, as the ResultSet's data is kept in the data provider between page renderings: > > > The developer overrides the method that generates the SQL query > string. If the generated text varies from one postback to the next > (or if an event sets a special flag), the data is replaced by a new query to the database. > > A general routine handles sorting events (column-header clicks) by > delegating to column type's default comparator and the built-in > ArrayList sorting capability. > > A hook is provided where the developer can specify massaging of the > data between download and presentation, e.g. to compute and add a > summary row, to insert additional computed columns, or to replace date > or number objects by formatted strings (to bypass DataTable's default > rendering of these objects). > (Perhaps someone can adapt some of my ideas to a more general solution > that doesn't keep result-set data in the DataProvider between > postbacks.) > > My implementation consists of just a few hundred lines of code in four > classes, two of which are trivial javabeans. A few readers of this > group expressed interest; what would be the easiest way of sharing? I > suppose I could build a tiny jar file and attach it to an e-mail, but > it might be easier to discuss the implementation if I send a few > e-mails, each directly containing the source code for one or two > classes. Would that be an appropriate use of this mailing list? > > ________________________________ > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Vincent > Jenks > Sent: Wednesday, March 15, 2006 9:29 AM > > To: wicket-user@lists.sourceforge.net > Subject: Re: [Wicket-user] DataView (extentions) > > > I'd love to see this (along w/ an example or two on usage) ;) > > > > On 3/15/06, Frank Silbermann <[EMAIL PROTECTED] > wrote: > > > > > > > > > > > > I have come up with my own subclass of DataTable and implementation > > of > IDataProvider to display any arbitrary database java.sql.ResultSet. > The basic idea is that my IDataProvider implementation contains a List > of rows, each row consisting of a List of Object. Also in the > implementation is an array of descriptors, one per column, each of > which contains the column name and an indicator as to whether I want to be able to sort on that column. > (The column name comes from the ResultSetMetadata; a method is > provided to set the sortability flag.) My implementation of the > abstract method to deliver a sequence of rows will delegate to the > List.sublist() command from the Java Collections API, and each time > the DataTable delivers a sort criteria I apply the Collections.sort() > method to my list of rows, passing it a Comparator that delegates to > the Comparator of the Object at the relevant column index. My > implementation of IDataProvider can also look at my array of column > descriptors and generate a list of IColumn objects (needed to construct the DataTable). > > > > > > It's actually a bit more complicated than that, because sometimes > > the > user needs to add one or more summary rows or add computed columns. > > > > > > The code is actually quite compact; when I'm finished I'll post it > > to the > list if there is any interest. > > > > > > > > > > > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Igor > Vaynberg > > Sent: Tuesday, March 14, 2006 5:21 PM > > To: wicket-user@lists.sourceforge.net > > Subject: Re: [Wicket-user] DataView (extentions) > > > > > > > > there is also a DataTable component which wraps DataView+paging+sorting. > > > > -Igor > > > > > > > > > > On 3/14/06, Vincent Jenks < [EMAIL PROTECTED]> wrote: > > > > I'm using 1.1.1 Are there any plans to whittle down the amount of > > code it > takes to implement paging & sorting? Has it changed at all in 1.2? I > spent a lot of time w/ ASP.NET (which wicket feels quite similar to) > and there's a DataGrid component that has properties to set paging & > sorting w/o any extra work. Something like that would be really convenient. > > > > > > > ---------------------------------------------------------------------- > --- Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier Download IBM WebSphere Application Server v.1.0.1 based on > Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216 > 42 > > > _______________________________________________ > Wicket-user mailing list > Wicket-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wicket-user > > > -- Download Wicket 1.2 now! Write Ajax applications without touching JavaScript! -- http://wicketframework.org ------------------------------------------------------------------------ - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
