How to Generate XML files from the data in DB tables?

How to Generate XML files from the data in DB tables?

HI Experts, I have a doubt.

I have a table say Pest.

My task is to generate XML file with all the fields in table and store it to database.Please help me.I am new to XML.

Is there any tools to generate xml files?

View Answers

September 27, 2011 at 4:59 PM

import java.io.*;
import java.util.*;
import org.w3c.dom.*;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.stream.*;

public class CreateXML{
public static void createXmlFile(Document doc,String name,String address,String contactNo,String email) throws Exception {
Element root = doc.createElement("Employee");
doc.appendChild(root);
Element element1 = doc.createElement("Emp_Name");
root.appendChild(element1);
Text text1 = doc.createTextNode(name);
element1.appendChild(text1);

Element element2 = doc.createElement("Emp_Address");
root.appendChild(element2);
Text text2 = doc.createTextNode(address);
element2.appendChild(text2);

Element element3 = doc.createElement("Emp_ContactNo");
root.appendChild(element3);
Text text3 = doc.createTextNode(contactNo);
element3.appendChild(text3);

Element element4 = doc.createElement("Email");
root.appendChild(element4);
Text text4 = doc.createTextNode(email);
element4.appendChild(text4);

TransformerFactory factory = TransformerFactory.newInstance();
Transformer transformer = factory.newTransformer();
transformer.setOutputProperty(OutputKeys.INDENT, "yes");

StringWriter sw = new StringWriter();
StreamResult result = new StreamResult(sw);
DOMSource source = new DOMSource(doc);
transformer.transform(source, result);
String xmlString = sw.toString();

File file = new File("c:/employee.xml");
BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(file,true)));
bw.write(xmlString);
bw.flush();
bw.close();
}
public static void main(String args[])throws Exception throws Exception{
DocumentBuilderFactory builderFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = builderFactory.newDocumentBuilder();
Document doc = docBuilder.newDocument();

Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "satya", "satya" );
        Statement st=conn.createStatement();
        ResultSet rs=st.executeQuery("select * from employee where id=1");
        String name=" ",address=" ",contactNo=" ",email=" ";
        if(rs.next()){
             name=rs.getString("name");
             address=rs.getString("address");
            contactNo=rs.getString("contactNo");
             email=rs.getString("email");
        }
createXmlFile(doc,name,address,contactNo,email);
System.out.println("Xml File Created Successfully");
}
}

Ads









Related Tutorials/Questions & Answers:
How to Generate XML files from the data in DB tables?
How to generate XML from XSD?
Advertisements
How to access data yearly from DB in C# ?
ModuleNotFoundError: No module named 'generate-files-data'
how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code)....
How to insert data from a combobox and textbox values into DB using JSP?
where is my sqlite data files(.db) will be saved?
Generate xml
how to read 100 text files from a folder or directory and write the data into a single file.using java programming?
how to generate the pdf report from jsp
how to read and write xml files in javascript
pdf generate from jsp
data insertion from xml file to database table
how to generate reports from oracle database using jsp and ajax code
How to create XML from Swings
how to create xml schema from xml doc using java
How to access the Title tag from xml to jsp
How to create one xml file from existing xml file's body?
How to access the following tag from xml to jsp
how to read values from java in xml?
How to pretty print XML from Java?
How to read value from xml using java?
JAXB Create XML File And Get Data From XML
How to values from xml using java?
how to featch data form db?
Reading multiple xml files
creating index for xml files - XML
How to create d db for upload files using bolb i m followin dat upload file in db tutorial
how to retrieve data from database ?????/
how to retrieve data from database ?????/

Ads