?? dbconnection.java~11~
字號(hào):
package informationsystem.database;
import java.sql.*;
/**
* 這個(gè)類主要是維護(hù)與數(shù)據(jù)庫(kù)的連接;
*/
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=E:/information.mdb";
public DBConnection(String user, String password) {
this.db_user = user;
this.db_password = password;
}
// 獲取數(shù)據(jù)庫(kù)連接;
public Connection getConnection() throws SQLException {
DBConnection.loadDriver();
return java.sql.DriverManager.getConnection(this.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);
}
// 關(guān)閉數(shù)據(jù)庫(kù)連接
public static void close(Connection conn) {
try {
conn.close();
}
catch (Exception ex) {
ex.printStackTrace();
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -