/*我覺(jué)得這個(gè)類沒(méi)有用到，這個(gè)類只是普通方法建立數(shù)據(jù)庫(kù)連接，
 * 但是這個(gè)程序用到另外一種連接池方法，連接池我用過(guò)幾次了，
 *用到的是DBConnectionManager
 *
 */
package zhaobiao.db;

  import   java.sql.*;   
    
  public class ConnectDB{   
        String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";   
    
        String ConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zhaobiao";   
        String user="sa";   
        String password="";   
        Connection conn=null;   
        ResultSet rs=null;   
        
        public ConnectDB(){
        }
    
        public void ConnectDB() throws InstantiationException,IllegalAccessException{   
            try{   
               Class.forName(DBDriver).newInstance();   
            }   
            catch(java.lang.ClassNotFoundException e){   
               System.err.println("DBConn():"+e.getMessage());   
            }   
        }   
        public   ResultSet   executeQuery(String sql){   
            rs=null;   
            try{   
               conn=DriverManager.getConnection(ConnStr,user,password);   
               Statement stmt=conn.createStatement();   
               rs=stmt.executeQuery(sql);   
            }   
            catch(SQLException   ex){   
               System.err.println("aq.executeQuery:"+ex.getMessage());   
            }   
            return rs;   
        } 
        
        
  }