在从有用的用户那里得到建议后,我对代码进行了一些更改。
 我缺少什么来加载该驱动程序?
建议我购买Jackcess,并将其包含在我的图书馆中。我正在使用Java 8
 我没有过去

Connection conn = DriverManager.getConnection(database, "", "");


在它抛出一堆异常之前。

import java.sql.*;
import javax.swing.JOptionPane;
import java.sql.DriverManager;
 private void SubmitActionPerformed(java.awt.event.ActionEvent evt) {

    try {
        String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=db1.mdb;";
        Connection conn = DriverManager.getConnection(database, "", "");
        //String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        //Class.forName(driver);
        // String db = "jdbc:odbc:db1";
        //con = DriverManager.getConnection(db);
        st = conn.createStatement();
        System.out.println("it actually ready this set of code!");
        String un = UserName.getText().trim();
        String pw = Password.getText().trim();
        String sql = "select user,pass from Table2 where user='"+un+"'and pass='"+pw+"'";
        rs=st.executeQuery(sql);
        int count = 0;
        while(rs.next()){
            count = count+1;
        }
        if (count==1){
            JOptionPane.showMessageDialog(null,"User, Found Access Granted!");
        }
        else if (count>1){
            JOptionPane.showMessageDialog(null,"Duplicate User, Access Denied!");
        }
        else {
            JOptionPane.showMessageDialog(null, "user doesn't exsist. ");
        }

    } catch (Exception ex){
            System.out.println("exception 2, " );
            ex.printStackTrace();
    }

    // TODO add your handling code here:
}


这些是我得到的异常错误:

exception 2,
java.sql.SQLException: No suitable driver found for jdbc:odbc:Driver=   {Microsoft Access Driver (*.mdb)};DBQ=db1.mdb;
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at cdeventplanner.CdEventPlannerLogin.SubmitActionPerformed(CdEventPlannerLogin.java:118)
at cdeventplanner.CdEventPlannerLogin.access$100(CdEventPlannerLogin.java:14)
at cdeventplanner.CdEventPlannerLogin$2.actionPerformed(CdEventPlannerLogin.java:67)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6525)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6290)
at java.awt.Container.processEvent(Container.java:2234)
at java.awt.Component.dispatchEventImpl(Component.java:4881)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)
at java.awt.Container.dispatchEventImpl(Container.java:2278)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

最佳答案

您正在尝试使用JDBC访问数据库。根据Jackcess FAQ,Jackcess驱动程序不支持JDBC:


  Jackcess是否为Microsoft Access数据库提供JDBC驱动程序?
  
  很不幸的是,不行。 Jackcess API是可用于与Access数据库进行交互的功能的直接实现。目前,Jackcess库没有实现JDBC API的实现。尽管此库将为JDBC驱动程序奠定良好的基础,但实现JDBC API的当前项目范围之外。曾有几次尝试使用Jackcess为Access数据库构建JDBC驱动程序,但是大多数项目在变得不活跃之前还没有取得很大进展。但是,UCanAccess project是一个当前活动的开源项目,它提供一个基于Jackcess的JDBC驱动程序。


here提供了有关如何使用Jackcess专有DB API的更多信息。

09-28 10:26