import javasql*;
public class AccessDB {
String driver = sunjdbcodbcJdbcOdbcDriver;
String url = jdbc:odbc:Driver={MicroSoft Access Driver*mdb)};DBQ = Northwindmdb;
String user = ;
String pwd = ;
Connection conn;
Statement stmt;
ResultSet rs;
public MyDB() {
try {
ClassforName(driver);
} catch (Exception e) {
Systemoutprintln(e);
}
}
//创建不可滚动的连接
public void connect() {
try {
conn = DriverManagergetConnection(urluserpwd);
stmt = conncreateStatement();
} catch (Exception e) {
Systemoutprintln(e);
}
}
//创建可以滚动的连接
public void connect() {
try {
conn = DriverManagergetConnection(urluserpwd);
stmt = conncreateStatement(ResultSetTYPE_SCROLL_INSENSITIVEResultSetCONCUR_READ_ONLY);
} catch (Exception e) {
Systemoutprintln(e);
}
}
//关闭连接
public void close() {
try {
if (stmt != null) {
stmtclose();
}
if (conn != null) {
connclose();
}
} catch (Exception e) {
Systemoutprintln(e);
}
}
//查询语句
public ResultSet executeQuery(String sql) {
try {
if (stmt == null) {
connect();
}
rs = stmtexecuteQuery(sql);
} catch (Exception e) {
Systemoutprintln(e);
}
return rs;
}
}
