用纯JAVA连接ACCESS数据库例子

package db;

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

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

       String userName = "sa";
       String userPwd = "";
       Connection dbConn;
       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());
       }
  
  }

}