package Dao;

import java.sql.*;

public class ConnectionManage {
	private static final String DRIVER_CLASS="";
	private static final String DATABASE_URI="";
	private static final String DATABASE_USER="";
	private static final String DATABASE_PASS="";
	
	//返回連接
	public static Connection getConnection()
	{
		Connection  con = null;
		try
		{
			Class.forName(DRIVER_CLASS);
			con = DriverManager.getConnection(DATABASE_URI,DATABASE_USER,DATABASE_PASS);
			
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		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)
			{
				rs.close();
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
}