Rajiv,
Here is full program .. you can go through it and get an idea.
HTML IS ON SO THE BOTTOM PART MAY NOT DISPLAY PROPERLY.
Nasser
import java.io.*;
import java.sql.*;
import org.w3c.dom.*;
import com.ibm.xml.parser.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CreateXMLTree extends HttpServlet {
TXDocument
doc;
TXElement EleClientDetRt, EleChildName, EleChildAddress, EleChildTel, EleChildFax, EleChildEmail;
TXText ChildTextName, ChildTextAddress, ChildTextTel, ChildTextFax, ChildTextEmail;
TXElement EleClient;
Writer wr;
CreateXMLTree(ServletOutputStream out, ResultSet rs){
try{
TXDocument doc = new TXDocument();
EleClientDetRt = (TXElement)doc.createElement("People");
doc.appendChild(EleClientDetRt);
while(rs.next()){
EleChildName = (TXElement)doc.createElement(rs.getMetaData().getColumnName(1));
EleChildAddress = (TXElement)doc.createElement(rs.getMetaData().getColumnName(2));
EleChildTel = (TXElement)doc.createElement(rs.getMetaData().getColumnName(3));
EleChildFax = (TXElement)doc.createElement(rs.getMetaData().getColumnName(4));
EleChildEmail = (TXElement)doc.createElement(rs.getMetaData().getColumnName(5));
ChildTextName = (TXText)doc.createTextNode(rs.getString("Name"));
ChildTextAddress = (TXText)doc.createTextNode(rs.getString("Address"));
ChildTextTel = (TXText)doc.createTextNode(rs.getString("Tel"));
ChildTextFax = (TXText)doc.createTextNode(rs.getString("Fax"));
ChildTextEmail = (TXText)doc.createTextNode(rs.getString("Email"));
EleChildName.appendChild(ChildTextName);
EleChildAddress.appendChild(ChildTextAddress);
EleChildTel.appendChild(ChildTextTel);
EleChildFax.appendChild(ChildTextFax);
EleChildEmail.appendChild(ChildTextEmail);
EleClient = (TXElement)doc.createElement("Person");
EleClient.appendChild(EleChildName);
EleClient.appendChild(EleChildAddress);
EleClient.appendChild(EleChildTel);
EleClient.appendChild(EleChildFax);
EleClient.appendChild(EleChildEmail);
EleClientDetRt.appendChild(EleClient);
}
((TXDocument)doc).printWithFormat(new PrintWriter(System.out));
wr = new OutputStreamWriter(new FileOutputStream("c:/test/ClientData.xml"));
doc.printWithFormat(wr);
wr.close();
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Storage of manipulated information </TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("The data required has been assembled and will be dispatched immediately");
out.println("
");
out.println("
");
out.println("Click her to invoke the Data Manipulation Form");
out.println("");
out.println("
");
out.println("...Please wait a moment.");
out.println("</BODY>");
out.println("</HTML>");
}
catch(Exception e){
System.out.println("Exception: " + e.getMessage());
}
}
}
[This message has been edited by Nasser Aboobaker (edited October 27, 2001).]
[This message has been edited by Nasser Aboobaker (edited October 27, 2001).]