package com.brainysoftware.tassie.ejb;

import java.rmi.RemoteException;
import javax.ejb.SessionBean;
import javax.ejb.SessionContext;
import java.sql.*;
import java.util.ArrayList;

public class SearchBean implements SessionBean {


  private Connection getConnection() {
    Connection connection = null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      connection = DriverManager.getConnection("jdbc:odbc:TassieDB");
    }
    catch (Exception e) {
    }
    return connection;
  }

  public ArrayList search(String keyword) {
    ArrayList retval = new ArrayList(50);
    try {
      Statement statement = getConnection().createStatement();
      String sql = "SELECT Id, Title, Author, Publisher" +
        " FROM Books" +
        " WHERE Title LIKE '%" + keyword + "%'";

      ResultSet rs = statement.executeQuery(sql);
      while (rs.next()) {
        String[] row = new String[4];
        row[0] = rs.getString("Id");
        row[1] = rs.getString("Title");
        row[2] = rs.getString("Author");
        row[3] = rs.getString("Publisher");
        retval.add(row);
      }
      rs.close();
      statement.close();
    }
    catch (Exception e) {
    }
    return retval;
  }

  public void ejbCreate() {
  }

  public void ejbRemove() {
  }

  public void ejbActivate() {
  }

  public void ejbPassivate() {
  }

  public void setSessionContext(SessionContext sc) {
  }
}