package hsqldb.dbo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ScoreDAOFactory {

	public static final String DRIVER = "org.hsqldb.jdbcDriver";   //HSQLDB數據庫的Driver名稱

	public static final String URL = "jdbc:hsqldb:mem:score";      //將建立的內存數據庫的URL

	private static Connection connection = null;                  

	/**
	 * 建立到內存數據庫的連接
	 * @return
	 */
	public static Connection createConnection() {

		if (connection == null) {
			try {
				Class.forName(DRIVER);
				connection = DriverManager.getConnection(URL, "sa", "");
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
		}
		return connection;
	}

	/**
	 * 釋放到內存數據庫的連接
	 */
	public static void closeConnection() {
		if (connection != null)
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}

	/**
	 * 取得一個ScoreDAO的實例
	 * @return
	 */
	public static ScoreDAO getScoreDAO() {
		return new ScoreDAO();
	}

}