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
|
@SuppressWarnings("deprecation")
public void insertEtudiant(int codeP, int codeM) throws Exception {
int codeLieu = getLieu();
int codeNat = getNat();
String codeF = getFiliere();
int codeMotif = getMotif();
PreparedStatement statEt = null;
PreparedStatement statFils = null;
String etudiant = "INSERT INTO etudiant (bac,nom,prenom,genre,adresse,n_phone,mail,n_ccp,decision,bloque,"
+ "n_ins,annee__encours,annee_univ,annee_courante,reste,"
+ "an_1,an_2,an_3,an_4,an_5,an_6,an_7,an_8,an_9,an_10,"
+ "cycle,nbr_annee,code_f,date_nais,code,code_nat,Observation,date_bloc,code_motif) "
+ "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
String fils = "INSERT INTO fils_de (bac,code_p,code_m) VALUES (?,?,?)";
try {
cnx.setAutoCommit(false);
statEt = cnx.prepareStatement(etudiant);
statFils = cnx.prepareStatement(fils);
statEt.setString(1, txtBAC.getText());
statEt.setString(2, txtNom.getText());
statEt.setString(3, txtPrenom.getText());
statEt.setString(4, genre);
statEt.setString(5, txtAdr.getText());
statEt.setString(6, txtPhone.getText());
statEt.setString(7, txtMail.getText());
statEt.setString(8, (String) txtCCP.getValue());
statEt.setString(9, txtDec.getText());
statEt.setBoolean(10, bloc);
statEt.setString(11, txtIns.getText());
statEt.setString(12, txtAn.getText());
statEt.setString(13, txtUniv.getText());
statEt.setInt(14,
new java.sql.Date(System.currentTimeMillis()).getYear());
statEt.setInt(15, reste);
// stat.setInt(6, rds);
statEt.setInt(16, 0);
statEt.setInt(17, 0);
statEt.setInt(18, 0);
statEt.setInt(19, 0);
statEt.setInt(20, 0);
statEt.setInt(21, 0);
statEt.setInt(22, 0);
statEt.setInt(23, 0);
statEt.setInt(24, 0);
statEt.setInt(25, 0);
statEt.setString(26, txtBAC.getText());
statEt.setString(27, codeF);
statEt.setString(28, cycle);
statEt.setString(29, ((JTextField) dateChooser.getDateEditor()
.getUiComponent()).getText());
statEt.setInt(30, codeLieu);
statEt.setInt(31, codeNat);
// statEt.setInt(14, codePhoto);
statEt.setString(32, txtObs.getText());
statEt.setDate(33, new java.sql.Date(System.currentTimeMillis()));
statEt.setInt(34, codeMotif);
statEt.execute();
statFils.setString(1, txtBAC.getText());
statFils.setInt(2, codeP);
statFils.setInt(3, codeM);
statFils.execute();
} catch (SQLException e ) {
JOptionPane.showMessageDialog(null, e);
if (cnx != null) {
try {
System.err.print("Transaction is being rolled back");
cnx.rollback();
} catch(SQLException ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
} finally {
if (statEt != null) {
statEt.close();
}
if (statFils != null) {
statFils.close();
}
cnx.setAutoCommit(true);
}
} |
Partager