Hi Nic Brough, thanks for replaying. Here is the code i am using. I am using eclipse to run the code.
package jellypackage;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import org.apache.commons.jelly.JellyContext;
import org.apache.commons.jelly.XMLOutput;
import java.sql.*;
import java.util.Vector;
public class Jelly {
public static void main(String[] args) throws Exception
{
Connection conn;
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection("jdbc:postgresql://172.20.178.243:5432/TREX 2.1","postgres","postgres");
System.out.println("\t!!!!!!!!!!!!DATABASE CONNECTION ESTABLISHED!!!!!!!!!!!!!\n\n");
ResultSet rs= null;
Statement s = null;
String i = null;
String j=null;
s=conn.createStatement();
rs=s.executeQuery("SELECT * FROM res_task_workspace");
String template = "C:\\Documents and Settings\\396056\\jelly1.xml";
OutputStream output = new FileOutputStream("C:\\Documents and Settings\\396056\\results.html"); // file to which o/p of script written
JellyContext jcontext = new JellyContext();
jcontext.setVariable("name","396056");
jcontext.setVariable("background","pink");
jcontext.setVariable("url","C:\\Documents and Settings\\396056\\My Documents\\My Pictures\\vista.jpeg");
Vector<String> v = new Vector<String>();
Vector<String> u = new Vector<String>();
int k=0;
while ( rs.next() )
{
i = rs.getString("id");
j= rs.getString("ResourceName/TaskName");
v.add(i);
u.add(j);
}
jcontext.setVariable("ids", v);
jcontext.setVariable("ResourceName", u);
XMLOutput xmlOutput = XMLOutput.createXMLOutput(output);
// jcontext.run
jcontext.runScript(new File(template), xmlOutput); // run jely script and place o/p in output file
xmlOutput.flush();
}
}
jelly Script...
<?xml version="1.0"?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:x="jelly:xml" xmlns:html="jelly:html">
<html>
<head>
<title>${name}'s Page</title>
</head>
<body bgcolor="${background}">
text="#FFFFFF">
<h1>${name}'s Homepage</h1>
<img src="${url}"/>
<h2>My Hobbies</h2>
<ul>
<j:forEach var = "i" items= "${ids}">
<li>Name : ${dsi} </li>
</j:forEach>
</ul>
</body>
</html>
</j:jelly>
here i have included 2 columns from the table,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.