Convert a ResultSet to XML

   

import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.Document;
import org.w3c.dom.Element;

public class Main {

  public static void main(String args[]) throws Exception {
    DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
    DocumentBuilder builder = factory.newDocumentBuilder();
    Document doc = builder.newDocument();
    Element results = doc.createElement("Results");
    doc.appendChild(results);

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager
        .getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/access.mdb");
    
    ResultSet rs = con.createStatement().executeQuery("select * from product");

    ResultSetMetaData rsmd = rs.getMetaData();
    int colCount = rsmd.getColumnCount();

    while (rs.next()) {
      Element row = doc.createElement("Row");
      results.appendChild(row);
      for (int i = 1; i <= colCount; i++) {
        String columnName = rsmd.getColumnName(i);
        Object value = rs.getObject(i);
        Element node = doc.createElement(columnName);
        node.appendChild(doc.createTextNode(value.toString()));
        row.appendChild(node);
      }
    }
    DOMSource domSource = new DOMSource(doc);
    TransformerFactory tf = TransformerFactory.newInstance();
    Transformer transformer = tf.newTransformer();
    transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");
    transformer.setOutputProperty(OutputKeys.METHOD, "xml");
    transformer.setOutputProperty(OutputKeys.ENCODING, "ISO-8859-1");
    StringWriter sw = new StringWriter();
    StreamResult sr = new StreamResult(sw);
    transformer.transform(domSource, sr);

    System.out.println(sw.toString());

    con.close();
    rs.close();
  }
}

1.	ResultSet getter Methods
2.	ResultSet Update Methods
3.	Get Column Count In ResultSet
4.	Get available ResultSet types
5.	Get BLOB data from resultset
6.	ResultSet Update
7.	Results Decorator XML
8.	Results Decorator Text
9.	Results Decorator SQL
10.	Print ResultSet in HTML
11.	Demonstrate simple use of the CachedRowSet
12.	Metadata for ResultSet
13.	Scrollable ResultSet
14.	Concurrency in ResultSet
15.	SQL statement: ResultSet and ResultSetMetaData
16.	Output data from table
17.	Retrieve a rowcount from a ResultSet
18.	Wraps a ResultSet in an Iterator.
19.	Wraps a ResultSet to trim strings returned by the getString() and getObject() methods.
20.	Decorates a ResultSet with checks for a SQL NULL value on each getXXX method.

Convert a ResultSet to XML : ResultSet « Database SQL JDBC « Java

Related examples in the same category