World's most popular travel blog for travel bloggers.

Write an application to create a XML document from an employee database stored in an Oracle database. The XML document should contain the following fields:

, , No Comments

SAMPLE CODE (Update according to your Field Names/Requirement)

import javax.servlet.http.*;
import javax.xml.parsers.DocumentBuilder;
        import javax.xml.parsers.DocumentBuilderFactory;
        import javax.xml.parsers.ParserConfigurationException;
        import javax.xml.transform.OutputKeys;
        import javax.xml.transform.Result;
        import javax.xml.transform.Source;
        import javax.xml.transform.Transformer;
        import javax.xml.transform.TransformerConfigurationException;
        import javax.xml.transform.TransformerException;
        import javax.xml.transform.TransformerFactory;
        import javax.xml.transform.dom.DOMSource;
        import org.w3c.dom.Document;
        import org.w3c.dom.Element;
   public static void main(String[] args) throws ParserConfigurationException,
   TransformerException {
  DocumentBuilder builder = null;
  try {
   builder = DocumentBuilderFactory.newInstance().newDocumentBuilder();
  } catch (ParserConfigurationException e) {
   throw e;
  Document document = builder.newDocument();
  // create root element
  Element root = document.createElement("Users");
                // attach it to the document
                // create user node
  Element user = document.createElement("User");
                // create its id attribute
  user.setAttribute("id", "2");
                // add user node to root node
                // create name node and set its value
  Element userName = document.createElement("name");
                // attach this node to user node
                // write xml
  Transformer transformer;
  try {
   TransformerFactory transformerFactory = TransformerFactory
   transformer = transformerFactory.newTransformer();
   Result output = new StreamResult(new File("codippa.xml"));
   Source input = new DOMSource(document);
                        // if you want xml to be properly formatted
   transformer.setOutputProperty(OutputKeys.INDENT, "yes");
   transformer.transform(input, output);
  } catch (TransformerConfigurationException e) {
   throw e;
  } catch (TransformerException e) {
   throw e;


Post a Comment

Let us know your responses and feedback