Java连接ODBC数据源的简单示例

import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;

public class testAcess {
 public static void main(String args[]) throws Exception {
  // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  // String dburl ="jdbc:odbc:driver={Microsoft Access Driver
  // (*.mdb)};DBQ=Mobile.mdb";//此为NO-DSN方式
  String dburl = "jdbc:odbc:Attendance";// 此为ODBC连接方式

  DriverManager.registerDriver(new JdbcOdbcDriver());
  Connection conn = DriverManager.getConnection(dburl);
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery("select Top 20 * from staff");

  while (rs.next()) {
   System.out.println(rs.getString(1));
  }
  rs.close();
  stmt.close();
  conn.close();
 }
}