home *** CD-ROM | disk | FTP | other *** search
/ Symantec Visual Cafe for Java 2.5 / symantec-visual-cafe-2.5-database-dev-edition.iso / Visual Cafe Pro v1.0 / TUTORIAL.BIN / Reserve.java < prev    next >
Encoding:
Java Source  |  1997-02-04  |  15.9 KB  |  421 lines
  1. /*
  2.     A basic extension of the java.applet.Applet class
  3.  */
  4.  
  5. import java.awt.*;
  6. import java.applet.*;
  7.  
  8. public class Reserve extends Applet {
  9.     void NumberInParty_LostFocus(Event event) {
  10.  
  11.  
  12.         //{{CONNECTION
  13.         // Set the text for TextField...
  14.         Total_Cost.setText(String.valueOf(Float.valueOf(Price_Per_Person.getText()).floatValue() * Float.valueOf(Number_in_Party.getText()).floatValue()));
  15.         //}}
  16.     }
  17.  
  18.     void DBARegistrationSaveMultiView_Clicked(Event event) {
  19.  
  20.  
  21.         //{{CONNECTION
  22.         try {
  23.             DBA_registration.saveMultiView();
  24.         } catch (symjava.sql.SQLException e) {
  25.             System.out.println(e.getMessage());
  26.         }
  27.         //}}
  28.  
  29.         //{{CONNECTION
  30.         // getNewRecord
  31.         try {
  32.             DBA_registration.getNewRecord();
  33.         } catch (symjava.sql.SQLException e) {
  34.             System.out.println(e.getMessage());
  35.         }
  36.         //}}
  37.  
  38.         //{{CONNECTION
  39.         // Set the text for TextField... Get the contents of the TextField
  40.         Package_ID2.setText(Package_ID.getText());
  41.         //}}
  42.     }
  43.  
  44.     void DBARegistrationUndoRecord_Clicked(Event event) {
  45.  
  46.  
  47.         //{{CONNECTION
  48.         try {
  49.             DBA_registration.undoRecord();
  50.         } catch (symjava.sql.SQLException e) {
  51.             System.out.println(e.getMessage());
  52.         }
  53.         //}}
  54.  
  55.         //{{CONNECTION
  56.         // Set the text for TextField... Get the contents of the TextField
  57.         Package_ID2.setText(Package_ID.getText());
  58.         //}}
  59.     }
  60.  
  61.     void DBARegistrationGetNewRecord_Clicked(Event event) {
  62.  
  63.  
  64.         //{{CONNECTION
  65.         try {
  66.             DBA_registration.getNewRecord();
  67.         } catch (symjava.sql.SQLException e) {
  68.             System.out.println(e.getMessage());
  69.         }
  70.         //}}
  71.  
  72.         //{{CONNECTION
  73.         // Set the text for TextField... Get the contents of the TextField
  74.         Package_ID2.setText(Package_ID.getText());
  75.         //}}
  76.     }
  77.  
  78.     void DBAPackagesSaveMultiView_Clicked(Event event) {
  79.  
  80.  
  81.         //{{CONNECTION
  82.         try {
  83.             DBA_packages.saveMultiView();
  84.         } catch (symjava.sql.SQLException e) {
  85.             System.out.println(e.getMessage());
  86.         }
  87.         //}}
  88.     }
  89.  
  90.     void DBAPackagesPrev_Clicked(Event event) {
  91.  
  92.  
  93.         //{{CONNECTION
  94.         try {
  95.             DBA_packages.prev();
  96.         } catch (symjava.sql.SQLException e) {
  97.             System.out.println(e.getMessage());
  98.         }
  99.         //}}
  100.  
  101.         //{{CONNECTION
  102.         // Set the text for TextField... Get the contents of the TextField
  103.         Package_ID2.setText(Package_ID.getText());
  104.         //}}
  105.  
  106.         //{{CONNECTION
  107.         // Set the text for TextField...
  108.         Total_Cost.setText(String.valueOf(Float.valueOf(Price_Per_Person.getText()).floatValue() * Float.valueOf(Number_in_Party.getText()).floatValue()));
  109.         //}}
  110.     }
  111.  
  112.     void DBAPackagesNext_Clicked(Event event) {
  113.  
  114.  
  115.         //{{CONNECTION
  116.         try {
  117.             DBA_packages.next();
  118.         } catch (symjava.sql.SQLException e) {
  119.             System.out.println(e.getMessage());
  120.         }
  121.         //}}
  122.  
  123.         //{{CONNECTION
  124.         // Set the text for TextField... Get the contents of the TextField
  125.         Package_ID2.setText(Package_ID.getText());
  126.         //}}
  127.  
  128.         //{{CONNECTION
  129.         // Set the text for TextField...
  130.         Total_Cost.setText(String.valueOf(Float.valueOf(Price_Per_Person.getText()).floatValue() * Float.valueOf(Number_in_Party.getText()).floatValue()));
  131.         //}}
  132.     }
  133.  
  134.  
  135.     public void init() {
  136.         super.init();
  137.  
  138.         // Take out this line if you don't use symantec.itools.net.RelativeURL
  139.         symantec.itools.lang.Context.setDocumentBase(getDocumentBase());
  140.  
  141.         //{{INIT_CONTROLS
  142.         setLayout(new CardLayout(0,0));
  143.         addNotify();
  144.         resize(713,533);
  145.         setFont(new Font("Dialog", Font.BOLD, 12));
  146.         setForeground(new Color(0));
  147.         setBackground(new Color(16777215));
  148.         try {
  149.            localhost = new symantec.itools.db.pro.Session("dbaw://localhost:8889");
  150.            localhostLogonFrame = new symantec.itools.db.awt.LogonFrame();
  151.            localhost.setLogonObject(localhostLogonFrame);
  152.         } catch (symjava.sql.SQLException e) {
  153.             System.out.println(e.getMessage());
  154.             return;
  155.         }
  156.         Tutorial = new symantec.itools.db.pro.ConnectionInfo("Tutorial");
  157.         Tutorial.setUser("dba");
  158.         Tutorial.setPassword("sql");
  159.         Tutorial.setAutoDisconnect(false);
  160.         try {
  161.             symantec.itools.db.pro.Request DBA_packagesRequest = new symantec.itools.db.pro.Request(localhost,Tutorial);
  162.             DBA_packagesRequest.setSQL("SELECT Package_ID,Package_Name,Start_Date,Number_of_Days,Price_Per_Person,Image,Description FROM DBA.packages");
  163.             DBA_packagesRequest.setOptimisticConcurrency("All");
  164.             DBA_packagesRequest.setInitialRecordPosition("First");
  165.             DBA_packages = new symantec.itools.db.pro.RelationView(DBA_packagesRequest);
  166.             DBA_packages.setName("DBA_packages");
  167.         } catch (symjava.sql.SQLException e) {
  168.             System.out.println(e.getMessage());
  169.             return;
  170.         }
  171.         try {
  172.             symantec.itools.db.pro.Request DBA_registrationRequest = new symantec.itools.db.pro.Request(localhost,Tutorial);
  173.             DBA_registrationRequest.setSQL("SELECT Package_ID,Customer_First_Name,Customer_Last_Name,Customer_Email,Customer_Phone,Number_in_Party,Total_Cost FROM DBA.registration");
  174.             DBA_registrationRequest.setOptimisticConcurrency("All");
  175.             DBA_registrationRequest.setInitialRecordPosition("New");
  176.             DBA_registration = new symantec.itools.db.pro.RelationView(DBA_registrationRequest);
  177.             DBA_registration.setName("DBA_registration");
  178.         } catch (symjava.sql.SQLException e) {
  179.             System.out.println(e.getMessage());
  180.             return;
  181.         }
  182.         keyPressManagerPanel1 = new symantec.itools.awt.KeyPressManagerPanel();
  183.         keyPressManagerPanel1.setLayout(null);
  184.         keyPressManagerPanel1.reshape(0,0,713,533);
  185.         add(keyPressManagerPanel1);
  186.         DBA_packages_prev = new java.awt.Button("Previous");
  187.         DBA_packages_prev.reshape(192,325,65,20);
  188.         keyPressManagerPanel1.add(DBA_packages_prev);
  189.         DBA_packages_next = new java.awt.Button("Next");
  190.         DBA_packages_next.reshape(264,325,65,20);
  191.         keyPressManagerPanel1.add(DBA_packages_next);
  192.         Image = new symantec.itools.db.awt.ImageViewer();
  193.         Image.setBinding(DBA_packages,"Image");
  194.         Image.reshape(5,88,336,228);
  195.         keyPressManagerPanel1.add(Image);
  196.         Package_Name = new symantec.itools.db.awt.TextField();
  197.         Package_Name.setBinding(DBA_packages,"Package_Name");
  198.         Package_Name.setDynamicUpdate(false);
  199.         Package_Name.setTreatBlankAs("Default");
  200.         Package_Name.setEditable(false);
  201.         Package_Name.reshape(125,64,204,20);
  202.         Package_Name.setBackground(new Color(8421504));
  203.         keyPressManagerPanel1.add(Package_Name);
  204.         Package_NameLabel = new java.awt.Label("Package Name");
  205.         Package_NameLabel.reshape(5,64,108,20);
  206.         keyPressManagerPanel1.add(Package_NameLabel);
  207.         Description = new symantec.itools.db.awt.TextArea();
  208.         Description.setBinding(DBA_packages,"Description");
  209.         Description.setDynamicUpdate(false);
  210.         Description.setTreatBlankAs("Default");
  211.         Description.setEditable(false);
  212.         Description.reshape(365,184,276,120);
  213.         Description.setBackground(new Color(8421504));
  214.         keyPressManagerPanel1.add(Description);
  215.         Price_Per_Person = new symantec.itools.db.awt.TextField();
  216.         Price_Per_Person.setBinding(DBA_packages,"Price_Per_Person");
  217.         Price_Per_Person.setDynamicUpdate(false);
  218.         Price_Per_Person.setTreatBlankAs("Default");
  219.         Price_Per_Person.setEditable(false);
  220.         Price_Per_Person.reshape(473,136,80,20);
  221.         Price_Per_Person.setBackground(new Color(8421504));
  222.         keyPressManagerPanel1.add(Price_Per_Person);
  223.         Price_Per_PersonLabel = new java.awt.Label("Price Per Person");
  224.         Price_Per_PersonLabel.reshape(353,136,120,20);
  225.         keyPressManagerPanel1.add(Price_Per_PersonLabel);
  226.         Number_of_Days = new symantec.itools.db.awt.TextField();
  227.         Number_of_Days.setBinding(DBA_packages,"Number_of_Days");
  228.         Number_of_Days.setDynamicUpdate(false);
  229.         Number_of_Days.setTreatBlankAs("Default");
  230.         Number_of_Days.setEditable(false);
  231.         Number_of_Days.reshape(473,112,80,20);
  232.         Number_of_Days.setBackground(new Color(8421504));
  233.         keyPressManagerPanel1.add(Number_of_Days);
  234.         Number_of_DaysLabel = new java.awt.Label("Number of Days");
  235.         Number_of_DaysLabel.reshape(353,112,108,20);
  236.         keyPressManagerPanel1.add(Number_of_DaysLabel);
  237.         Start_Date = new symantec.itools.db.awt.TextField();
  238.         Start_Date.setBinding(DBA_packages,"Start_Date");
  239.         Start_Date.setDynamicUpdate(false);
  240.         Start_Date.setTreatBlankAs("Default");
  241.         Start_Date.setEditable(false);
  242.         Start_Date.reshape(473,88,80,20);
  243.         Start_Date.setBackground(new Color(8421504));
  244.         keyPressManagerPanel1.add(Start_Date);
  245.         Start_DateLabel = new java.awt.Label("Start Date");
  246.         Start_DateLabel.reshape(353,88,96,20);
  247.         keyPressManagerPanel1.add(Start_DateLabel);
  248.         Package_ID = new symantec.itools.db.awt.TextField();
  249.         Package_ID.setBinding(DBA_packages,"Package_ID");
  250.         Package_ID.setDynamicUpdate(false);
  251.         Package_ID.setTreatBlankAs("Default");
  252.         Package_ID.setEditable(false);
  253.         Package_ID.reshape(473,64,80,20);
  254.         Package_ID.setBackground(new Color(8421504));
  255.         keyPressManagerPanel1.add(Package_ID);
  256.         DescriptionLabel = new java.awt.Label("Description");
  257.         DescriptionLabel.reshape(353,160,108,20);
  258.         keyPressManagerPanel1.add(DescriptionLabel);
  259.         Package_IDLabel = new java.awt.Label("Package ID");
  260.         Package_IDLabel.reshape(353,64,108,20);
  261.         keyPressManagerPanel1.add(Package_IDLabel);
  262.         imageViewerPackage = new symantec.itools.multimedia.ImageViewer();
  263.         imageViewerPackage.reshape(4,10,523,42);
  264.         keyPressManagerPanel1.add(imageViewerPackage);
  265.         imageViewerPackage.setCenterMode(false);
  266.         try {
  267.             imageViewerPackage.setURL(symantec.itools.net.RelativeURL.getURL("Images/reserv.gif"));
  268.         } catch (java.net.MalformedURLException error) {
  269.         }
  270.         Package_IDLabel2 = new java.awt.Label("Package ID");
  271.         Package_IDLabel2.reshape(5,397,98,20);
  272.         keyPressManagerPanel1.add(Package_IDLabel2);
  273.         Customer_Last_NameLabel = new java.awt.Label("Last Name");
  274.         Customer_Last_NameLabel.reshape(5,445,98,20);
  275.         keyPressManagerPanel1.add(Customer_Last_NameLabel);
  276.         Customer_EmailLabel = new java.awt.Label("E-mail");
  277.         Customer_EmailLabel.reshape(5,469,98,20);
  278.         keyPressManagerPanel1.add(Customer_EmailLabel);
  279.         Package_ID2 = new symantec.itools.db.awt.TextField();
  280.         Package_ID2.setBinding(DBA_registration,"Package_ID");
  281.         Package_ID2.setDynamicUpdate(false);
  282.         Package_ID2.setTreatBlankAs("Default");
  283.         Package_ID2.setEditable(false);
  284.         Package_ID2.setText("780");
  285.         Package_ID2.reshape(113,397,80,20);
  286.         Package_ID2.setBackground(new Color(8421504));
  287.         keyPressManagerPanel1.add(Package_ID2);
  288.         Customer_First_Name = new symantec.itools.db.awt.TextField();
  289.         Customer_First_Name.setBinding(DBA_registration,"Customer_First_Name");
  290.         Customer_First_Name.setDynamicUpdate(false);
  291.         Customer_First_Name.setTreatBlankAs("Default");
  292.         Customer_First_Name.reshape(113,421,320,20);
  293.         keyPressManagerPanel1.add(Customer_First_Name);
  294.         Customer_Last_Name = new symantec.itools.db.awt.TextField();
  295.         Customer_Last_Name.setBinding(DBA_registration,"Customer_Last_Name");
  296.         Customer_Last_Name.setDynamicUpdate(false);
  297.         Customer_Last_Name.setTreatBlankAs("Default");
  298.         Customer_Last_Name.reshape(113,445,320,20);
  299.         keyPressManagerPanel1.add(Customer_Last_Name);
  300.         Customer_Email = new symantec.itools.db.awt.TextField();
  301.         Customer_Email.setBinding(DBA_registration,"Customer_Email");
  302.         Customer_Email.setDynamicUpdate(false);
  303.         Customer_Email.setTreatBlankAs("Default");
  304.         Customer_Email.reshape(113,469,320,20);
  305.         keyPressManagerPanel1.add(Customer_Email);
  306.         Customer_First_NameLabel = new java.awt.Label("First Name");
  307.         Customer_First_NameLabel.reshape(5,421,98,20);
  308.         keyPressManagerPanel1.add(Customer_First_NameLabel);
  309.         Customer_PhoneLabel = new java.awt.Label("Phone");
  310.         Customer_PhoneLabel.reshape(437,397,98,20);
  311.         keyPressManagerPanel1.add(Customer_PhoneLabel);
  312.         Number_in_PartyLabel = new java.awt.Label("Number in Party");
  313.         Number_in_PartyLabel.reshape(437,421,105,20);
  314.         keyPressManagerPanel1.add(Number_in_PartyLabel);
  315.         Total_CostLabel = new java.awt.Label("Total Cost");
  316.         Total_CostLabel.reshape(437,445,98,20);
  317.         keyPressManagerPanel1.add(Total_CostLabel);
  318.         Customer_Phone = new symantec.itools.db.awt.TextField();
  319.         Customer_Phone.setBinding(DBA_registration,"Customer_Phone");
  320.         Customer_Phone.setDynamicUpdate(false);
  321.         Customer_Phone.setTreatBlankAs("Default");
  322.         Customer_Phone.reshape(545,397,120,20);
  323.         keyPressManagerPanel1.add(Customer_Phone);
  324.         Number_in_Party = new symantec.itools.db.awt.TextField();
  325.         Number_in_Party.setBinding(DBA_registration,"Number_in_Party");
  326.         Number_in_Party.setDynamicUpdate(false);
  327.         Number_in_Party.setTreatBlankAs("Default");
  328.         Number_in_Party.reshape(545,421,80,20);
  329.         keyPressManagerPanel1.add(Number_in_Party);
  330.         Total_Cost = new symantec.itools.db.awt.TextField();
  331.         Total_Cost.setBinding(DBA_registration,"Total_Cost");
  332.         Total_Cost.setDynamicUpdate(false);
  333.         Total_Cost.setTreatBlankAs("Default");
  334.         Total_Cost.setEditable(false);
  335.         Total_Cost.reshape(545,445,160,20);
  336.         Total_Cost.setBackground(new Color(8421504));
  337.         keyPressManagerPanel1.add(Total_Cost);
  338.         DBA_registration_saveMultiView = new java.awt.Button("Send Registration");
  339.         DBA_registration_saveMultiView.reshape(311,505,120,20);
  340.         keyPressManagerPanel1.add(DBA_registration_saveMultiView);
  341.         DBA_registration_undoRecord = new java.awt.Button("Clear");
  342.         DBA_registration_undoRecord.reshape(235,505,65,20);
  343.         keyPressManagerPanel1.add(DBA_registration_undoRecord);
  344.         imageViewerReg = new symantec.itools.multimedia.ImageViewer();
  345.         imageViewerReg.reshape(4,357,536,32);
  346.         keyPressManagerPanel1.add(imageViewerReg);
  347.         imageViewerReg.setCenterMode(false);
  348.         try {
  349.             imageViewerReg.setURL(new java.net.URL("file:/C:/VisualCafePro/MyApps/AppletDb/Images/register.gif"));
  350.         } catch (java.net.MalformedURLException error) {
  351.         }
  352.         //}}
  353.     }
  354.  
  355.     public boolean handleEvent(Event event) {
  356.         if (event.target == DBA_packages_next && event.id == Event.ACTION_EVENT) {
  357.             DBAPackagesNext_Clicked(event);
  358.             return true;
  359.         }
  360.         if (event.target == DBA_packages_prev && event.id == Event.ACTION_EVENT) {
  361.             DBAPackagesPrev_Clicked(event);
  362.             return true;
  363.         }
  364.         if (event.target == DBA_registration_undoRecord && event.id == Event.ACTION_EVENT) {
  365.             DBARegistrationUndoRecord_Clicked(event);
  366.             return true;
  367.         }
  368.         if (event.target == DBA_registration_saveMultiView && event.id == Event.ACTION_EVENT) {
  369.             DBARegistrationSaveMultiView_Clicked(event);
  370.             return true;
  371.         }
  372.         if (event.target == Number_in_Party && event.id == Event.LOST_FOCUS) {
  373.             NumberInParty_LostFocus(event);
  374.             return true;
  375.         }
  376.         return super.handleEvent(event);
  377.     }
  378.  
  379.     //{{DECLARE_CONTROLS
  380.     symantec.itools.db.pro.Session localhost;
  381.     symantec.itools.db.awt.LogonFrame localhostLogonFrame;
  382.     symantec.itools.db.pro.ConnectionInfo Tutorial;
  383.     symantec.itools.db.pro.RelationView DBA_packages;
  384.     symantec.itools.db.pro.RelationView DBA_registration;
  385.     symantec.itools.awt.KeyPressManagerPanel keyPressManagerPanel1;
  386.     java.awt.Button DBA_packages_prev;
  387.     java.awt.Button DBA_packages_next;
  388.     symantec.itools.db.awt.ImageViewer Image;
  389.     symantec.itools.db.awt.TextField Package_Name;
  390.     java.awt.Label Package_NameLabel;
  391.     symantec.itools.db.awt.TextArea Description;
  392.     symantec.itools.db.awt.TextField Price_Per_Person;
  393.     java.awt.Label Price_Per_PersonLabel;
  394.     symantec.itools.db.awt.TextField Number_of_Days;
  395.     java.awt.Label Number_of_DaysLabel;
  396.     symantec.itools.db.awt.TextField Start_Date;
  397.     java.awt.Label Start_DateLabel;
  398.     symantec.itools.db.awt.TextField Package_ID;
  399.     java.awt.Label DescriptionLabel;
  400.     java.awt.Label Package_IDLabel;
  401.     symantec.itools.multimedia.ImageViewer imageViewerPackage;
  402.     java.awt.Label Package_IDLabel2;
  403.     java.awt.Label Customer_Last_NameLabel;
  404.     java.awt.Label Customer_EmailLabel;
  405.     symantec.itools.db.awt.TextField Package_ID2;
  406.     symantec.itools.db.awt.TextField Customer_First_Name;
  407.     symantec.itools.db.awt.TextField Customer_Last_Name;
  408.     symantec.itools.db.awt.TextField Customer_Email;
  409.     java.awt.Label Customer_First_NameLabel;
  410.     java.awt.Label Customer_PhoneLabel;
  411.     java.awt.Label Number_in_PartyLabel;
  412.     java.awt.Label Total_CostLabel;
  413.     symantec.itools.db.awt.TextField Customer_Phone;
  414.     symantec.itools.db.awt.TextField Number_in_Party;
  415.     symantec.itools.db.awt.TextField Total_Cost;
  416.     java.awt.Button DBA_registration_saveMultiView;
  417.     java.awt.Button DBA_registration_undoRecord;
  418.     symantec.itools.multimedia.ImageViewer imageViewerReg;
  419.     //}}
  420. }
  421.