Java 链接access的mdb代码如下

access的mdb代码如下：
try{
string strurl =
"jdbc:odbc:driver={microsoftaccessdriver(*.mdb)};dbq=mytest.mdb";
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection connacce = drivermanager.getconnection(strurl);
statement stmt = connacce.createstatement();
string sql = "select * from test";
resultset rs = stmt.executequery(sql);
while (rs.next()) {
system.out.println(rs.getstring(2));
}
rs.close();
stmt.close();
connacce.close();
}catch(exception e){
e.printstacktrace();
}