Create XML File

Here is the method using which you can create XML file from your ResultSet

public String xmlCreation(ResultSet rSet, ResultSetMetaData rsMData){
  try{
   DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
      DocumentBuilder parser = factory.newDocumentBuilder();
      Document doc = parser.newDocument();
         Element root = doc.createElement("ListData");
         doc.appendChild(root);
         if(rSet!=null){
          while(rSet.next()){
           Element row = doc.createElement("Row");
              root.appendChild(row);
           int totColumns = rsMData.getColumnCount();
           for(int i=1;i<=totColumns;i++){
            String columnName = rsMData.getColumnName(i);
            Object columnValue = rSet.getObject(i);
            Element childElement = doc.createElement(columnName);
            childElement.appendChild(doc.createTextNode(columnValue.toString()));
            row.appendChild(childElement);
           }
          }
         }
         TransformerFactory tranFactory = TransformerFactory.newInstance(); 
         Transformer aTransformer = tranFactory.newTransformer(); 
         Source src = new DOMSource(doc);
         StringWriter writer = new StringWriter();
         Result dest = new StreamResult(writer);
         aTransformer.transform(src, dest);
         StringBuffer strBuf = writer.getBuffer();
         System.out.println(strBuf.toString());
         return strBuf.toString();
  }catch(Exception e){
   System.out.println("Opps Error: "+e.toString());
   return null;
  }
 }

Categories: J2EE, Java, XML Creation