?? dbconnection.java~8~
字號:
package informationsystem.database;
import java.sql.*;
/**
* 這個類主要是維護與數據庫的連接;
*/
public class DBConnection {
private String db_user;
private String db_password;
static final String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
static final String strConn = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/BookStore_MSAccess.mdb";
public DBConnection(String user, String password) {
this.db_user = user;
this.db_password = password;
}
// 獲取數據庫連接;
public Connection getConnection() throws SQLException {
try {
Class.forName("org.gjt.mm.mysql.Driver");
}
catch (Exception ex) {
ex.printStackTrace();
}
return java.sql.DriverManager.getConnection(strConn, this.db_user,
this.db_password);
}
private static String loadDriver() {
String sErr = "";
try {
java.sql.DriverManager.registerDriver( (java.sql.Driver) (Class
.forName(DBDriver).newInstance()));
}
catch (Exception e) {
sErr = e.toString();
}
return (sErr);
}
// 關閉數據庫連接
public static void close(Connection conn) {
try {
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -