JavaBean数据库操作

package myprg;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class firm {
    String strDbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String strDbUrl="jdbc:odbc:firm";
    private Connection conn=null;
    private Statement stmt=null;
    ResultSet rs=null;
    //<!--注册数据库驱动程序-->
    public firm() {
        try
        { Class.forName(strDbDriver);
        }
        catch(java.lang.ClassNotFoundException e)
        {System.err.println("firm():"+e.getMessage() ); }
    }
   
    //<!--建立数据库连接及数据查询-->
    public ResultSet executeQuery(String sql)
    { rs=null;
      try
      {
          conn=DriverManager.getConnection(strDbUrl,"sa","");
          stmt=conn.createStatement() ;
          rs=stmt.executeQuery(sql) ;
      }
      catch(SQLException ex)
      {
          System.err.println("aq.executeQuery():"+ex.getMessage()) ;
      }
      return rs;
  }
  //<!--定义数据操作-->
  public void executUpdate(String sql)
  { stmt=null;
    rs=null;
    try
    {
        conn=DriverManager.getConnection(strDbUrl,"sa","");
        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)
      {
          ex.printStackTrace() ;
      }
  }
  public void closeConn()
  {  try
      { conn.close();}
      catch(SQLException ex)
      {
          ex.printStackTrace() ;
      }

 
  }
 
 
}