package scout.database.util;

/**
 * <p>Title: get the parameter of connecton database</p>
 * <p>Description: abtain the parameter's values for connection a oracle9i database
 * such as sid,account,password,etc..</p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: Chongqing Kemeida corporation</p>
 * @author zengBo
 * @version 1.0
 */

import java.io.*;
import org.jdom.*;
import java.util.*;
import org.jdom.output.*;
import org.jdom.input.*;

public class ReadXml {

    private static String XMLURL = "..\\..\\..\\..\\sys_conf.xml";
    /**
     * constructor function
     * @param xmlURL,include the path and fileName of one xml
     */
    public ReadXml() {
    }

    /**
     * push some value in XML into VECTOR
     * @return vector
     * @throws Exception
     */
    public Vector getVectorOfXml() throws Exception {
        int childSize = 0;
        Vector vector = new Vector();
        SAXBuilder sb = new SAXBuilder();
        Document doc = sb.build(loadFile());
        ProcessingInstruction pi = new ProcessingInstruction
                                   ("xml-stylesheet",
                                    "href=\"bookList.html.xsl\" type=\"text/xsl\"");
        doc.addContent(pi);
        //get the root name
        Element root = doc.getRootElement();
        //get all children's elements of the root
        java.util.List children = root.getChildren();
        childSize = children.size();
        for (int i = 0; i < childSize; i++) {
            //get a child element
            Element child = (Element) children.get(i);
            Attribute at = (Attribute) child.getAttribute("");
            //get the value of a child and save it in vector
            vector.addElement(child.getTextTrim());
        }
        return vector;
    }

    /**
     * get the file of xml,and return the InputStream of the xml
     * @return InputStream
     */
    public InputStream loadFile() {
        Object object = null;
        try {
            object = getClass().getResourceAsStream(XMLURL);
        } catch (Exception e) {
            System.out.println("the file of xml is not found");
        }
        return (InputStream) object;
    }

    /**
     * the main function for testing
     * @param args
     * @throws Exception
     */
    public static void main(String args[]) throws Exception {
        ReadXml ne = new ReadXml();
        System.out.print(ne.loadFile());
        Vector vv = new Vector();
        vv = ne.getVectorOfXml();
        for (int i = 0; i < vv.size(); i++) {
            System.out.println(vv.elementAt(i));
        }
    }
}