1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126
| btnEnregistrer.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
if (tpsmachine.getText().length() != 0 && tpsmo.getText().length() != 0
&& tpschgt.getText().length() != 0 && duree.getText().length() != 0) {
tpsmachine.setText("" + getTimeWithStringValue(tpsmachine.getText()));
tpsmo.setText("" + getTimeWithStringValue(tpsmo.getText()));
tpschgt.setText("" + getTimeWithStringValue(tpschgt.getText()));
duree.setText("" + getTimeWithStringValue(duree.getText()));
} else {
JOptionPane.showMessageDialog(null, "Veuillez remplir les champs horaire");
return;
}
PreparedStatement ps = null;
try {
/**
* Permet de controle si tous les champs sont remplis
*/
if (jtextfieldAutoComplete.getText().trim().length() > 0 && textField_1.getText().trim().length()>0 && textField_2.getText().trim().length()>0 &&
automachine.getText().trim().length() >0 &&tpschgt.getText().trim().length() >0 &&
complet.getText().trim().length() >0 && quantite.getText().trim().length() >0 && nbarret.getText().trim().length() >0 &&
tpsmachine.getText().trim().length() >0 && tpsmo.getText().trim().length()>0 )
{
ps = Connexion_BDD.get().prepareStatement(
"insert into dbo.MODTESTTABLE ([Dates],[NomEtPrenom], [Matricule], [SectionSalarie], [NomRecouvrement], [MatriculeRecouvrement], [Poste], [ComPoste], [TravailExcept], [ComTravailExcept], [TempsDejeuner], [Machine], [MCUmachine], [TempsChgt], [CodeArticle], [Quantite], [Nbarret], [TempsMachine], [TempsMO]) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
ps.setString(1, (((JTextField) dateChooser.getDateEditor().getUiComponent()).getText()));
ps.setString(2, (String) jtextfieldAutoComplete.getText());
ps.setString(3, (String) textField_1.getText());
ps.setString(4, (String) textField_2.getText());
ps.setString(5, (String) nom.getText());
ps.setString(6, (String) matricule.getText());
ps.setString(7, (String) comboBox_1.getSelectedItem());
ps.setString(8, (String) temps_travail.getText());
ps.setString(9, (String) comboBox_2.getSelectedItem());
ps.setString(10, (String) texte.getText());
ps.setString(11, (String) duree.getText());
ps.setString(12, (String) automachine.getText());
ps.setString(13, (String) mcu.getText());
ps.setString(14, (String) tpschgt.getText());
ps.setString(15, (String) complet.getText());
ps.setString(16, (String) quantite.getText());
ps.setString(17, (String) nbarret.getText());
ps.setString(18, (String) tpsmachine.getText());
ps.setString(19, (String) tpsmo.getText());
ps.executeUpdate();
ps.close();
UpdateTable();
}
else
{
JOptionPane.showMessageDialog(null,"Tous les Champs doivent etre remplis");
if(jtextfieldAutoComplete.getText().trim().length() > 0 && textField_1.getText().trim().length()>0 && textField_2.getText().trim().length()>0 &&
automachine.getText().trim().length() >0 &&tpschgt.getText().trim().length() >0 &&
complet.getText().trim().length() >0 && quantite.getText().trim().length() >0 && nbarret.getText().trim().length() >0 &&
tpsmachine.getText().trim().length() >0 && tpsmo.getText().trim().length()>0 ){
}else{
ps = Connexion_BDD.get().prepareStatement(
"insert into dbo.MODTESTTABLE ([Dates],[NomEtPrenom], [Matricule], [SectionSalarie], [NomRecouvrement], [MatriculeRecouvrement], [Poste], [ComPoste], [TravailExcept],
[ComTravailExcept], [TempsDejeuner], [Machine], [MCUmachine], [TempsChgt], [CodeArticle], [Quantite], [Nbarret], [TempsMachine], [TempsMO]) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?)");
ps.setString(1, (((JTextField) dateChooser.getDateEditor().getUiComponent()).getText()));
ps.setString(2, (String) jtextfieldAutoComplete.getText());
ps.setString(3, (String) textField_1.getText());
ps.setString(4, (String) textField_2.getText());
ps.setString(5, (String) nom.getText());
ps.setString(6, (String) matricule.getText());
ps.setString(7, (String) comboBox_1.getSelectedItem());
ps.setString(8, (String) temps_travail.getText());
ps.setString(9, (String) comboBox_2.getSelectedItem());
ps.setString(10, (String) texte.getText());
ps.setString(11, (String) duree.getText());
ps.setString(12, (String) automachine.getText());
ps.setString(13, (String) mcu.getText());
ps.setString(14, (String) tpschgt.getText());
ps.setString(15, (String) complet.getText());
ps.setString(16, (String) quantite.getText());
ps.setString(17, (String) nbarret.getText());
ps.setString(18, (String) tpsmachine.getText());
ps.setString(19, (String) tpsmo.getText());
ps.executeUpdate();
ps.close();
UpdateTable();
}
}
} catch (SQLException e) {
e.printStackTrace();
JOptionPane.showMessageDialog(null,
"Erreur lors de l'enregistrement ! Veuillez contactez l'administrateur");
return;
}
/**
* PERMET LE RESET DU FORMULAIRE
*/
dateChooser.setDate(new Date());
jtextfieldAutoComplete.setText("");quantite.setText("");
textField_1.setText("");textField_2.setText("");
nom.setText("");matricule.setText("");
comboBox_1.setSelectedIndex(0);temps_travail.setText("");
comboBox_2.removeAllItems();texte.setText("");
duree.setText("");; automachine.setText("");
mcu.setText("");tpschgt.setText("");
complet.setText("");quantite.setText("");
nbarret.setText(""); tpsmachine.setText("");
tpsmo.setText("");
}
}); |
Partager