?? scoredaofactory.java
字號:
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();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -