我的程序如下:
import java.sql.*;
import javax.sql.*;public class Lookup {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
String dbUrl = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=F:/lzz/eg/java/jdbc/test.mdb";
String user = "";
String password = "";
// Load the driver (registers itself)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl,user,password);
Statement s = c.createStatement();
// SQL code:
ResultSet r = s.executeQuery("SELECT test_num, test_name, test_addr FROM test ");
while(r.next()) {
// Capitalization doesn't matter:
System.out.println(
r.getString("test_num") + ", "
+ r.getString("test_name")
+ ", " + r.getString("test_addr") );
}
s.close(); // Also closes ResultSet
}
} ///:~
错误还是在驱动上:
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Driver Manag
r] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Lookup.main(Lookup.java:16)
怎么回事?
import java.sql.*;
import javax.sql.*;public class Lookup {
public static void main(String[] args)
throws SQLException, ClassNotFoundException {
String dbUrl = "jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=F:/lzz/eg/java/jdbc/test.mdb";
String user = "";
String password = "";
// Load the driver (registers itself)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(dbUrl,user,password);
Statement s = c.createStatement();
// SQL code:
ResultSet r = s.executeQuery("SELECT test_num, test_name, test_addr FROM test ");
while(r.next()) {
// Capitalization doesn't matter:
System.out.println(
r.getString("test_num") + ", "
+ r.getString("test_name")
+ ", " + r.getString("test_addr") );
}
s.close(); // Also closes ResultSet
}
} ///:~
错误还是在驱动上:
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Driver Manag
r] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Lookup.main(Lookup.java:16)
怎么回事?
odbc要在机器上设数据源的
控制面板里面=〉数据源
这个是从哪里学来的.我从来没有见过,请教一下. 通常ODBC连接,要在控制面板的数据源里,
进行配置,或者你直接用JDBC连接.