Question

java 图形界面 不会... 求一个不用数据源的数据管理（用到access的）

Answer 1

public static void mdbTest(String mdbPath) throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+mdbPath;
Connection conn = DriverManager.getConnection(url, "admin", null);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT name FROM MSysObjects WHERE type=1 AND flags=0");
while(rs.next()){
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
参数直接写MDB文件的路径和文件名