/*jdbc-odbc连接数据库*/
package dbJavaBean;
import java.sql.*;
public class Opendb {
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr="jdbc:odbc:one"; Connection conn=null; ResultSet rs=null;
public Opendb() { try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e){ System.err.print(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.print(ex.getMessage()); } return rs; } }

|