executesqlbean.java~34~

来自「bbs系统」· JAVA~34~ 代码 · 共 39 行

package bbs.beans.dbcontact;
import java.sql.*;

public class ExecuteSqlBean
{ private Connection con;
  private Statement stm;

  public ExecuteSqlBean()
  { String CFN="sun.jdbc.odbc.JdbcOdbcDriver";
    String DB="jdbc:odbc:dbcon";
    String USER="";
    String PWD="";

    try
    { Class.forName(CFN);
      con=DriverManager.getConnection(DB,USER,PWD) ;
      stm=con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
    }
    catch(Exception e)
    { e.printStackTrace();
    }
    con.close();
  }

public Statement getStm()
  {
    return stm;
  }
}