在ASP中一般用ADO,ADO通过连接字符串已经指定啦驱动程序,但是至少机器上有这个驱动程序
JSP也可以的,JSP自己指定驱动程序就可以不要ODBC,除非用JDBC-ODBC桥。
下面是一个BEAN的例子
import java.sql.*;
public class DBconn {
StringDBDriver = “sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = “jdbc:odbc:Customers";
Connection conn = null;
ResultSet rs = null;
public DBconn {
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println(“DBconn (): " + 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;
}
}
使用了JDBC-ODBC桥,你可以把驱动程序改成别的比如
oracle.jdbc.driver.OracleDriver
JSP也可以的,JSP自己指定驱动程序就可以不要ODBC,除非用JDBC-ODBC桥。
下面是一个BEAN的例子
import java.sql.*;
public class DBconn {
StringDBDriver = “sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = “jdbc:odbc:Customers";
Connection conn = null;
ResultSet rs = null;
public DBconn {
try {
Class.forName(DBDriver);
//加载数据库驱动程序
}
catch(java.lang.ClassNotFoundException e) {
System.err.println(“DBconn (): " + 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;
}
}
使用了JDBC-ODBC桥,你可以把驱动程序改成别的比如
oracle.jdbc.driver.OracleDriver
package test;
import java.sql.*;
import java.lang.String;public class dd {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:dd";
Connection conn = null;
ResultSet rs = null; public dd() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("dd(): " + e.getMessage());
}
} public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
} public void update(String sql){
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
}
这个bean经过测试绝对正确的。
dd不也得在ODBC中设置时指定吗?