jsp与Access连接的问题

[daimojingdeyu]

import java.sql.*;
import java.io.*;

public class openDB{

Connection conn;
Statement stm;
ResultSet rs;
String url="jdbc:odbc:tax";

public openDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
e.getMessage();
}
}

public ResultSet executeQuery(String sql){
ResultSet result = null;
System.out.println("In executeQuery");
try{
conn = DriverManager.getConnection("taxUserInfo");
stm = conn.createStatement();
result = stm.executeQuery(sql);
if(result == null) System.out.println("in executeQuery null");
else System.out.println("in executeQuery not null");
}catch(Exception e){
e.getMessage();
}
return result;
}

public int executeUpdate(String sql){
int i=-1;
try{
conn = DriverManager.getConnection("taxUserInfo","","");
stm = conn.createStatement();
i=stm.executeUpdate(sql);
}catch(Exception e){
e.getMessage();
}
return i;
}

public void close(){
try{
if(rs!=null) rs.close();
if(stm!=null) stm.close();
if(conn!=null) conn.close();
}catch(Exception e){}
}

public static void main(String[] args){
openDB db = new openDB();
String sql = "select * from taxUserInfo;";
//问题是下面这句，为什么没有显示in executeQuery null或者是
//in executeQuery not null
ResultSet result = db.executeQuery(sql);

if(result==null) System.out.println("result null");
else
try{
if(result.next()){
System.out.println("success!");

}
else{
System.out.println("error");
}
}catch(SQLException e){
}
db.close();
}
}

[xiaohuasz]

ResultSet executeQuery(String sql)
throws SQLException
Returns:
a ResultSet object that contains the data produced by the given query; never null

[sunshine5246]

你的conn = DriverManager.getConnection("taxUserInfo");有问题，你定义了url但在后面好像没有用到，或者你的odbc配置有问题。如果要用你的url的话，应该把这里改为conn = DriverManager.getConnection(url);

[sunshine5246]

个人看法

[redex]

k

[daimojingdeyu]

谢谢大家帮忙。问题已经解决了。是我的系统DSN没弄好
刚好来了两个人，每人40分