Java开发网 - 一个花了一个星期都未能解决的问题!

Topic: 一个花了一个星期都未能解决的问题!

1.一个花了一个星期都未能解决的问题!

Posted by: huangyinping
Posted on: 2006-04-01 23:11

import java.sql.*;

import java.sql.Connection;

public class Lianxi {

public static void main(String[] args) {

try {
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
  System.out.println(e.getMessage());
}

String url = "jdbc:odbc:driver={ Microsoft Access Driver (*.mdb)};DBQ=e:/db.mdb";
Connection con = DriverManager.getConnection(url, "", "");
Statement stmt = con.createStatement();
String query = "select * from user";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String str = rs.getString("name");
System.out.println(str);
}
con.close();
}
catch(SQLException e){
  System.out.println("*********");
  System.out.println("SQLException in main:"+e.getMessage());
  System.out.println("**SQLState:"+e.getSQLState());
  System.out.println("**SQL Error Code:"+e.getErrorCode());
  System.out.println("*********");
  e.printStackTrace();

}
catch (Exception e) {
e.printStackTrace();
}

}
}
运行时出现以下情况,在附件里有详细结果,忘高手们驻足几分钟啊!

新建 Microsoft Word 文档 (3).doc (330.5k)