conn.java

来自「用jsp写的选课系统」· Java 代码 · 共 54 行

package test; 


import java.sql.*; 

public class Conn { 

   Connection con; 
   Statement smt;
   ResultSet rs ; 

   public void init(String dburl)  {
    
   try {

     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con =DriverManager.getConnection(dburl);
  //   conn = DriverManager.getConnection(dburl);

   } catch(java.lang.ClassNotFoundException e) { 

     System.err.println("Load Driver Error: " + e.getMessage()); 

   } catch(SQLException ex) { 
 
     System.err.println("Get Connection Error: " + ex.getMessage()); 
   } 
   }

   public ResultSet executeQuery(String sql) { 

   try { 

     smt = con.createStatement(); 

     rs = smt.executeQuery(sql); 

   } catch(SQLException ex) { 

     System.err.println("SQL Error: " + ex.getMessage()); 
   } 

     return rs; 

   } 

   public void close() throws SQLException {
      
     smt.close(); 
     con.close();
	
   }
}