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

Ads
 

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# ?
how to insert, retrieve data from,to db(code)....
ModuleNotFoundError: No module named 'generate-files-data'
how to insert, retrieve data from,to db(code)....
How to insert data from a combobox and textbox values into DB using JSP?
how to read 100 text files from a folder or directory and write the data into a single file.using java programming?
how to read and write xml files in javascript
where is my sqlite data files(.db) will be saved?
how to generate the pdf report from jsp
Generate xml
How to access the Title tag from xml to jsp
how to create xml schema from xml doc using java
data insertion from xml file to database table
How to create XML from Swings
how to read values from java in xml?
How to pretty print XML from Java?
How to access the following tag from xml to jsp
how to retrieve data from database ?????/
how to retrieve data from database ?????/
how to fetch data from servlet ????
how to retrieve data from database ?????/
how to retrieve data from database ?????/
How to create one xml file from existing xml file's body?
how to generate reports from oracle database using jsp and ajax code
How to read value from xml using java?
how to featch data form db?
How to values from xml using java?
how to retrieve data from database
Reading multiple xml files

Ads