dbexecutebean.java

JAVA学习资料（ZIP压缩文件）

package bookSearchOrderBean;    //定义JavaBean所在的包

import java.sql.*;

public class DBexecuteBean
 {
  /* 这是一个对数据库操作的JavaBean */

  Connection con;
  Statement stmt;
  ResultSet rset;

  public ResultSet getTableRecords(String sSQLCmd)
    {
     /* 这个方法（函数）用于对数据表中的记录进行检索 */

     try
       {
        DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
        con = DriverManager.getConnection("jdbc:odbc:DemoDB","demo","demo");
        stmt = con.createStatement ();
        rset = stmt.executeQuery(sSQLCmd);
       }
     catch(SQLException e)
       {
        System.out.println(e.toString());
       }

     return rset;
    }

  public int doTSQL(String sSQLCmd)
    {
     /* 这个方法（函数）是进行数据修改和删除的操作 */

     int f = 0;

     try
       {
        DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
        con = DriverManager.getConnection("jdbc:odbc:DemoDB","demo","demo");
        stmt.executeUpdate(sSQLCmd);
        f = 1;
       }
     catch(SQLException e)
       {
        f = 0;
        System.out.println(e.toString());
       }

     return f;
    }

 }