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