public IntervenantPage() throws SQLException {
    initComponents();

    ConnectBDD();

    jTextField1.setText("-");
    jLabel4.setVisible(false);
    jComboBox3.setVisible(false);
    jLabel5.setVisible(false);
    jTextField1.setVisible(false);

    identifiantConnect = ConnectPage.getIdentifiant();

    IntervenantsDAO i1 = new IntervenantsDAO();
    i1.getConnection();
    ArrayList<Intervenants> mesLogin = i1.selectAll();

    for (Intervenants ii : mesLogin) {
      jComboBox1.addItem(ii.getLogin());
    }

    OrdinateurDAO o1 = new OrdinateurDAO();
    o1.getConnection();
    ArrayList<Ordinateur> mesordi = o1.selectAll();

    for (Ordinateur oo : mesordi) {
      jComboBox2.addItem(oo.getRefOrdinateur());
    }

    PanneDAO p1 = new PanneDAO();
    p1.getConnection();
    ArrayList<Panne> mesPanne = p1.selectAll();

    DefaultTableModel model = new DefaultTableModel();
    model.addColumn("Id Panne");
    model.addColumn("Date Panne");
    model.addColumn("Type Materiel");
    model.addColumn("Urgence Panne");
    model.addColumn("Peripherique Panne");
    model.addColumn("Ordinateur");
    model.addColumn("Descriptif");

    for (Panne pp : mesPanne) {
      model.addRow(
          new Object[] {
            pp.getIdPanne(),
            pp.getDatePanne(),
            pp.getTypeMaterielPanne(),
            pp.getUrgencePanne(),
            pp.getPeripheriquePanne(),
            pp.getIdOrdinateurPanne(),
            pp.getDescriptifPanne()
          });
    }

    jTable2.setModel(model);

    this.setIconImage(new ImageIcon(getClass().getResource("gsb-icon.png")).getImage());
  }
  private void jComboBox5ActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jComboBox5ActionPerformed

    int a = jComboBox3.getSelectedIndex();
    int b = jComboBox5.getSelectedIndex();

    if (b == 1) { // SI TYPE SELECTIONNEE EST HARDWARE

      jLabel4.setVisible(true);
      jComboBox3.setVisible(true);
      jLabel5.setVisible(true);
      jTextField1.setVisible(true);

      if (a == 1) {
        variable = "CarteMere";
      } else if (a == 2) {
        variable = "Processeur";
      } else if (a == 3) {
        variable = "MemoireVive";
      } else if (a == 4) {
        variable = "DisqueDur";
      } else if (a == 5) {
        variable = "CarteReseau";
      } else if (a == 6) {
        variable = "Lecteur";
      } else if (a == 7) {
        variable = "CarteGraphique";
      } else if (a == 8) {
        variable = "CarteSon";
      } else if (a == 9) {
        variable = "Alimentation";
      }

    } else {
      jLabel4.setVisible(false);
      jComboBox3.setVisible(false);
      jLabel5.setVisible(false);
      jTextField1.setVisible(false);
    }

    String panne;
    boolean compare;
    int idPanne;

    jComboBox4.removeAllItems();
    PanneDAO p2 = new PanneDAO();
    p2.getConnection();
    ArrayList<Panne> mesPanne2 = p2.selectAll();

    machine = jComboBox2.getSelectedItem().toString();

    for (Panne pp : mesPanne2) {
      panne = pp.getIdOrdinateurPanne();
      idPanne = pp.getIdPanne();

      selected = jComboBox5.getSelectedItem().toString();

      String typeMaterielPanne = pp.getTypeMaterielPanne();
      compare = panne.equals(machine);
      if (compare == true) {
        if (typeMaterielPanne.equals(selected)) {
          jComboBox4.addItem(idPanne);
        }
      }
    }
  } // GEN-LAST:event_jComboBox5ActionPerformed
  private void jButton3ActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed

    modification = jTextField1.getText();
    machine = jComboBox2.getSelectedItem().toString();
    intervenant = jComboBox1.getSelectedItem().toString();
    composant = jComboBox3.getSelectedItem().toString();
    info = jTextArea1.getText();

    try {
      formatDate = df.format(jDateChooser1.getDate());

      try {
        int a = jComboBox3.getSelectedIndex();
        int b = jComboBox5.getSelectedIndex();

        if (b == 1) { // SI TYPE SELECTIONNEE EST HARDWARE

          Ordinateur update = new Ordinateur(variable, modification, machine);
          OrdinateurDAO ordi = new OrdinateurDAO();
          ordi.getConnection();
          ordi.update(update);
        }
        int idPanneSelect;
        idPanneSelect = jComboBox4.getSelectedItem().hashCode();
        InterventionDAO iDAO = new InterventionDAO(); // DEBUT INSERT INTERVENTION
        Intervention insertInter =
            new Intervention(
                formatDate,
                machine,
                composant,
                idPanneSelect,
                modification,
                info,
                identifiantConnect);
        iDAO.getConnection();
        iDAO.insert(insertInter);

        int idPanne = jComboBox4.getSelectedItem().hashCode();

        Panne delete = new Panne(idPanne);
        PanneDAO ordinateurPanne = new PanneDAO();
        ordinateurPanne.getConnection();
        ordinateurPanne.delete(delete);

        jComboBox4.removeAllItems();

        PanneDAO p2 = new PanneDAO(); // ACTUALISE ID PANNE
        p2.getConnection();
        ArrayList<Panne> mesPanne2 = p2.selectAll();

        String panne;
        boolean compare;

        for (Panne pp : mesPanne2) {
          panne = pp.getIdOrdinateurPanne();
          idPanne = pp.getIdPanne();
          compare = panne.equals(machine);
          if (compare == true) {
            jComboBox4.addItem(idPanne);
          }
        }

      } catch (Exception e) {
        jTextArea1.setText("-");
        jTextField1.setText("-");
        JOptionPane.showMessageDialog(null, "Veuillez spécifier tous les champs ");
        e.printStackTrace();
      }

      jTextField1.setText("-");
      jTextArea1.setText("-");

      JOptionPane.showMessageDialog(null, "Votre panne a bien etais résolu");

    } catch (Exception e) {
      jTextArea1.setText("-");
      jTextField1.setText("-");
      JOptionPane.showMessageDialog(null, "Veuillez selectionner une date ");
      e.printStackTrace();
    }

    PanneDAO p1 = new PanneDAO(); // ACTUALISE HISTORIQUE PANNE
    p1.getConnection();
    ArrayList<Panne> mesPanne = p1.selectAll();

    DefaultTableModel model = new DefaultTableModel();
    model.addColumn("Id Panne");
    model.addColumn("Date Panne");
    model.addColumn("Type Materiel");
    model.addColumn("Urgence Panne");
    model.addColumn("Peripherique Panne");
    model.addColumn("Ordinateur");
    model.addColumn("Descriptif");

    for (Panne pp : mesPanne) {
      model.addRow(
          new Object[] {
            pp.getIdPanne(),
            pp.getDatePanne(),
            pp.getTypeMaterielPanne(),
            pp.getUrgencePanne(),
            pp.getPeripheriquePanne(),
            pp.getIdOrdinateurPanne(),
            pp.getDescriptifPanne()
          });
    }

    jTable2.setModel(model);
    jComboBox5.setSelectedIndex(0);

    machine = jComboBox2.getSelectedItem().toString();
    intervenant = jComboBox1.getSelectedItem().toString();
    composant = jComboBox3.getSelectedItem().toString();
    info = jTextArea1.getText();

    try {
      FileWriter fw = new FileWriter("log_intervenant.txt", true);
      BufferedWriter bw = new BufferedWriter(fw);
      bw.newLine();
      PrintWriter pw = new PrintWriter(bw);
      pw.print(
          "Modification: "
              + modification
              + "\n Machine: "
              + machine
              + "\n Intervenant: "
              + intervenant
              + "\n Composant: "
              + composant
              + "\n Info: "
              + info
              + "\n ----------------------- \n");
      pw.close();
    } catch (IOException e) {
      System.out.println(" Problème à l’écriture du fichier ");
      System.exit(0);
    }
  } // GEN-LAST:event_jButton3ActionPerformed