/**
 * title:數據庫連接、操作
 * desciprion:數據庫連接、操作
 * @author:victor
 * @version:v1.0
 * 2005-10-27
 */
package good;


import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.*;
import java.util.List;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.adapters.*;
import org.jdom.input.SAXBuilder;





public class DataConn extends DataConfig {

	private String JNDI;

	private String className;

	private String URL;

	private String UID;

	private String password;

	/**
	 * 構造函數
	 * 
	 */
	public DataConn() {
		super();
		//getConnection();
		getInitParaFromXml();
	}

	/**
	 * 數據庫直連（FOR ORACLE）
	 */
	public void dataConnDerectForOracle() {
		super.derectConnectForOracle(className, URL, UID, password);
	}

	/**
	 * 數據庫直連（FOR MYSQL）
	 */
	public void dataConnDerectForMySql() {
		super.derectConnectForMySql(className, URL);
	}

	/**
	 * 連接池
	 */
	public void dataConnPool() {
		super.setJNDI(JNDI);
	}

	/*
	 * 從xml讀取數據jndi值
	 */
	public  Connection getConnection()
	{
		try
		{	
		 
		    String URL = "jdbc:odbc:myDSN";
		    Connection c = DriverManager.getConnection(URL, "user", "pwd"); 
		    return c;		 

		}
		catch(Exception e)
		{
			e.printStackTrace();
			System.exit(0);
		}
		
		return null;
			 

	}

	private void getInitParaFromXml() {
		try {
			URL parentPath = getClass().getResource("DataConn.class");
			String childPath = parentPath.getPath().substring(0,
					parentPath.getPath().lastIndexOf('/'))
					+ "/DataConfig.xml";
			System.out.println(childPath);
			File filePath = new File(childPath);
			URL path = filePath.toURL();
			InputStream in = path.openStream();
			// InputStream in = getClass().getResourceAsStream(pathAbsolute);
			InputStreamReader fi = new InputStreamReader(in);
			BufferedReader bf = new BufferedReader(fi);
			SAXBuilder builder = new SAXBuilder();
			Document doc = builder.build(bf);
			Element root = doc.getRootElement();
			List books = root.getChildren();
			//JNDI名稱
			JNDI = ((Element) books.get(0)).getText().trim();
			//驅動名稱
			className = ((Element) books.get(1)).getText().trim();
			//數據庫地址
			URL = ((Element) books.get(2)).getText().trim();
			//用戶名
			UID = ((Element) books.get(3)).getText().trim();
			//密碼
			password = ((Element) books.get(4)).getText().trim();
			//System.out.println(JNDI);	
		} catch (NullPointerException e) {
			System.out.println("不能找到DataConfig.xml文件");
			e.printStackTrace();
		} catch (IOException e) {
			System.out.println("生成DOC出錯！");
			e.printStackTrace();
		} catch (Exception e) {
			System.out.println("讀取xml出現錯誤！");
			e.printStackTrace();
		}
	}

	/**
	 * main
	 * 
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}