Smooks: looping in freemarker template

[Anil Subudhi]

i need to retrieve data from database using xml loop ..my problem is how to loop in xml...

xml file given below

<?xml version="1.0"?> <smooks-resource-list xmlns="http://www.milyn.org/xsd/smooks-1.1.xsd" xmlns:ftl="http://www.milyn.org/xsd/smooks/freemarker-1.1.xsd" xmlns:db="http://www.milyn.org/xsd/smooks/db-routing-1.1.xsd" xmlns:jb="http://www.milyn.org/xsd/smooks/javabean-1.2.xsd" xmlns:ds="http://www.milyn.org/xsd/smooks/datasource-1.1.xsd" xmlns:csv="http://www.milyn.org/xsd/smooks/csv-1.2.xsd" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > <ds:direct bindOnElement="#document" datasource="DB" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/dbase" username="root" password="praya123" autoCommit="false" /> <db:executor executeOnElement="order" datasource="DB" executeBefore="true"> <db:statement>SELECT * FROM FORM</db:statement> <db:resultSet name="rs" /></db:executor> <db:executor executeOnElement="order" datasource="DB" executeBefore="true"> <db:statement>SELECT * FROM FORM1</db:statement> <db:resultSet name="rs1" /></db:executor> <db:executor executeOnElement="order" datasource="DB" executeBefore="true"> <db:statement>SELECT * FROM FORM2</db:statement> <db:resultSet name="rs2" /></db:executor> <ftl:freemarker applyOnElement="order"> <ftl:template> <!--<dbase> <Form > <FirstName>${rs[i].firstname}</FirstName> <LastName>${rs[i].lastname}</LastName> <Id>${rs[i].id}</Id> <Id>${rs1[i].ID}</Id> <PhNo>${rs1[i].PHNO}</PhNo> <Address>${rs1[i].ADDRESS}</Address> <NUM1>${rs2[i].NUM1}</NUM1> <NUM2>${rs2[i].NUM2}</NUM2> <NUM3>${rs2[i].NUM3}</NUM3> </Form> </dbase>--> </ftl:template> </ftl:freemarker> </smooks-resource-list>

red color need to be generic so how can i do this.

[Ulf Dittmer]

This XML format looks unfamiliar to me; is it something the Smooks framework uses? Which would make this a question about Smooks, not about HTML or JavaScript; is that correct?

[Anil Subudhi]

Ulf Dittmer wrote:This XML format looks unfamiliar to me; is it something the Smooks framework uses? Which would make this a question about Smooks, not about HTML or JavaScript; is that correct?

yes it is smooks framework ...i want to retrieve multiple records as per given above like generic smooks config file...is it possible then how can i do it...The above code is not correct one ...but my requirement is like this.