MSAccess JDBC驱动

//一个例子

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class TestAccessJDBC {
    public static void main(String[] args){
      String driverName ="sun.jdbc.odbc.JdbcOdbcDriver";
       String dbURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=./abc.mdb;";

       String userName = "";
       String userPwd = "";
       Connection dbConn=null;
       try {
           Class.forName(driverName);
           dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
           System.out.println("Connection Successful!");
          
       }
      catch (ClassNotFoundException e) {
            System.out.println(" 出错了 ：class:"+e.getMessage());
       }
       catch(SQLException sql){
        System.out.println("sql:"+sql.getMessage()+"   sTte:"+sql.getSQLState());
       }
       finally
       {
        if(dbConn!=null)
        {
         try
         {
          dbConn.close();
          dbConn = null;
         }
         catch(Throwable t)
         {}
        }
      }
 
  }

}