Esempio n. 1
0
  @Override
  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == btnSave) {
      if (tfFirstName.getText().isEmpty()) {
        JOptionPane.showMessageDialog(null, "Enter first name!");
        return;
      } else if (tfLastName.getText().isEmpty()) {
        JOptionPane.showMessageDialog(null, "Enter last name!");
        return;
      } else if (tfAddress.getText().isEmpty()) {
        JOptionPane.showMessageDialog(null, "Enter Address!");
        return;
      } else if (tfPhoneNumber.getText().isEmpty()) {
        JOptionPane.showMessageDialog(null, "Enter phone number!");
        return;
      } else if (dateModel.getValue().toString().isEmpty()) {
        JOptionPane.showMessageDialog(null, "Enter date of birth!");
        return;
      }
      DBConnection dbconnection = new DBConnection();

      if (person == null) {
        person = new Person();
      }

      person.setFirstName(tfFirstName.getText());
      person.setLastName(tfLastName.getText());
      person.setAddress(tfAddress.getText());
      person.setPhoneNumber(tfPhoneNumber.getText());
      person.setDOB(dateModel.getYear() + "-" + dateModel.getMonth() + "-" + dateModel.getDay());
      int result = -1;
      if (person.getId() == 0) {
        result = dbconnection.savePerson(person);
      } else {
        result = dbconnection.updatePerson(person);
      }

      if (result != -1) {
        JOptionPane.showMessageDialog(null, "Saved Successfully!");
      } else {
        JOptionPane.showMessageDialog(null, "Save Unsuccessful!");
      }
    } else if (e.getSource() == btnReset) {
      tfFirstName.setText("");
      tfLastName.setText("");
      tfAddress.setText("");
      tfPhoneNumber.setText("");
      tfDOB.setText("");
      dateModel.setValue(new Date());
    } else if (e.getSource() == btnDelete) {
      DBConnection dBConnection = new DBConnection();
      int result = dBConnection.deletePerson(person.getId());
      if (result != -1) {
        JOptionPane.showMessageDialog(null, "Deleted Successfully!");
      } else {
        JOptionPane.showMessageDialog(null, "Deletion Unsuccessful!");
      }
    }
  }
Esempio n. 2
0
  public void deletePerson(Person p) throws SQLException {
    conn = DBTool.getInstance();

    System.out.println("Deleting person person...");
    if (conn.isValid(10000)) {
      Statement s = conn.createStatement();
      int idperson = p.getId();

      s.execute("DELETE FROM guest WHERE idperson = " + idperson + ";");
      s.execute("DELETE FROM person WHERE idperson = " + idperson + ";");
      System.out.println("Deletion complete!");
      s.close();
      conn.close();
    } else {
      System.out.println("Connection not valid");
      conn.close();
    }
  }
Esempio n. 3
0
  public int saveGuest(Person p, Guest g) throws SQLException {
    conn = DBTool.getInstance();

    System.out.println("Saving guest...");
    if (conn.isValid(10000)) {
      Statement s = conn.createStatement();

      int idPerson = p.getId();

      String guestFirstname = g.getFirstname();
      String guestMiddlename = g.getMiddlename();
      String guestLastname = g.getLastname();
      String guestBirthday = ADate.formatADate(g.getBirthday(), "");
      String guestCreationdate = ADate.formatADate(g.getCreationDate(), "");

      s.execute(
          "INSERT INTO guest (firstname, middlename, lastname, creationdate, birthday, idperson) VALUES('"
              + guestFirstname
              + "', '"
              + guestMiddlename
              + "', '"
              + guestLastname
              + "', '"
              + guestCreationdate
              + "', '"
              + guestBirthday
              + "', '"
              + idPerson
              + "');");
      ResultSet rs = s.executeQuery("SELECT LAST_INSERT_ID();");
      rs.next();
      int returnId = rs.getInt(1);
      System.out.println("Save complete!");
      rs.close();
      s.close();
      conn.close();
      return returnId;
    } else {
      System.out.println("Connection not valid");
      conn.close();
      return -1;
    }
  }
Esempio n. 4
0
  public void updatePerson(Person person) {

    Person personDao = em.find(Person.class, person.getId());
    em.getTransaction().begin();

    System.out.println("--->" + person);

    personDao.setFirstname(person.getFirstname());
    personDao.setLastname(person.getLastname());
    personDao.setBirthdate(person.getBirthdate());
    personDao.setEmail(person.getEmail());
    personDao.setWebsite(person.getWebsite());

    if (person.getGroup() != null) {
      Group group = new Group();
      group.setGroupID(person.getGroup().getGroupID());
      group.setName(person.getGroup().getName());
      personDao.setGroup(group);
    }

    em.getTransaction().commit();
  }
Esempio n. 5
0
  public void savePerson(Person p) throws SQLException {
    conn = DBTool.getInstance();

    System.out.println("Saving person...");
    if (conn.isValid(10000)) {
      Statement s = conn.createStatement();

      int idperson = p.getId();
      String firstname = p.getFirstname();
      String middlename = p.getMiddlename();
      String lastname = p.getLastname();
      String address = p.getAddress();
      String birthday = ADate.formatADate(p.getBirthdayDate(), "");
      String expirationDate = ADate.formatADate(p.getExpirationDate(), "");
      File picturePathF = p.getPicturePath();
      String picturePath = FileTool.getDefaultFolder() + "/" + picturePathF.getName();
      int quarantine = 0;
      String quarantineExpirationDate = "";
      if (p.getQuarantineExpirationDate() != null) {
        quarantineExpirationDate = p.getQuarantineExpirationDate().toString();
      }
      int oneOne = 0;
      if (p.isQuarantine()) {
        quarantine = 1;
      }
      if (p.isOneOne()) {
        oneOne = 1;
      }
      int enrolled = 0;
      if (p.isEnrolled()) {
        enrolled = 1;
      }
      int hone = 0;
      if (p.isHone()) {
        hone = 1;
      }

      s.executeUpdate(
          "UPDATE person SET firstname = '"
              + firstname
              + "', middlename = '"
              + middlename
              + "', lastname = '"
              + lastname
              + "', address = '"
              + address
              + "', birthday = '"
              + birthday
              + "', expirationdate = '"
              + expirationDate
              + "', picturepath = '"
              + picturePath
              + "', oneone = "
              + oneOne
              + ", quarantine = "
              + quarantine
              + ", enrolled = "
              + enrolled
              + ", hone= "
              + hone
              + " WHERE idperson = "
              + idperson
              + ";");
      System.out.println("Save complete!");
      s.close();
      conn.close();
    } else {
      System.out.println("Connection not valid");
      conn.close();
    }
  }