TaskLookupController.java

package demo17;

import org.openswing.swing.lookup.client.LookupController;
import org.openswing.swing.lookup.client.LookupDataLocator;
import org.openswing.swing.message.receive.java.*;
import java.sql.*;
import java.util.*;
import javax.swing.JTree;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.tree.DefaultMutableTreeNode;
import org.openswing.swing.server.QueryUtil;
import org.openswing.swing.message.send.java.GridParams;
import org.openswing.swing.tree.java.OpenSwingTreeNode;
import org.hibernate.SessionFactory;
import org.hibernate.type.Type;
import org.hibernate.Session;
import org.openswing.swing.util.server.HibernateUtils;


/**
 * <p>Title: OpenSwing Framework</p>
 * <p>Description: Lookup Controller that validate task codes.</p>
 * <p>Copyright: Copyright (C) 2006 Mauro Carniel</p>
 * <p> </p>
 * @author Mauro Carniel
 * @version 1.0
 */
public class TaskLookupController extends LookupController {


  private SessionFactory sessions = null;


  public TaskLookupController(SessionFactory sessions) {
    this.sessions = sessions;

    this.setLookupDataLocator(new LookupDataLocator() {

      /**
       * Method called by lookup controller when validating code.
       * @param code code to validate
       * @return code validation response: VOListResponse if code validation has success, ErrorResponse otherwise
       */
      public Response validateCode(String code) {
        try {
          String baseSQL = "from TASKS in class demo17.TaskVO where TASKS.status='E' and taskCode='"+code+"'";
          Session sess = TaskLookupController.this.sessions.openSession(); // obtain a JDBC connection and instantiate a new Session

          Response res = HibernateUtils.getAllFromQuery(
            new HashMap(),
            new ArrayList(),
            new ArrayList(),
            TaskVO.class,
            baseSQL,
            new Object[0],
            new Type[0],
            "TASKS",
            TaskLookupController.this.sessions,
            sess
          );
          sess.close();
          return res;
        }
        catch (Exception ex) {
          ex.printStackTrace();
          return new ErrorResponse(ex.getMessage());
        }
      }

      /**
       * Method called by lookup controller when user clicks on lookup button.
       * @param action fetching versus: PREVIOUS_BLOCK_ACTION, NEXT_BLOCK_ACTION or LAST_BLOCK_ACTION
       * @param startIndex current index row on grid to use to start fetching data
       * @param filteredColumns filtered columns
       * @param currentSortedColumns sorted columns
       * @param currentSortedVersusColumns ordering versus of sorted columns
       * @param valueObjectType type of value object associated to the lookup grid
       * @return list of value objects to fill in the lookup grid: VOListResponse if data fetching has success, ErrorResponse otherwise
       */
      public Response loadData(
          int action,
          int startIndex,
          Map filteredColumns,
          ArrayList currentSortedColumns,
          ArrayList currentSortedVersusColumns,
          Class valueObjectType
          ) {
        try {
          String baseSQL = "from TASKS in class demo17.TaskVO where TASKS.status='E'";
          Session sess = TaskLookupController.this.sessions.openSession(); // obtain a JDBC connection and instantiate a new Session

//      READ WHOLE RESULT-SET...
//      Response res = HibernateUtils.getAllFromQuery(
//        filteredColumns,
//        currentSortedColumns,
//        currentSortedVersusColumns,
//        valueObjectType,
//        baseSQL,
//        new Object[0],
//        new Type[0],
//        "TASKS",
//        sessions,
//        sess
//      );
//      sess.close();
//      return res;
//      END READ WHOLE RESULT-SET...


//    READ A BLOCK OF DATA FROM RESULT-SET...
          Response res = HibernateUtils.getBlockFromQuery(
            action,
            startIndex,
            50, // block size...
            filteredColumns,
            currentSortedColumns,
            currentSortedVersusColumns,
            valueObjectType,
            baseSQL,
            new Object[0],
            new Type[0],
            "TASKS",
            TaskLookupController.this.sessions,
            sess
          );
          sess.close();
          return res;
//    END READ A BLOCK OF DATA FROM RESULT-SET...
        }
        catch (Exception ex) {
          ex.printStackTrace();
          return new ErrorResponse(ex.getMessage());
        }
      }


      /**
       * Method called by the TreePanel to fill the tree.
       * @return a VOReponse containing a DefaultTreeModel object
       */
      public Response getTreeModel(JTree tree) {
        return new VOResponse(new DefaultTreeModel(new OpenSwingTreeNode()));
      }


    });

    this.setLookupValueObjectClassName("demo17.TaskVO");
    this.addLookup2ParentLink("taskCode", "task.taskCode");
    this.addLookup2ParentLink("description", "task.description");
    this.setAllColumnVisible(true);
    this.setVisibleColumn("status",false);
    this.setPreferredWidthColumn("description", 200);
    this.setGridInsertButton(true);
    this.setGridEditButton(true);
    this.setGridDeleteButton(true);
    this.setGridExportButton(true);
    this.setGridCopyButton(true);
    this.setColumnEditableOnInsert("taskCode",true);
    this.setColumnEditableOnInsert("description",true);
    this.setColumnEditableOnEdit("taskCode",true);
    this.setColumnEditableOnEdit("description",true);
    this.setColumnRequired("taskCode",true);
    this.setColumnRequired("description",true);
    this.setLookupGridController(new TaskGridFrameController(sessions));
  }



}