JavaÈçºÎÁ¬½ÓAccessÊý¾Ý¿â£¨Á½ÖÖ·½Ê½ÊµÀý´úÂ룩

import java.sql.*;
public class ConnectAccess {
/**
* ³õѧÕßÇë×¢Ò⣺
* 1:ÏȽ¨Á¢Ò»¸öaccessÎļþa1.mdb,²¢·ÅÔÚD:\ÏÂ;
* 2:ÔÚÊý¾Ý¿âÎļþa1.mdbÖн¨Á¢Ò»¸ö±íTable1£»
* 3£ºÎªTable1Ìí¼ÓÒ»ÁУ¬²¢²åÈëÖÁÉÙÒ»Ìõ¼Ç¼£»
* 4£º±¾ÎÄÊÇÒ»¸öÍêÕûµÄÀֱ࣬½ÓÄÃÈ¥ÔËÐоͿÉÒÔ¡£
*/
public static void main(String args[]) throws Exception {
ConnectAccess ca=new ConnectAccess();
ca.ConnectAccessFile();
ca.ConnectAccessDataSource();
}
public void ConnectAccessFile() throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/**
* Ö±½ÓÁ¬½ÓaccessÎļþ¡£
*/
String dbur1 = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\a1.mdb";
Connection conn = DriverManager.getConnection(dbur1, "username", "password");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from Table1");
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
public void ConnectAccessDataSource()throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/**
* ²ÉÓÃODBCÁ¬½Ó·½Ê½ ÈçºÎ½¨Á¢ODBCÁ¬½Ó£¿
* ´ð£ºÔÚwindowsÏ£¬¡¾¿ªÊ¼¡¿->¡¾¿ØÖÆÃæ°å¡¿->¡¾ÐÔÄܺÍά»¤¡¿->¡¾¹ÜÀí¹¤¾ß¡¿->¡¾Êý¾ÝÔ´¡¿£¬ÔÚÊý¾ÝÔ´ÕâÀïÌí¼ÓÒ»¸öÖ¸Ïòa1.mdbÎļþµÄÊý¾ÝÔ´¡£
* ±ÈÈç´´½¨Ãû×ÖΪdataS1
*/
String dbur1 = "jdbc:odbc:dataS1";// ´ËΪODBCÁ¬½Ó·½Ê½
Connection conn = DriverManager.getConnection(dbur1, "username", "password");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from Table1");
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
}