firm.java

JSP+access网上投票系统jsp+access+javabean 我的课程设计作业,代码都是自己写的.比较简单哦 呵呵~~~我是即将毕业的本科生.有经验有作品的

package firm;
import java.sql.*;

public class firm 
{
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:firm";
  private Connection conn = null;
  private Statement stmt = null;
  ResultSet rs = null;

  public firm() 
  {
    try 
    {
      Class.forName(sDBDriver); 
    }
    catch(java.lang.ClassNotFoundException e)
    {
      System.err.println("firm(): " + 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 e)
    {
      e.printStackTrace();
     }
  }

  public void closeConn()
  {
    try
    {
      conn.close();
    }
    catch(SQLException e)
    {
      e.printStackTrace();
    }
  }
}