testjdbc.java

来自「这是一个关于JSP网页开发的,我一般用JBUILDER开发,别的不知道」· Java 代码 · 共 29 行

package ch6; 
import java.sql.*; 
public class testJDBC { 
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
String sConnStr = "jdbc:odbc:testJDBC"; 
Connection conn = null; 
ResultSet rs = null; 
public testJDBC() { 
try { 
Class.forName(sDBDriver); 
} 
catch(java.lang.ClassNotFoundException e) { 
System.err.println("testJDBC(): " + e.getMessage()); 
} 
} 

public ResultSet executeQuery(String testJDBC) { 
rs = null; 
try { 
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement(); 
rs = stmt.executeQuery(testJDBC); 
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage()); 
} 
return rs; 
} 
}