7.9. Creating the Primary Modules

Now we can start creating modules. The process of creating modules is described here, using the customer module as an example. Creating the product module is similar and, if you are interested, you can examine its source code in the .zip download linked at the end of this chapter.

First, we implement a class for working with jqGrid, inheriting it from our abstract class ru.ibase.fbjavaex.jqgrid.JqGrid. It will be able to search and sort by the NAME field in reversing order. Track the source code below for explanatory comments.

  1. package ru.ibase.fbjavaex.jqgrid;
  3. import org.jooq.*;
  4. import java.util.List;
  5. import java.util.Map;
  7. import static ru.ibase.fbjavaex.exampledb.Tables.CUSTOMER;
  9. /**
  10.  * Customer grid
  11.  *
  12.  * @author Simonov Denis
  13.  */
  14. public class JqGridCustomer extends JqGrid {
  16.     /**
  17.      * Adding a search condition
  18.      *
  19.      * @param query
  20.      */
  21.     private void makeSearchCondition(SelectQuery<?> query) {
  22.         switch (this.searchOper) {
  23.             case "eq":
  24.                 // CUSTOMER.NAME = ?
  25.                query.addConditions(CUSTOMER.NAME.eq(this.searchString));
  26.                break;
  27.             case "bw":
  28.                 // CUSTOMER.NAME STARTING WITH ?
  29.                query.addConditions(CUSTOMER.NAME.startsWith(this.searchString));
  30.                break;
  31.             case "cn":
  32.                 // CUSTOMER.NAME CONTAINING ?
  33.                query.addConditions(CUSTOMER.NAME.contains(this.searchString));
  34.                break;
  35.         }
  36.     }
  38.     /**
  39.      * Returns the total number of records
  40.      *
  41.      * @return
  42.      */
  43.     @Override
  44.     public int getCountRecord() {
  45.         // query that returns the number of records
  46.         SelectFinalStep<?> select
  47.             = dsl.selectCount()
  48.                  .from(CUSTOMER);
  50.         SelectQuery<?> query = select.getQuery();
  51.         // if perform a search, then add the search condition
  52.         if (this.searchFlag) {
  53.             makeSearchCondition(query);
  54.         }
  56.         return (int) query.fetch().getValue(0, 0);
  57.     }
  59.     /**
  60.      * Returns the grid records
  61.      *
  62.      * @return
  63.      */
  64.     @Override
  65.     public List<Map<String, Object>> getRecords() {
  66.         // Basic selection query
  67.         SelectFinalStep<?> select =
  68.             dsl.select()
  69.                .from(CUSTOMER);
  71.         SelectQuery<?> query = select.getQuery();
  72.         // if perform a search, then add the search condition
  73.         if (this.searchFlag) {
  74.             makeSearchCondition(query);
  75.         }
  76.         // set the sort order
  77.         switch (this.sOrd) {
  78.             case "asc":
  79.                 query.addOrderBy(CUSTOMER.NAME.asc());
  80.                 break;
  81.             case "desc":
  82.                 query.addOrderBy(CUSTOMER.NAME.desc());
  83.                 break;
  84.         }
  85.         // limit the number of records
  86.         if (this.limit != 0) {
  87.             query.addLimit(this.limit);
  88.         }
  90.         if (this.offset != 0) {
  91.             query.addOffset(this.offset);
  92.         }
  93.         // return an array of maps
  94.         return query.fetchMaps();
  95.     }
  96. }