/*
 * DatabaseServletDataModule.java
 *
 * Copyright (c) 1998 Hubert A. Klein Ikkink, aka Mr.Haki
 *
 * PLEASE DO NOT MODIFY THIS SOURCE FILE WITHOUT CHANGING
 * COPYRIGHT AND AUTHOR NOTICES. THANKS.
 *
 * HUBERT A. KLEIN IKKINK SHALL NOT BE LIABLE FOR ANY DAMAGES
 * SUFFERED AS A RESULT OF USING, MODIFYING OR DISTRIBUTING
 * THIS SOFTWARE OR ITS DERIVATIVES.
 *
 */
package com.drbob42.article.dbservlet;

import java.awt.*;
import java.awt.event.*;
import borland.jbcl.layout.*;
import borland.jbcl.control.*;
import borland.jbcl.dataset.*;
import borland.sql.dataset.*;
import java.beans.*;
import java.util.*;
import java.math.BigDecimal;

/**
 * DataModule generated by JBuilder.
 *
 * @author Hubert A. Klein Ikkink
 * @version 1.0, December 03, 1998
 */
public class DatabaseServletDataModule implements DataModule{
  private static DatabaseServletDataModule myDM;
  Database database1;
  QueryDataSet queryDataSet1;
  Column column1;
  Column column2;
  Column column3;
  Column column4;
  Column column5;
  Column column6;
  Column column7;
  Column column8;
  Column column9;
  Column column10;
  Column column11;
  Column column12;

  public DatabaseServletDataModule() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    queryDataSet1 = (QueryDataSet) Beans.instantiate(getClass().getClassLoader(), QueryDataSet.class.getName());
    database1 = (Database) Beans.instantiate(getClass().getClassLoader(), Database.class.getName());
    column1 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column2 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column3 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column4 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column5 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column6 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column7 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column8 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column9 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column10 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column11 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    column12 = (Column) Beans.instantiate(getClass().getClassLoader(), Column.class.getName());
    queryDataSet1.addCalcFieldsListener(new borland.jbcl.dataset.CalcFieldsListener() {
      public void calcFields(ReadRow changedRow, DataRow calcRow, boolean isPosted) throws DataSetException {
        queryDataSet1_calcFields(changedRow, calcRow, isPosted);
      }
    });
    database1.setConnection(new borland.sql.dataset.ConnectionDescriptor("jdbc:odbc:Dataset Tutorial", "SYSDBA", "masterkey", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setQuery(new borland.sql.dataset.QueryDescriptor(database1, "SELECT * FROM EMPLOYEE", null, false, Load.ALL));
    column1.setCaption("Employee number");
    column1.setColumnName("EMP_NO");
    column1.setDataType(borland.jbcl.util.Variant.SHORT);
    column2.setCaption("First name");
    column2.setColumnName("FIRST_NAME");
    column2.setDataType(borland.jbcl.util.Variant.STRING);
    column3.setCaption("Last name");
    column3.setColumnName("LAST_NAME");
    column3.setDataType(borland.jbcl.util.Variant.STRING);
    column4.setCaption("Phone extension");
    column4.setColumnName("PHONE_EXT");
    column4.setDataType(borland.jbcl.util.Variant.STRING);
    column5.setCaption("Date hired");
    column5.setColumnName("HIRE_DATE");
    column5.setDisplayMask("M/d/yy");
    column5.setDataType(borland.jbcl.util.Variant.TIMESTAMP);
    column6.setCaption("Department number");
    column6.setColumnName("DEPT_NO");
    column6.setDataType(borland.jbcl.util.Variant.STRING);
    column7.setCaption("Job code");
    column7.setColumnName("JOB_CODE");
    column7.setDataType(borland.jbcl.util.Variant.STRING);
    column8.setCaption("Job grade");
    column8.setColumnName("JOB_GRADE");
    column8.setDataType(borland.jbcl.util.Variant.SHORT);
    column9.setCaption("Job country");
    column9.setColumnName("JOB_COUNTRY");
    column9.setDataType(borland.jbcl.util.Variant.STRING);
    column10.setCaption("Salary");
    column10.setCurrency(true);
    column10.setColumnName("SALARY");
    column10.setDataType(borland.jbcl.util.Variant.BIGDECIMAL);
    column11.setCaption("Full name");
    column11.setColumnName("FULL_NAME");
    column11.setDataType(borland.jbcl.util.Variant.STRING);
    column12.setCaption("Salary (Euros)");
    column12.setCalcType(borland.jbcl.dataset.CalcType.CALC);
    column12.setColumnName("SALARY_IN_EUROS");
    column12.setDisplayMask("E ###,##0.00");
    column12.setDataType(borland.jbcl.util.Variant.BIGDECIMAL);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7, column8, column9, column10, column11, column12});
  }

  public static DatabaseServletDataModule getDataModule() {
    if (myDM == null)
      myDM = new DatabaseServletDataModule();
    return myDM;
  }

  public borland.sql.dataset.Database getDatabase1() {
    return database1;
  }

  public borland.sql.dataset.QueryDataSet getQueryDataSet1() {
    return queryDataSet1;
  }

  void queryDataSet1_calcFields(ReadRow changedRow, DataRow calcRow, boolean isPosted) throws DataSetException {
    final double CHANGE_RATE = 0.88;
    calcRow.setBigDecimal("SALARY_IN_EUROS", changedRow.getBigDecimal("SALARY").multiply(new BigDecimal(CHANGE_RATE)));
  }
}