package com.yourcompany.struts;

/**
 * 
 * @author li.haibo
 *
 */

import java.sql.*;
import java.net.*;
import javax.sql.*;
import javax.naming.*;
import java.util.*;
import weblogic.jndi.WLInitialContextFactory;

/**
 * 連接數據庫操作
 * 
 * @author lihaibo
 *  
 */
public class DBConnection {
	private Connection conn = null;

	public Connection getConnection() throws Exception {
		try{
			Hashtable env=new Hashtable();
			env.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
			env.put(Context.PROVIDER_URL, "t3://localhost:7001");
			
			Context ctx=new InitialContext(env);
			DataSource ds=(DataSource)ctx.lookup("jdbc/csss");
			conn=ds.getConnection();
		}catch(Exception ex){
			ex.printStackTrace();
			throw new Exception("獲取連接錯誤!原因:"+ex.getMessage());
		}
		return conn;
	}
	public void closeStatement(Statement st){
		if(st!=null){
			try{
				st.close();
			}catch(Exception ex){
				ex.printStackTrace();
			}
		}
	}
	public void closeConnection(Connection conn){
		if(conn!=null){
			try{
				conn.close();
			}catch(Exception ex){
				ex.printStackTrace();
			}
		}
	}
	public void closeResult(ResultSet st){
		if(st!=null){
			try{
				st.close();
			}catch(Exception ex){
				ex.printStackTrace();
			}
		}
	}
}