scoredaofactory.java

是Eclipse web开发从入门到精通的源码

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();
	}

}