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
|
String chp_unite = request.getParameter("unite");
String chp_aff = request.getParameter("affaire");
String chp_nomResp = request.getParameter("nomResp");
String chp_telResp = request.getParameter("telResp");
String chp_ctv = request.getParameter("ctv");
Connection dbc = DriverManager.getConnection("jdbc:oracle:thin:@localhost.......",".....","......");
if (chp_unite == null)
out.print("Veuillez saisir une unité");
else{
int r_unite;
String sqlUnite = "SELECT id_unite FROM unite WHERE nom_unite= ?";
PreparedStatement pstmt = dbc.prepareStatement(sqlUnite);
pstmt.setString(1, chp_unite);
ResultSet resultat_unite = pstmt.executeQuery();
if(resultat_unite.next()) {
r_unite = resultat_unite.getInt("id_unite");
}
}
if (chp_aff == null)
out.print("Veuillez saisir un numéro d'affaire");
else{
PreparedStatement pstmt;
pstmt = dbc.prepareStatement("SELECT COUNT(id_numero_Aff) AS nb FROM numero_Aff WHERE num_affaire = ?;");
pstmt.setString(1, chp_aff);
ResultSet resultat_affaire = pstmt.executeQuery();
if(resultat_affaire.next()) {
int nb = resultat_affaire.getInt("nb");
if(nb == 0) {
pstmt = dbc.prepareStatement("INSERT INTO numero_Aff (id_numero_Aff, num_affaire) VALUES (num_aff_seq.NEXTVAL, ?);");
pstmt.setString(1, chp_aff);
pstmt.executeUpdate();
}
else{
pstmt = dbc.prepareStatement("SELECT id_numero_Aff FROM numero_Aff WHERE num_affaire =?");
resultat_affaire = pstmt.executeQuery();
if(resultat_affaire.next()) {
int r_affaire = resultat_affaire.getInt("id_numero_Aff");
}
}
}
}
if (chp_nomResp == null)
out.print("Veuillez saisir un responsable");
else{
int r_nomResp;
String sqlnomResp = "SELECT id_resp FROM resp_chantier WHERE nom_prenom_res=?";
PreparedStatement pstmt = dbc.prepareStatement(sqlnomResp);
pstmt.setString(1, chp_nomResp);
ResultSet resultat_nomResp = pstmt.executeQuery();
if(resultat_nomResp.next()) {
r_nomResp = resultat_nomResp.getInt("id_resp");
}
}
if (chp_telResp == null)
out.print("Veuillez saisir un responsable");
if (chp_ctv == null)
out.print("Veuillez saisir un numéro CTV");
else{
PreparedStatement pstmt;
pstmt = dbc.prepareStatement("SELECT COUNT(id_fouille) AS nb FROM fouille WHERE num_ctv = ?;");
pstmt.setString(1, chp_ctv);
ResultSet resultat_fouille = pstmt.executeQuery();
if(resultat_fouille.next()) {
int nb = resultat_fouille.getInt("nb");
if(nb == 0) {
pstmt = dbc.prepareStatement("INSERT INTO fouille (id_fouille, num_ctv, id_resp, id_unite, id_numero_Aff, id_entreprise) VALUES (fouille_seq.NEXTVAL, ?,"+r_ccs+","+r_nomResp+","+r_unite+",num_aff_seq.CURRVAL,"+r_nomEntreprise+");");
pstmt.setString(1, chp_ctv);
pstmt.executeUpdate();
}
else{
pstmt = dbc.prepareStatement("SELECT id_fouille FROM fouille WHERE num_ctv =?");
resultat_fouille = pstmt.executeQuery();
if(resultat_fouille.next()) {
int r_fouille = resultat_fouille.getInt("id_fouille");
}
}
}
}
dbc.close();
<jsp:forward page="provPonctuel.jsp">
<jsp:param value="<%=champUnite%>" name="unite"/>
<jsp:param value="<%=champAff%>" name="affaire"/>
<jsp:param value="<%=champCTV%>" name="ctv"/>
</jsp:forward> |
Partager