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