import java.sql.*;public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:Customers";
Connection conn = null;
ResultSet rs = null;
public DBconn () {
try {
Class.forName(DBDriver).newInstance();
} catch (ClassNotFoundException e) {
System.err.println("DBconn() Got ClassNotFoundException : "
+ e.getMessage());
} catch (IllegalAccessException e) {
System.err.println("DBconn() Got IllegalAccessException : "
+ e.getMessage());
} catch (InstantiationException e) {
System.err.println("DBconn() Got InstantiationException : "
+ e.getMessage());
}
} public ResultSet executeQuery (String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//DBMS
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
}
}
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:Customers";
Connection conn = null;
ResultSet rs = null;
public DBconn () {
try {
Class.forName(DBDriver).newInstance();
} catch (ClassNotFoundException e) {
System.err.println("DBconn() Got ClassNotFoundException : "
+ e.getMessage());
} catch (IllegalAccessException e) {
System.err.println("DBconn() Got IllegalAccessException : "
+ e.getMessage());
} catch (InstantiationException e) {
System.err.println("DBconn() Got InstantiationException : "
+ e.getMessage());
}
} public ResultSet executeQuery (String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//DBMS
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
}
}
....
}最后一个自己仔细检查