ͨ¹ýjdbc + odbcÁ¬½ÓÊý¾Ý¿â

/*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;
 }
}