home *** CD-ROM | disk | FTP | other *** search
/ BUG 15 / BUGCD1998_06.ISO / aplic / jbuilder / jsamples.z / CalcColumnFrame1.java < prev    next >
Encoding:
Java Source  |  1997-07-24  |  3.3 KB  |  81 lines
  1. package borland.samples.tutorial.dataset.calccolumn;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.*;
  5. import borland.jbcl.control.*;
  6. import borland.jbcl.layout.*;
  7. import borland.jbcl.dataset.*;
  8. import borland.jbcl.util.*;   // add this import statement
  9. import java.math.BigDecimal;
  10.  
  11.  
  12. public class CalcColumnFrame1 extends DecoratedFrame {
  13.   BorderLayout borderLayout1 = new BorderLayout();
  14.   BevelPanel bevelPanel1 = new BevelPanel();
  15.   NavigatorControl navigatorControl1 = new NavigatorControl();
  16.   Database database1 = new Database();
  17.   QueryDataSet queryDataSet1 = new QueryDataSet();
  18.   GridControl gridControl1 = new GridControl();
  19.   Column column1 = new Column();
  20.   GridBagLayout gridBagLayout1 = new GridBagLayout();
  21.  
  22.  
  23.   //Construct the frame
  24.   public CalcColumnFrame1() {
  25.     try {
  26.       jbInit();
  27.     }
  28.     catch (Exception e) {
  29.       borland.jbcl.util.Diagnostic.printStackTrace(e);
  30.     };
  31.   }
  32.  
  33.   //Component initialization
  34.   public void jbInit() throws Exception{
  35.     this.setLayout(borderLayout1);
  36.     this.setTitle("Calculated Columns Example");
  37.     bevelPanel1.setLayout(gridBagLayout1);
  38.     navigatorControl1.setLabels(new String[] {"First", "Prior", "Next", "Last", "Insert", "Delete", "Post", "Cancel", "Ditto", "Save", "Refresh"});
  39.     database1.setConnection(new borland.jbcl.dataset.ConnectionDescriptor("jdbc:odbc:dataset tutorial", "sysdba", "masterkey", false, "sun.jdbc.odbc.JdbcOdbcDriver;borland.interclient.Driver"));
  40.     queryDataSet1.setQuery(new borland.jbcl.dataset.QueryDescriptor(database1, "select * from employee", null, true, false));
  41.     queryDataSet1.addCalcFieldsListener(new CalcColumnFrame1_queryDataSet1_calcFieldsAdapter(this));
  42.     gridControl1.setDataSet(queryDataSet1);
  43.     column1.setAlignment(borland.jbcl.util.Alignment.LEFT | borland.jbcl.util.Alignment.TOP);
  44.     column1.setCalcType(borland.jbcl.dataset.CalcType.CALC);
  45.     column1.setCaption("NEW_SALARY");
  46.     column1.setColumnName("NEW_SALARY");
  47.     column1.setDataType(borland.jbcl.util.Variant.BIGDECIMAL);
  48.     column1.setDisplayMask("");
  49.     column1.setEditMask("");
  50.     column1.setExportDisplayMask("");
  51.     this.add(bevelPanel1, BorderLayout.CENTER);
  52.     bevelPanel1.add(navigatorControl1, new GridBagConstraints2(0, 0, 1, 1, 1.0, 0.0
  53.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(10, 7, 0, 0), -9, 9));
  54.     bevelPanel1.add(gridControl1, new GridBagConstraints2(0, 1, 2, 1, 1.0, 1.0
  55.             ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(28, 40, 10, 7), -1316, -666));
  56.     queryDataSet1.setColumns(new Column[] {column1});
  57.   }
  58.  
  59.   
  60.   void queryDataSet1_calcFields(ReadRow readRow, DataRow dataRow, boolean boolean1)
  61.     throws DataSetException
  62.   {
  63.     dataRow.setBigDecimal("New_Salary", readRow.getBigDecimal("SALARY").multiply(new BigDecimal(1.1)));
  64.   }
  65. }
  66.  
  67. class CalcColumnFrame1_queryDataSet1_calcFieldsAdapter implements borland.jbcl.dataset.CalcFieldsListener {
  68.   CalcColumnFrame1 adaptee;
  69.  
  70.   CalcColumnFrame1_queryDataSet1_calcFieldsAdapter(CalcColumnFrame1 adaptee) {
  71.     this.adaptee = adaptee;
  72.   }
  73.  
  74.   public void calcFields(ReadRow readRow, DataRow dataRow, boolean boolean1)
  75.     throws DataSetException
  76.   {
  77.     adaptee.queryDataSet1_calcFields(readRow, dataRow, boolean1);
  78.   }
  79. }
  80.  
  81.