一个操作数据库的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());
   }
  }
 }

发表于 @ 2004年10月25日　15:47:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:用PHP的朋友们有福了~~一款全自动的PHP环境安装软件，安装即可运行，无需配置…… | 新一篇:今天做了一个ASP计数器，放出源码吧，挺简单的！