Well, theoretically you can drop the ResultSet into the Velocity context and iterate over it in the template, which is certainly the simplest way - personally, I prefer to create a List of some Bean class and iterate over that instead. But then, I'm old, cynical, and paranoid!
M On 11 February 2010 10:41, RithanyaLaxmi <[email protected]> wrote: > > Thanks Martin, how to fill the data from the database for the placeholders > in temp.xml? Is it the data or the ResultSet needs to be converted to a XML > format. My question is ,similar to Jasper reports is there any API (eitheir > DOM or FOP) which takes the ArrayList (contains the data from DB) using the > API pass the arraylist with XML (temp.xml) which will eventually replace the > placeholder with the data (from the arraylist). Is it possible? > > Martin Jacobson wrote: >> >> This isn't, strictly speaking, a FOP issue, but since I have to do >> something similar, I'll share my experience with you: >> You have (at least) two options: >> You can read your empty temp.xml file into a DOM, then manipulate the >> DOM to fill in data from the database. I don't like this option. What >> I do is to use Apache Velocity: I would have a Velocity template - the >> equivalent of the empty temp.xml - which I would merge with my data >> coming from the DB, to give me the completed temp.xml. This is much >> easier to write and maintain. >> HTH >> Martin >> >> Velocity : http://velocity.apache.org >> >> On 11 February 2010 09:05, RithanyaLaxmi >> <[email protected]> wrote: >>> >>> Hi, >>> >>> I using Apache FOP for PDF generation, i have the XML with header and >>> footer >>> information in the bodycontent i have a placeholder, for eg, >>> >>> Temp.xml >>> >>> <header> >>> Sample Header >>> </header> >>> <bodycontent> >>> [[bodycontent to be populated dynamically from DB]] >>> </bodycontent> >>> <footer> >>> Sample Footer >>> </footer> >>> >>> Temp.xsl, >>> >>> will have the XSL tags with the layout, styles, etc. >>> >>> Using Apache FOP API i need to fetch the data from the DB (using >>> javax.sql), >>> and replace the placeholder with the data in it and then use the XSL to >>> apply the styles,etc to generate a PDF? >>> I know the latter, i am not sure how to read the XML and replace the >>> placeholder with the data fetched from DB using apache FOP. I know that >>> Apache FOP uses SAX by default. Please do provide the code to parse the >>> Temp.xml and replace the place holder with data using apache FOP. If >>> there >>> is any sample links please do provide that as well. >>> >>> >>> Thanks, >>> Rithu >>> -- >>> View this message in context: >>> http://old.nabble.com/Populating-data-dynamically-from-the-DB-using-Apache-FOP-tp27542925p27542925.html >>> Sent from the FOP - Users mailing list archive at Nabble.com. >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >> >> >> -- >> From my MacBook Pro >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> > > -- > View this message in context: > http://old.nabble.com/Populating-data-dynamically-from-the-DB-using-Apache-FOP-tp27542925p27543891.html > Sent from the FOP - Users mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- >From my MacBook Pro --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
