{filelink=8716}

/***** Code de MesExemples.com *******/
/**
 * @(#)ExempleBasedeDonneeXML.java
 *
 *
 * @author 
 *sakoba(java.mesexemples.com) @version 1.00 2013/7/5
 */


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import org.w3c.dom.Document;

import com.sun.org.apache.xml.internal.serialize.XMLSerializer;

public class ExempleBasedeDonneeXML {

  public static void main(String[] args) {

    try {

      Connection conn = DriverManager.getConnection("jdbc:derby:Avocats");

      Statement s = conn.createStatement();

      ResultSet rs = s.executeQuery("SELECT * FROM Contacts");

      while (rs.next()) {
        int id = rs.getInt("ID");
        Document manual = (Document) rs.getObject("Nom");
        XMLSerializer serialize = new XMLSerializer(System.out, null);
        serialize.serialize(manual);
      }

    } catch (Throwable e) {
      System.out.println("exception thrown");
      System.out.println(e);
    }
  }
}

Code testé avec le fichier XML Suivant

	Sakoba
	Adams
	Rappel
	Ne m'oubliez pas ce week-end!