Java:MS Access和JDBC连接 [英] Java: MS Access and JDBC connectivity

问题描述

我想通过Java代码与MS Access连接.
该怎么做?

I want to connect with MS Access from my Java code.
How to do this?

我写了以下代码:

import java.sql.*;
public class Test
{
 public static void main(String[] args) 
 {
   String dataSourceName = "test";
   String dbURL = "jdbc:odbc:" + dataSourceName;
   try { 
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con = DriverManager.getConnection(dbURL, "ify","ify123");

     Statement statement = con.createStatement();
     ResultSet rs = statement.executeQuery("select * from emp");
     System.out.println("hi");
     while ( rs.next() ){
       System.out.println(rs.getString(2));
     }
   }
   catch (Exception err) {
     System.out.println( "Error: " + err );
   }
  }
}

问题是我仍然无法理解数据库. 我可能做错了什么?

The problem is that I'm still not able to coneect with the database. What I might be doing wrong?

推荐答案

这可能是驱动程序管理器注册问题.

This might be a driver manager registration problem.

您可以将备用语句用作:

You can use alternate statements as:

DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); Connection conn = DriverManager.getConnection(....);

DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); Connection conn = DriverManager.getConnection(....);

可以.

好运！

这篇关于Java:MS Access和JDBC连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！