create XML File from ResultSet - Java XML

Java examples for XML:ResultSet to XML

  1. HOME
  2. Java
  3. XML
  4. ResultSet to XML

Description

create XML File from ResultSet

Demo Code


//package com.java2s;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Main {
    public static void createFile(ResultSet rs, String fileName)
            throws IOException, SQLException {
        Writer writer = new FileWriter(fileName);
        ResultSetMetaData metaData = rs.getMetaData();
        addPrologue(writer);//ww w. ja  v  a2 s. c  om
        openRoot(writer, metaData.getCatalogName(1));
        addChildren(writer, rs);
        closeRoot(writer, metaData.getCatalogName(1));
        writer.flush();
        writer.close();
        System.out.println(">>> Ecriture termin?e > " + fileName + " <<<");
    }

    private static void addPrologue(Writer writer) throws IOException {
        writer.write("<?xml version='1.0' encoding='UTF-8'?>");
    }

    private static void openRoot(Writer writer, String root)
            throws IOException {
        writer.write("<" + root + ">");
    }

    private static void addChildren(Writer writer, ResultSet rs)
            throws SQLException, IOException {
        ResultSetMetaData metaData = rs.getMetaData();
        int nbColumns = metaData.getColumnCount();
        StringBuffer buffer = new StringBuffer();
        while (rs.next()) {
            buffer.setLength(0);
            buffer.append("<" + metaData.getTableName(1) + ">");
            for (int i = 1; i <= nbColumns; i++) {
                buffer.append("<" + metaData.getColumnName(i) + ">");
                buffer.append(rs.getString(i));
                buffer.append("</" + metaData.getColumnName(i) + ">");
            }
            buffer.append("</" + metaData.getTableName(1) + ">");
            writer.write(buffer.toString());
        }
    }

    private static void closeRoot(Writer writer, String root)
            throws IOException {
        writer.write("</" + root + ">");
    }
}

Related Tutorials