コード例 #1
0
  private static void SaveUnity(JPanel PanelComponent, AdmUnity admUnity, AdmNewUnity admNewUnity) {
    String id, satuan;
    id = UnityLog.getId();
    satuan = UnityLog.getSatuan();

    String message, sql;
    sql = "INSERT INTO " + "unity_id(id, satuan) " + "VALUES('" + id + "', '" + satuan + "')";

    Integer operation;
    operation = SQLAdapter.dataOperation(1, sql);

    if (operation == 1) {
      message = "Data berhasil disimpan.";
      Pesan.Information(message);

      admNewUnity.setVisible(false);
      CloseFrame(PanelComponent, admUnity);
    }
  }
コード例 #2
0
  private static void CheckID(JPanel PanelComponent, AdmUnity admUnity, AdmNewUnity admNewUnity) {
    String id;
    id = UnityLog.getId();

    String message, sql;
    sql = "SELECT id AS `ID` FROM unity_id WHERE id = '" + id + "';";

    resultSet = SQLAdapter.getData(sql);

    try {
      if (resultSet.next()) {
        message = "Mohon gunakan id lain !";
        Pesan.Warning(message);
      } else {
        SaveUnity(PanelComponent, admUnity, admNewUnity);
      }
    } catch (SQLException ex) {
      ex.printStackTrace();
    }
  }
コード例 #3
0
  private static void CheckID(String idUpdate, JPanel PanelComponent, RootPeoples rootPeoples) {
    String message, sql;
    sql =
        "SELECT person_id.id AS `ID` "
            + "FROM person_id "
            + "WHERE person_id.id = '"
            + idUpdate
            + "';";

    resultSet = SQLAdapter.getData(sql);

    try {
      if (resultSet.next()) {
        message = "Mohon gunakan id lain !";
        Pesan.Warning(message);
      } else {
        UpdatePersonID(idUpdate, PanelComponent, rootPeoples);
      }
    } catch (SQLException ex) {
      ex.printStackTrace();
    }
  }
コード例 #4
0
  public static void GettingInformation(
      JLabel labelCompanyID,
      JLabel labelCompanyName,
      JLabel labelCompanyPhone,
      JLabel labelCompanyDirectedBy,
      JLabel labelCompanyCity,
      JLabel labelCompanyAddress,
      link linkCompanyEmployersCount) {
    String rootID, sql;
    rootID = UserLog.getId();
    sql =
        "SELECT office_id.id AS `Office ID`, office_id.nama AS `Office Name`, office_id.kontak AS `Office Phone`, "
            + "person_id.nama AS `Directed by`, person_id.kelamin AS `Kelamin`, "
            + "office_id.kota AS `Office City`, office_id.alamat AS `Office Address`, "
            + "(SELECT COUNT(office_peoples.id_person) AS `Count Peoples`"
            + " "
            + "FROM office_id, office_peoples, person_id"
            + " "
            + "WHERE "
            + " "
            + "office_peoples.id_office = office_id.id AND"
            + " "
            + "person_id.id = office_peoples.id_person"
            + ") AS `Employers Count` "
            + "FROM office_id, office_peoples, person_id "
            + "WHERE office_peoples.id_office = office_id.id AND "
            + "person_id.id = office_peoples.id_person AND "
            + "office_id.id_person = '"
            + rootID
            + "';";

    resultSet = SQLAdapter.getData(sql);

    try {
      if (resultSet.next()) {
        String id, nama, kontak, pemilik, preparedPemilik, kelamin, kota, alamat;
        id = resultSet.getString("Office ID");
        nama = resultSet.getString("Office Name");
        kontak = resultSet.getString("Office Phone");

        preparedPemilik = resultSet.getString("Directed by");
        kelamin = resultSet.getString("Kelamin");
        if (kelamin.equals("Laki-laki") == true) {
          pemilik = "Tn." + " " + preparedPemilik;
        } else {
          pemilik = "Ny." + " " + preparedPemilik;
        }

        kota = resultSet.getString("Office City");
        alamat = resultSet.getString("Office Address");

        Integer count;
        count = resultSet.getInt("Employers Count");

        labelCompanyID.setText(id);
        labelCompanyName.setText(nama);
        labelCompanyPhone.setText(kontak);
        labelCompanyDirectedBy.setText(pemilik);
        labelCompanyCity.setText(kota);
        labelCompanyAddress.setText(alamat);

        String message;
        if (count == 0) {
          message = "No employer !";
        } else {
          if (count == 1) {
            message = count.toString() + " " + "Employer";
          } else {
            message = count.toString() + " " + "Employers";
          }
        }
        linkCompanyEmployersCount.setText(message);

        SetInformation(id, nama, kontak, pemilik, kota, alamat);
      }
    } catch (SQLException ex) {
      ex.printStackTrace();
    }
  }
コード例 #5
0
  private static void UpdatePersonID(
      String idUpdate, JPanel PanelComponent, RootPeoples rootPeoples) {
    String idDefault;
    idDefault = PeoplesLog.getId();

    String nama, kelamin, kota, tglLahir, dLahir, kontak, alamat;
    nama = PeoplesLog.getNama();
    kelamin = PeoplesLog.getKelamin();
    kota = PeoplesLog.getKota();
    tglLahir = PeoplesLog.getTglLahir();
    dLahir = PeoplesLog.getdLahir();
    kontak = PeoplesLog.getKontak();
    alamat = PeoplesLog.getAlamat();

    String message, sql;
    if (idUpdate.equals(idDefault) == true) {
      sql =
          "UPDATE person_id "
              + "SET "
              + "nama = '"
              + nama
              + "', kelamin = '"
              + kelamin
              + "', kota = '"
              + kota
              + "', "
              + "tgl_lahir = '"
              + tglLahir
              + "', d_lahir = '"
              + dLahir
              + "', "
              + "kontak = '"
              + kontak
              + "', alamat = '"
              + alamat
              + "' "
              + "WHERE id = '"
              + idDefault
              + "';";
    } else {
      sql =
          "UPDATE person_id "
              + "SET "
              + "id = '"
              + idUpdate
              + "', "
              + "nama = '"
              + nama
              + "', kelamin = '"
              + kelamin
              + "', kota = '"
              + kota
              + "', "
              + "tgl_lahir = '"
              + tglLahir
              + "', d_lahir = '"
              + dLahir
              + "', "
              + "kontak = '"
              + kontak
              + "', alamat = '"
              + alamat
              + "' "
              + "WHERE id = '"
              + idDefault
              + "';";
    }

    Integer operation;
    operation = SQLAdapter.dataOperation(1, sql);

    if (operation == 1) {
      message = "Terima kasih telah memperbaharui data.";
      Pesan.Information(message);

      ReturnFrame(PanelComponent, rootPeoples);
    }
  }