Define

The Define() step is where specific data definitions are established by your application and/or process. This involves defining columns/fields and creating the tables/files with optional indices.

Below is the code for Define():

   //

   // Define()

   //

   // Create the tables

   //

   private static void Define ()

   {

      System.out.println("DEFINE");

      // delete tables ...

      Delete_Tables();

      // ...and re-create them with constraints

      Create_CustomerMaster_Table();

      Create_ItemMaster_Table();

      Create_CustomerOrders_Table();

      Create_OrderItems_Table();

      try

      {

         conn.commit();

      }

      catch (SQLException e)

      {

         Handle_Exception(e);

      }

   }

   //

   // Create_CustomerMaster_Table()

   //

   // Create the table CustomerMaster

   //

   private static void Create_CustomerMaster_Table ()

   {

      // define table CustomerMaster

      System.out.println("\ttable CustomerMaster");

      try

      {

         stmt.executeUpdate("CREATE TABLE custmast (" +

            "cm_custnumb CHAR(4) PRIMARY KEY, " +

            "cm_custzipc CHAR(9), " +

            "cm_custstat CHAR(2), " +

            "cm_custrtng CHAR(1), " +

            "cm_custname VARCHAR(47), " +

            "cm_custaddr VARCHAR(47), " +

            "cm_custcity VARCHAR(47))"

         );

      }

      catch (SQLException e)

      {

         Handle_Exception(e);

      }

   }

   //

   // Create_CustomerOrders_Table()

   //

   // Create the table CustomerOrders

   //

   private static void Create_CustomerOrders_Table ()

   {

      // define table CustomerOrders

      System.out.println("\ttable CustomerOrders");

      try

      {

         stmt.executeUpdate("CREATE TABLE custordr (" +

            "co_ordrdate DATE, " +

            "co_promdate DATE, " +

            "co_ordrnumb CHAR(6) PRIMARY KEY, " +

            "co_custnumb CHAR(4), " +

            "FOREIGN KEY (co_custnumb) REFERENCES custmast)"

         );

      }

      catch (SQLException e)

      {

         Handle_Exception(e);

      }

   }

   //

   // Create_OrderItems_Table()

   //

   // Create the table OrderItems

   //

   private static void Create_OrderItems_Table ()

   {

      // define table OrderItems

      System.out.println("\ttable OrderItems");

      try

      {

         stmt.executeUpdate("CREATE TABLE ordritem (" +

            "oi_sequnumb SMALLINT, " +

            "oi_quantity SMALLINT, " +

            "oi_ordrnumb CHAR(6), " +

            "oi_itemnumb CHAR(5), " +

            "FOREIGN KEY (oi_itemnumb) REFERENCES itemmast, " +

            "FOREIGN KEY (oi_ordrnumb) REFERENCES custordr)"

         );

      }

      catch (SQLException e)

      {

         Handle_Exception(e);

      }

   }

   //

   // Create_ItemMaster_Table()

   //

   // Create the table ItemMaster

   //

   private static void Create_ItemMaster_Table ()

   {

      // define table ItemMaster

      System.out.println("\ttable ItemMaster");

      try

      {

         stmt.executeUpdate("CREATE TABLE itemmast (" +

            "im_itemwght INTEGER, " +

            "im_itempric MONEY, " +

            "im_itemnumb CHAR(5) PRIMARY KEY, " +

            "im_itemdesc VARCHAR(47))"

         );

      }

      catch (SQLException e)

      {

         Handle_Exception(e);

      }

   }