在从有用的用户那里得到建议后,我对代码进行了一些更改。
我缺少什么来加载该驱动程序?
建议我购买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的更多信息。