conn.java

来自「此为图书管理系统」· Java 代码 · 共 45 行

package   com.bean.db;  
import   java.sql.*;  
import   java.io.*;  
public   class   conn   {  
private   String   sDBDriver   =   "sun.jdbc.odbc.JdbcOdbcDriver";  
private   String   sConnStr   =   "jdbc:odbc:bookSystem";  
private   Connection   connect   =   null;  
public   conn()   {  
  try   {  
  Class.forName(sDBDriver);  
  }  
  catch(java.lang.ClassNotFoundException   e)   {  
  System.err.println(   e.getMessage());  
  }  
  }  
  public   ResultSet   executeQuery(String   sql)   {  
   ResultSet   rs   =   null;  
   Statement   stmt   =   null;  
  try   {  
  connect   =   DriverManager.getConnection(sConnStr);  
  stmt   =   connect.createStatement();  
  rs   =   stmt.executeQuery(sql);  
  }  
  catch(SQLException   ex)   {  
  System.err.println(ex.getMessage());  
  }  
  return   rs;  
  }
  public String execute(String   sql)   {  
   ResultSet   rs   =   null;  
   Statement   stmt   =   null; 
   String Str="";
  try   {  
  connect   =   DriverManager.getConnection(sConnStr);  
  stmt   =   connect.createStatement();  
  stmt.execute(sql); 
  Str="OK";
  }  
  catch(SQLException   ex)   {  
  System.err.println(ex.getMessage());  
  }  
 return Str;  
  }  
  
  }