java操作Access.mdb数据库的实现.doc

java如何操作access数据库呢?请看下面的例子:[不知道为什么,插入代码时报错,所以就直接贴出来] package mon; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class MsAccessDBUtils { private static MsAccessDBUtils instance = null; public static MsAccessDBUtils getInstance() { if (instance == null) { instance = new MsAccessDBUtils(); } return instance; } private MsAccessDBUtils() {} //最先被调用 mdbFile=d:\xxx.mdb public void loadConfig(String mdbFile,String user,String psw) throws Exception{ mdb_file = mdbFile; user = user; pwd = psw; loadDriver(); } public void loadConfig(String mdbFile) throws Exception{ mdb_file = mdbFile; loadDriver(); } private static String dirverClass = sun.jdbc.odbc.JdbcOdbcDriver; //jdbc:odbc:Driver={MicroSoft Access Driver　*.mdb)};DBQ = Northwind.mdb //jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\\test.mdb private static String url = jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=; private static String mdb_file = null;//access 文件[这里要绝对路径] private static String user = ; private static String pwd = ; private static Connection conn; private static Statement stmt; private static ResultSet rs; private void loadDriver() throws Exception{ try { Class.forName(dirverClass); } catch (Exception e) { throw e; } } //创建不可滚动的连接 public static void connect() throws Exception{ try { System.out.println(url+mdb_file); System.out.println(user); System.out.println(pwd); conn = DriverManager.getConnection(url+mdb_file, user, pwd); stmt = conn.createStatement(); } catch (Exception e)