home *** CD-ROM | disk | FTP | other *** search
/ Symantec Visual Cafe for Java 2.5 / symantec-visual-cafe-2.5-database-dev-edition.iso / DBServ / SAMPLES / SAMPLES.ZIP / EXPENSES / EMPLOYEEENTRY.JAVA < prev    next >
Encoding:
Java Source  |  1997-02-21  |  14.3 KB  |  356 lines
  1. /**************************************************************************************************
  2. *                                                                                                 *
  3. *  Class name:   employeeEntry                                                                    *
  4. *                                                                                                 *
  5. *     Purpose:   Extends Panel to allow users to add new employees to the database.               *
  6. *                                                                                                 *
  7. *     Imports:  java.awt.*                                                                        *
  8. *               java.applet.*                                                                     *
  9. *               symjava.sql.*                                                                     *
  10. *               java.net.*                                                                        *
  11. *               java.lang.*                                                                       *
  12. *               java.util.*                                                                       *
  13. *                                                                                                 *
  14. *  Methods include:  public boolean handleEvent(Event event)                                      *
  15. *                    public employeeEntry(Applet parent)                                          *
  16. *                    public String checkFields()                                                  *
  17. *                    public synchronized void show()                                              *
  18. *                    public void clickedclearbutton()                                             *
  19. *                    public void clickedMainMenubutton()                                          *
  20. *                    public void clickedSavebutton()                                              *
  21. *                    public void getMessageBox(String msg)                                        *
  22. *                                                                                                 *
  23. * Additional Notes:                                                                               *
  24. * THIS SOFTWARE HAS BEEN COMPILED AND EXECUTED SUCCESSFULLY IN SPECIFIC SYMANTEC                  *
  25. * ENVIRONMENTS, AND IS BEING PROVIDED ONLY AS SAMPLE CODE.                                        *
  26. *                                                                                                 *
  27. * SYMANTEC MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY OF THE SOFTWARE,          *
  28. * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF               *
  29. * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT.  SYMANTEC SHALL NOT     *
  30. * BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING, MODIFYING, OR DISTRIBUTING *
  31. * THIS SOFTWARE OR ITS DERIVATIVES.                                                               *
  32. *                                                                                                 *
  33. *  Please see the Sample Code Configuration item in the Read Me file for additional               *
  34. *  information about the sample database used in this applet.                                     *
  35. *                                                                                                 *
  36. * Copyright (c) 1996 Symantec.  All Rights Reserved.                                              *
  37. *                                                                                                 *
  38. **************************************************************************************************/
  39.  
  40. import java.applet.*;
  41. import java.net.*;
  42. import java.awt.*;
  43. import symjava.sql.*;
  44. import java.lang.*;
  45. import java.util.*;
  46.  
  47. public class employeeEntry extends Panel {
  48.  
  49.     expenseApplet exp;
  50.     public employeeEntry(Applet parent) {
  51.  
  52.  
  53.         exp = (expenseApplet)parent;
  54.  
  55.         //{{INIT_CONTROLS
  56.         setLayout(null);
  57.  
  58.         insets().left -= 60;
  59.         resize(insets().left + insets().right + 770, insets().top + insets().bottom + 390);
  60.  
  61.  
  62.         firstname=new TextField(22);
  63.         add(firstname);
  64.         firstname.reshape(insets().left + 134,insets().top + 54,190,25);
  65.  
  66.         label2=new Label("First Name");
  67.         add(label2);
  68.         label2.reshape(insets().left + 8,insets().top + 51,80,15);
  69.  
  70.         label3=new Label("Last Name");
  71.         add(label3);
  72.         label3.reshape(insets().left + 8,insets().top + 94,80,15);
  73.  
  74.         lastname=new TextField(22);
  75.         add(lastname);
  76.         lastname.reshape(insets().left + 134,insets().top + 88,190,25);
  77.  
  78.         label4=new Label("Address");
  79.         add(label4);
  80.         label4.reshape(insets().left + 8,insets().top + 128,80,15);
  81.  
  82.         address=new TextField(31);
  83.         add(address);
  84.         address.reshape(insets().left + 134,insets().top + 126,190,25);
  85.  
  86.         city=new TextField(22);
  87.         add(city);
  88.         city.reshape(insets().left + 134,insets().top + 163,190,25);
  89.  
  90.         label5=new Label("City");
  91.         add(label5);
  92.         label5.reshape(insets().left + 8,insets().top + 167,80,15);
  93.  
  94.         label6=new Label("State");
  95.         add(label6);
  96.         label6.reshape(insets().left + 8,insets().top + 203,100,15);
  97.  
  98.         state=new TextField(9);
  99.         add(state);
  100.         state.reshape(insets().left + 134,insets().top + 203,190,25);
  101.  
  102.         label7=new Label("Postal Code");
  103.         add(label7);
  104.         label7.reshape(insets().left + 8,insets().top + 242,80,15);
  105.  
  106.         postalcode=new TextField(9);
  107.         add(postalcode);
  108.         postalcode.reshape(insets().left + 134,insets().top + 242,190,25);
  109.  
  110.         title=new TextField(21);
  111.         add(title);
  112.         title.reshape(insets().left + 470,insets().top + 51,190,25);
  113.  
  114.         label8=new Label("Title");
  115.         add(label8);
  116.         label8.reshape(insets().left + 352,insets().top + 54,70,15);
  117.  
  118.         label9=new Label("Employee #");
  119.         add(label9);
  120.         label9.reshape(insets().left + 352,insets().top + 94,100,15);
  121.  
  122.         employeenum=new TextField(14);
  123.         add(employeenum);
  124.         employeenum.reshape(insets().left + 470,insets().top + 88,190,25);
  125.  
  126.         label10=new Label("Social Security #");
  127.         add(label10);
  128.         label10.reshape(insets().left + 352,insets().top + 128,105,15);
  129.  
  130.         socialsecurity=new TextField(13);
  131.         add(socialsecurity);
  132.         socialsecurity.reshape(insets().left + 470,insets().top + 126,190,25);
  133.  
  134.         email=new TextField(20);
  135.         add(email);
  136.         email.reshape(insets().left + 470,insets().top + 163,190,25);
  137.  
  138.         label11=new Label("Email");
  139.         add(label11);
  140.         label11.reshape(insets().left + 352,insets().top + 167,80,15);
  141.  
  142.         label12=new Label("Dept Name");
  143.         add(label12);
  144.         label12.reshape(insets().left + 352,insets().top + 203,80,15);
  145.  
  146.         deptname=new TextField(20);
  147.         add(deptname);
  148.         deptname.reshape(insets().left + 470,insets().top + 203,190,25);
  149.  
  150.         label13=new Label("Home Phone");
  151.         add(label13);
  152.         label13.reshape(insets().left + 352,insets().top + 242,85,15);
  153.  
  154.         homephone=new TextField(13);
  155.         add(homephone);
  156.         homephone.reshape(insets().left + 470,insets().top + 242,190,25);
  157.  
  158.         label14=new Label("Country");
  159.         add(label14);
  160.         label14.reshape(insets().left + 8,insets().top + 278,80,15);
  161.  
  162.         country=new TextField(21);
  163.         add(country);
  164.         country.reshape(insets().left + 134,insets().top + 278,190,25);
  165.  
  166.         label15=new Label("Work Phone");
  167.         add(label15);
  168.         label15.reshape(insets().left + 352,insets().top + 278,80,15);
  169.  
  170.         workphone=new TextField(13);
  171.         add(workphone);
  172.         workphone.reshape(insets().left + 470,insets().top + 278,190,25);
  173.  
  174.         savebutton=new Button("Save");
  175.         add(savebutton);
  176.         savebutton.reshape(insets().left + 230,insets().top + 320,88,26);
  177.  
  178.         clearbutton=new Button("Clear");
  179.         add(clearbutton);
  180.         clearbutton.reshape(insets().left + 330,insets().top + 320,88,26);
  181.  
  182.         MainMenubutton=new Button("Main Menu");
  183.         add(MainMenubutton);
  184.         MainMenubutton.reshape(insets().left + 430,insets().top + 320,88,26);
  185.         //}}
  186.  
  187.  
  188.     }
  189.  
  190.     public synchronized void show() {
  191.         super.show();
  192.     }
  193.  
  194.     //{{DECLARE_CONTROLS
  195.     TextField firstname;
  196.     Label label2;
  197.     Label label3;
  198.     TextField lastname;
  199.     Label label4;
  200.     TextField address;
  201.     TextField city;
  202.     Label label5;
  203.     Label label6;
  204.     TextField state;
  205.     Label label7;
  206.     TextField postalcode;
  207.     TextField title;
  208.     Label label8;
  209.     Label label9;
  210.     TextField employeenum;
  211.     Label label10;
  212.     TextField socialsecurity;
  213.     TextField email;
  214.     Label label11;
  215.     Label label12;
  216.     TextField deptname;
  217.     Label label13;
  218.     TextField homephone;
  219.     Label label14;
  220.     TextField country;
  221.     Label label15;
  222.     TextField workphone;
  223.     Label titlelabel;
  224.     Button savebutton;
  225.     Button clearbutton;
  226.     Button MainMenubutton;
  227.     //}}
  228.  
  229.  
  230.  
  231.     public boolean handleEvent(Event event) {
  232.         if (event.id == Event.ACTION_EVENT && event.target == savebutton) {
  233.             clickedSavebutton();
  234.             return true;
  235.         }
  236.         else
  237.         if (event.id == Event.ACTION_EVENT && event.target == clearbutton) {
  238.             clickedclearbutton();
  239.             return true;
  240.         }
  241.         else
  242.         if (event.id == Event.ACTION_EVENT && event.target == MainMenubutton) {
  243.             clickedMainMenubutton();
  244.             return true;
  245.         }
  246.         return super.handleEvent(event);
  247.     }
  248.  
  249. /*
  250.     public void getMessageBox(String msg) {
  251.         MessageBox theMessageBox;
  252.         theMessageBox = new MessageBox(this, msg);
  253.         theMessageBox.show();
  254.     }
  255. */
  256.     public void clickedMainMenubutton() {
  257.        hide();
  258.     }
  259.     public void clickedSavebutton() {
  260.         Statement  s;
  261.         int rs = 0;
  262.  
  263.         String fName = "'" + firstname.getText() + "' ,";
  264.         String lName = "'" + lastname.getText() + "' ,";
  265.         String theAdd = "'" + address.getText() + "' ,";
  266.         String theCity = "'" + city.getText() + "' ,";
  267.         String theState = "'" + state.getText() + "' ,";
  268.         String theZip = "'" + postalcode.getText() + "' ,";
  269.         String theCountry = "'" + country.getText() + "' ,";
  270.         String theTitle = "'" + title.getText() + "' ,";
  271.         String theEmpnum = "'" + employeenum.getText() + "' ,";
  272.         String theSSnum = "'" + socialsecurity.getText() + "' ,";
  273.         String theEmail = "'" + email.getText() + "' ,";
  274.         String theDept = "'" + deptname.getText() + "' ,";
  275.         String theHome = "'" + homephone.getText() + "' ,";
  276.         String theWork = "'" + workphone.getText() + "' ";
  277.  
  278.         //String sqlStatement = "Insert into Employees (DepartmentName, SocialSecurityNumber, EmployeeNumber, FirstName, LastName, Title, EmailName, Address, City, StateOrProvince, PostalCode, Country, HomePhone, WorkPhone) values (" + theDept + theSSnum + theEmpnum + fName + lName + theTitle + theEmail + theAdd + theCity + theState + theZip + theCountry + theHome + theWork + ")";
  279.         String sqlStatement = "Insert into Employees (EmployeeID, DepartmentName, SocialSecurityNumber, EmployeeNumber, FirstName, LastName, Title, EmailName, Address, City, StateOrProvince, PostalCode, Country, HomePhone, WorkPhone) values (" + theSSnum + theDept + theSSnum + theEmpnum + fName + lName + theTitle + theEmail + theAdd + theCity + theState + theZip + theCountry + theHome + theWork + ")";
  280.  
  281.         /*****************   Insert Data to Employeess Table   *****************************************/
  282.         String errMessage = "";
  283.         errMessage = checkFields();
  284.  
  285.         if (errMessage.equals("") ){
  286.             try
  287.             {
  288.                 s = (Statement)exp.connection.createStatement();
  289.                 rs = s.executeUpdate(sqlStatement);
  290.                 s.close();
  291.              }
  292.  
  293.             catch (SQLException e)
  294.             {
  295.                 System.out.println(e.getMessage());
  296.                 return;
  297.             }
  298.         }
  299.         else {
  300.            // getMessageBox(errMessage);
  301.         }
  302.         /************************************************************************************************/
  303.     }
  304.  
  305. //****  clear all entry fields  ******
  306.     public void clickedclearbutton() {
  307.         firstname.setText(null);
  308.         lastname.setText(null);
  309.         address.setText(null);
  310.         city.setText(null);
  311.         state.setText(null);
  312.         postalcode.setText(null);
  313.         country.setText(null);
  314.         title.setText(null);
  315.         employeenum.setText(null);
  316.         socialsecurity.setText(null);
  317.         email.setText(null);
  318.         deptname.setText(null);
  319.         homephone.setText(null);
  320.         workphone.setText(null);
  321.     }
  322.  
  323. //****  check to see that all fields are entered before save  *****
  324.     public String checkFields() {
  325.         String errMessage = "";
  326.  
  327.         if (workphone.getText().equals(""))
  328.             errMessage =  "Please enter Work phone        ";
  329.         if (deptname.getText().equals(""))
  330.             errMessage =  "Please enter Dept Name          ";
  331.         if (socialsecurity.getText().equals(""))
  332.             errMessage =  "Please enter Social Security #  ";
  333.         if (employeenum.getText().equals(""))
  334.             errMessage =  "Please enter Employee #       ";
  335.         if (title.getText().equals(""))
  336.             errMessage =  "Please enter Title            ";
  337.         if (country.getText().equals(""))
  338.             errMessage =  "Please enter Country          ";
  339.         if (postalcode.getText().equals(""))
  340.             errMessage =  "Please enter Postal Code      ";
  341.         if (state.getText().equals(""))
  342.             errMessage =  "Please enter State            ";
  343.         if (city.getText().equals(""))
  344.             errMessage =  "Please enter City             ";
  345.         if (address.getText().equals(""))
  346.             errMessage =  "Please enter Address          ";
  347.         if (lastname.getText().equals(""))
  348.             errMessage =  "Please enter Last name        ";
  349.         if (firstname.getText().equals(""))
  350.             errMessage =  "Please enter First name       ";
  351.  
  352.         return errMessage;
  353.     }
  354. }
  355.  
  356.