package Dao;

import java.sql.*;

public class ConnectionManage {
	private static  String DRIVER_CLASS="";
	private static  String DATABASE_URI="";
	private static  String DATABASE_USER="";
	private static String DATABASE_PASS="";
	
	//返回連接
	public static synchronized Connection getConnection()throws DBAccessException
	{
		
		//讀出配置信息
	     DRIVER_CLASS = Env.getInstance().getProperty("driver");
	     DATABASE_URI = Env.getInstance().getProperty("url");
	     DATABASE_USER = Env.getInstance().getProperty("user");
	     DATABASE_PASS = Env.getInstance().getProperty("password");
		Connection  con = null;
		try
		{
			
			
			Class.forName(DRIVER_CLASS);
			con = DriverManager.getConnection(DATABASE_URI,DATABASE_USER,DATABASE_PASS);			
			
			
		}catch(Exception ex)
		{
			
			ex.printStackTrace();
			//throw new DBAccessException("不能取得數據庫連接");
		}
		return con;
	}
	
	//關閉連接
	public static void closeConnection(Connection con)
	{
		try
		{
			if(con != null && !con.isClosed())
			{
				con.close();
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
	//關閉結果集
	public static void closeResultSet(ResultSet rs)
	{
		try
		{
			if(rs != null)
			{
				rs.close();
				rs = null;
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
	//關閉語句
	public static void closeStatement(Statement st)
	{
		try
		{
			if(st != null)
			{
				st.close();
				st = null;
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
}