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;
    }

 }