數據庫為 JavaFee.mdb 存放在DATA 目錄下,密碼為:1234.
連接語句如下
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String path=System.getProperty("user.dir");
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path+"\\Data\\JavaFee.mdb;pwd="+"1234"+";";
try {
con = DriverManager.getConnection(strurl);
} catch (SQLException ex) {
JOptionPane.showMessageDialog(MoneyControlView.this, "數據庫文件丟失,請檢查!", "數據檢查", JOptionPane.ERROR_MESSAGE);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(MoneyControlView.class.getName()).log(Level.SEVERE, null, ex);
}