Importjava. SQL. *; Dependency {Stringdriversun. jdbc. odbc. connector; Stringurljdbc: odbc: Driver {MicroSoftAccessDriver *. mdb)}; DBQNorthwind. mdb; Stringuser; Stringpwd; Connectionconn; Statements
Import java. SQL. *; public class AccessDB {String driver = "sun. jdbc. odbc. jdbcOdbcDriver "; String url =" jdbc: odbc: Driver = {MicroSoft Access Driver *. mdb)}; DBQ = Northwind. mdb "; String user =" "; String pwd =" "; Connection conn; Statement s
Import java. SQL .*;
Public class AccessDB {
String driver = "sun. jdbc. odbc. JdbcOdbcDriver ";
String url = "jdbc: odbc: Driver = {MicroSoft Access Driver
*. Mdb)}; DBQ = Northwind. mdb ";
String user = "";
String pwd = "";
Connection conn;
Statement stmt;
ResultSet rs;
Public MyDB (){
Try {
Class. forName (driver );
} Catch (Exception e ){
System. out. println (e );
}
}
// Create a connection that cannot be rolled
Public void connect (){
Try {
Conn = DriverManager. getConnection (url, user, pwd );
Stmt = conn. createStatement ();
} Catch (Exception e ){
System. out. println (e );
}
}
// Create a rolling connection
Public void connect2 (){
Try {
Conn = DriverManager. getConnection (url, user, pwd );
Stmt = conn. createStatement (ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet. CONCUR_READ_ONLY );
} Catch (Exception e ){
System. out. println (e );
}
}
// Close the connection
Public void close (){
Try {
If (stmt! = Null ){
Stmt. close ();
}
If (conn! = Null ){
Conn. close ();
}
} Catch (Exception e ){
System. out. println (e );
}
}
// Query statement
Public ResultSet executeQuery (String SQL ){
Try {
If (stmt = null ){
Connect ();
}
Rs = stmt.exe cuteQuery (SQL );
} Catch (Exception e ){
System. out. println (e );
}
Return rs;
}
}