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

《java操作Access.mdb数据库的实现》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、java如何操作access数据库呢?请看下面的例子:[不知道为什么,插入代码时报错,所以就直接贴出来]packagecom.ria.utils.common;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.

2、List;importjava.util.Map;publicclassMsAccessDBUtils{privatestaticMsAccessDBUtilsinstance=null;publicstaticMsAccessDBUtilsgetInstance(){if(instance==null){instance=newMsAccessDBUtils();}returninstance;}privateMsAccessDBUtils(){}//最先被调用mdbFile=d:xxx.mdbpublicvoidloadConfig(StringmdbFi

3、le,Stringuser,Stringpsw)throwsException{mdb_file=mdbFile;user=user;pwd=psw;loadDriver();}publicvoidloadConfig(StringmdbFile)throwsException{mdb_file=mdbFile;loadDriver();}privatestaticStringdirverClass="sun.jdbc.odbc.JdbcOdbcDriver";//jdbc:odbc:Driver={MicroSoftAccessDriver　*.mdb)};D

4、BQ=Northwind.mdb//jdbc:odbc:Driver={MicrosoftAccessDriver(*.mdb)};DBQ=C:\test.mdbprivatestaticStringurl="jdbc:odbc:Driver={MicrosoftAccessDriver(*.mdb)};DBQ=";privatestaticStringmdb_file=null;//access文件[这里要绝对路径]privatestaticStringuser="";privatestaticStringpwd="";privatestaticConnec

5、tionconn;privatestaticStatementstmt;privatestaticResultSetrs;privatevoidloadDriver()throwsException{try{Class.forName(dirverClass);}catch(Exceptione){throwe;}}//创建不可滚动的连接publicstaticvoidconnect()throwsException{try{System.out.println(url+mdb_file);System.out.println(user);System.out.

6、println(pwd);conn=DriverManager.getConnection(url+mdb_file,user,pwd);stmt=conn.createStatement();}catch(Exceptione){throwe;}}publicstaticvoidconnect(booleanautocommit)throwsException{try{conn=DriverManager.getConnection(url+mdb_file,user,pwd);conn.setAutoCommit(autocommit);stmt=conn.

7、createStatement();}catch(Exceptione){throwe;}}//创建可以滚动的连接publicstaticvoidconnect2()throwsException{try{conn=DriverManager.getConnection(url+mdb_file,user,pwd);stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);}catch(Exceptione){throwe;}}//关闭连接pub

8、licstaticvoi