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
| private void BtnenregistrerActionPerformed(java.awt.event.ActionEvent ev){
try{
if( demande.isSelected() && copie.isSelected() && auto.isSelected() && status.isSelected() && carte.isSelected() && attes.isSelected()
&& certi.isSelected() && attesta.isSelected() && bul.isSelected());
{
String query2 = "UPDATE entreprise SET dossier_administratif = ? WHERE N_de_dossier = "+V.TxtDoss.getText()+"";
try{
java.sql.PreparedStatement P1 = C.prepareStatement(query2);
P1.setString(13, " Dossier administratif complet ");
P1.executeUpdate();
JOptionPane.showMessageDialog(null," Dossier administratif COMPLET ! ");
}catch(Exception e) {
e.printStackTrace() ;
System.out.println("Erreur : " + e.getMessage());
}
}
if ( demande.isSelected() || copie.isSelected() || auto.isSelected() || status.isSelected() || carte.isSelected() || attes.isSelected()
|| certi.isSelected() || attesta.isSelected() || bul.isSelected());
{
String query3 = "UPDATE entreprise SET dossier_administartif VALUES = 'Dossier administratif incomplet' WHERE N_de_dossier = "+V.TxtDoss.getText()+"";
try{
java.sql.PreparedStatement P2 = C.prepareStatement(query3);
P2.setString(13, " Dossier administratif incomplet ");
P2.executeUpdate();
JOptionPane.showMessageDialog(null," Dossier administratif INCOMPLET ! ");
}
catch(Exception e) {
System.out.println("Erreur : " + e.getMessage());
}
}
}catch(Exception e){
System.out.println(e.getMessage()+ "/" + e.getStackTrace());
}
} |