作者：未知 来源：月光软件站 加入时间：2005-2-28　月光软件站

一个操作数据库的Java Bean，有兴趣的朋友看一下吧~~

package dbconnect;

 import java.sql.*;
 
 public class sqlconnection
 {
  
  String sDbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr  = "jdbc:odbc:sqlconnect"; // sqlconnect 数据源名称；
  private Connection conn = null;
  private Statement stmt  = null;
  ResultSet rs = null;
  
  public sqlconnection()
  {
   try
   {
    Class.forName(sDbDriver);
   }catch(java.lang.ClassNotFoundException e){
    System.err.println("sqlconnection():" + e.getMessage());
   }
  }
  
  public ResultSet executeQuery(String sql)
  {
   rs = null;
   try
   {
    conn = DriverManager.getConnection(sConnStr);
    stmt = conn.createStatement();
    rs  = stmt.executeQuery(sql);
   }catch (SQLException ex){
    System.err.println("aq.executeQuery:" + ex.getMessage());
   }
   return rs;
  }
  
  public void executeUpdate(String sql)
  {
   stmt = null;
   rs   = null;
   try
   {
    conn = DriverManager.getConnection(sConnStr);
    stmt = conn.createStatement();
    stmt.executeQuery(sql);
    stmt.close();
    conn.close();
   }catch (SQLException ex){
    System.err.println("aq.executeQuery:" + ex.getMessage());
   }
  }
  
  public void closeStmt()
  {
   try
   {
    stmt.close();
   }catch (SQLException ex){
    System.err.println("aq.executeQuery:" + ex.getMessage());
   }
  }
  
  public void closeConn()
  {
   try
   {
    conn.close();
   }catch (SQLException ex){
    System.err.println("aq.executeQuery:" + ex.getMessage());
   }
  }
 }

相关软件：