import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class AccessJdbc {
public static void main(String[] args) {
Connection conn = null;
Statement ps = null;
ResultSet rs = null;
try {
// Access注册驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// url地址(*.mdb, *.accdb)括号内容中间"逗号"后面要有空格
String url = "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\Users\\Administrator\\Desktop\\11.accdb";
conn = DriverManager.getConnection(url);
ps = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = ps.executeQuery("select * from test");
while (rs.next()) {
System.out.println(rs.getString(1));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
ps.close();
conn.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
}