package package3;

import java.awt.*;
import java.awt.event.*;
import borland.jbcl.control.*;
import borland.jbcl.layout.*;
import borland.sql.dataset.*;
import borland.jbcl.dataset.Column;

public class Frame1 extends DecoratedFrame {
BorderLayout mainLayout = new BorderLayout();

//Frame Constructor
public Frame1() {
try {
jbInit();
} catch (Exception e) {
e.printStackTrace();
}
pack();
}

//Frame initialization method
public void jbInit() throws Exception{
this.setLayout(mainLayout);
this.setTitle("Data Frame");
panel.setLayout(layout);
panelContent.setLayout(layoutContent);
labelDEP.setText("DEP");
panelContent.add(labelDEP, new XYConstraints(20, 20, 35, -1));
fieldDEP.setDataSet(dataSet);
fieldDEP.setColumnName("DEP");
panelContent.add(fieldDEP, new XYConstraints(20, 44, 46, -1));
labelCOURSE.setText("COURSE");
panelContent.add(labelCOURSE, new XYConstraints(86, 20, 62, -1));
fieldCOURSE.setDataSet(dataSet);
fieldCOURSE.setColumnName("COURSE");
panelContent.add(fieldCOURSE, new XYConstraints(86, 44, 46, -1));
labelSECTION.setText("SECTION");
panelContent.add(labelSECTION, new XYConstraints(168, 20, 63, -1));
fieldSECTION.setDataSet(dataSet);
fieldSECTION.setColumnName("SECTION");
panelContent.add(fieldSECTION, new XYConstraints(168, 44, 46, -1));
labelINSTRUCTOR.setText("INSTRUCTOR");
panelContent.add(labelINSTRUCTOR, new XYConstraints(251, 20, 89, -1));
fieldINSTRUCTOR.setDataSet(dataSet);
fieldINSTRUCTOR.setColumnName("INSTRUCTOR");
panelContent.add(fieldINSTRUCTOR, new XYConstraints(251, 44, 190, -1));
labelAUTHOR.setText("AUTHOR");
panelContent.add(labelAUTHOR, new XYConstraints(20, 84, 60, -1));
fieldAUTHOR.setDataSet(dataSet);
fieldAUTHOR.setColumnName("AUTHOR");
panelContent.add(fieldAUTHOR, new XYConstraints(20, 108, 250, -1));
labelTITLE.setText("TITLE");
panelContent.add(labelTITLE, new XYConstraints(290, 84, 42, -1));
fieldTITLE.setDataSet(dataSet);
fieldTITLE.setColumnName("TITLE");
panelContent.add(fieldTITLE, new XYConstraints(290, 108, 250, -1));
layoutContent.setWidth(560);
layoutContent.setHeight(148);
scrollPane.setSize(577, 152);
scrollPane.getVAdjustable().setUnitIncrement(64);
scrollPane.getVAdjustable().setBlockIncrement(300);
navigatorControl.setDataSet(dataSet);
panel.add(navigatorControl, BorderLayout.NORTH);
scrollPane.add(panelContent);
panel.add(scrollPane, BorderLayout.CENTER);
this.add(panel, BorderLayout.CENTER);
database1.setConnection(new ConnectionDescriptor("jdbc:oracle:thin:@192.168.1.4:1521:ORCL", "charless", "pinnsoft", true, "oracle.jdbc.driver.OracleDriver"));
dataSet.setQuery(new QueryDescriptor(database1, "select DEP, COURSE, SECTION, INSTRUCTOR, AUTHOR, TITLE, ROWID from BOOKS", null, true, false));
dataSet.setTableName("BOOKS");
dataSet.setSchemaName("CHARLESS");
dataSet.setMetaDataUpdate(borland.jbcl.dataset.MetaDataUpdate.NONE);
columnROWID.setColumnName("ROWID");
columnROWID.setDataType(borland.jbcl.util.Variant.STRING);
columnROWID.setRowId(true);
columnROWID.setVisible(borland.jbcl.util.TriState.NO);
dataSet.setColumns(new Column[] {columnROWID});
}
Panel panel = new Panel();
Panel panelContent = new Panel();
BorderLayout layout = new BorderLayout();
NavigatorControl navigatorControl = new NavigatorControl();
XYLayout layoutContent = new XYLayout();
ScrollPane scrollPane = new ScrollPane();
LabelControl labelDEP = new LabelControl();
TextFieldControl fieldDEP = new TextFieldControl();
LabelControl labelCOURSE = new LabelControl();
TextFieldControl fieldCOURSE = new TextFieldControl();
LabelControl labelSECTION = new LabelControl();
TextFieldControl fieldSECTION = new TextFieldControl();
LabelControl labelINSTRUCTOR = new LabelControl();
TextFieldControl fieldINSTRUCTOR = new TextFieldControl();
LabelControl labelAUTHOR = new LabelControl();
TextFieldControl fieldAUTHOR = new TextFieldControl();
LabelControl labelTITLE = new LabelControl();
TextFieldControl fieldTITLE = new TextFieldControl();
Database database1 = new Database();
QueryDataSet dataSet = new QueryDataSet();
Column columnROWID = new Column();
}