import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.LineNumberReader;
import java.io.StringReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.DocumentBuilder;
import org.w3c.dom.Document;
import org.w3c.dom.NodeList;
import org.xml.sax.InputSource;

import com.sybase.jdbc3.jdbc.SybDriver;

import org.w3c.dom.Node;
import org.w3c.dom.Element;

public class GetAllDetails {

public static void main(String[] args) {

   String host = Credentials.host;
   String url = Credentials.url;
   String username = Credentials.username;
   String password =Credentials.password;
   SybDriver sybDriver = null;
   Connection conn;
   SqlStatement sql = new SqlStatement();

  try {

      sybDriver=(SybDriver)Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();

      conn = DriverManager.getConnection(url,username,password);
      Statement stmt = conn.createStatement();
      ResultSet rs = (stmt).executeQuery(sql.returnStatement());

      StringBuilder stringBuilder = new StringBuilder();
      File fileName = new File("//Workspace//DatabaseStuff//output.txt");

       FileWriter fw = new FileWriter(fileName,true); //the true will append the new data

      while (rs.next()) {
          String xml = rs.getString("EPI_APPLICATION_DATA");
          DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
          DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
          Document doc = dBuilder.parse(new InputSource(new StringReader(xml)));
          doc.getDocumentElement().normalize();


          NodeList nList = doc.getElementsByTagName("Owner");
          stringBuilder.append("----------------------------n");

          for (int temp = 0; temp < nList.getLength(); temp++) {
             Node nNode = nList.item(temp);
             if (nNode.getNodeType() == Node.ELEMENT_NODE) {
                Element eElement = (Element) nNode;

                stringBuilder.append("nFirst Name : "
                   + eElement
                   .getElementsByTagName("FirstName")
                   .item(0)
                   .getTextContent());
                stringBuilder.append("nLast Name : "
                   + eElement
                   .getElementsByTagName("LastName")
                   .item(0)
                   .getTextContent());
                stringBuilder.append("nEmail Address : "
                   + eElement
                   .getElementsByTagName("EmailAddress")
                   .item(0)
                   .getTextContent());
                stringBuilder.append("nPhone Number : "
                   + eElement
                   .getElementsByTagName("PhoneNumber")
                   .item(0)
                   .getTextContent());
             }

             else
             {
                 System.out.println("Element not found");
             }
             stringBuilder.append("nn");

          }

          fw.write(stringBuilder.toString());

      }

      fw.close();


  } catch (Exception e) {
     e.printStackTrace();
  }
   }
}