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 127 128 129 130
| package Servlets;
import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.ArrayList;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Banking.Connexion;
public class ServletConsultation extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
Connection Con;
String paramcon;
ResultSet Rs;
ArrayList messages = new ArrayList();
CallableStatement CallStmt;
//Procédure INIT
public void init() {
ServletConfig config = getServletConfig();
paramcon = config.getInitParameter("paramcon");
}
// Procédure DOPOST
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException,
ServletException {
Connexion param = new Connexion(paramcon, "", "", "", "");
String coul="Magenta";
HttpSession session=request.getSession();
messages.clear();
String num=request.getParameter("txtnum");
if (num==null){
request.setAttribute("mess",messages);
request.setAttribute("coul",coul);
request.setAttribute("rs",Rs);
//messages.add("Veuillez entrer le num de compte à consulter!");
getServletContext().getRequestDispatcher("/Pages/Compte.jsp").forward(request,response);
try{Con.close();}catch(Exception e){}
return;
}
if (num.equals("")){
request.setAttribute("mess",messages);
request.setAttribute("coul",coul);
request.setAttribute("rs",Rs);
messages.add("Veuillez entrer le numéro de compte à consulter!");
getServletContext().getRequestDispatcher("/Pages/Compte.jsp").forward(request,response);
try{Con.close();}catch(Exception e){}
return;
}
String codeutil=request.getParameter("txtlogin");
String modul="HomeFirst";
String dateop="";
boolean trouve=false;
try{
//param.lecture();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //Chaine de connexion
Con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.11.128:1433;DatabaseName=HOMEFIRST", "administrateur", "admin"); //information venant du fichier de connexion
Rs=Con.createStatement().executeQuery("Select Nom,prenoms from ABONNES where NumAbo='"+ num +"'");
trouve=Rs.next();
if(!trouve){
messages.add("Désolé ce numéro n'existe pas dans la Base de donnée HOMEFIRST");
request.setAttribute("mess",messages);
request.setAttribute("coul",coul);
request.setAttribute("rs",Rs);
getServletContext().getRequestDispatcher("/Pages/Compte.jsp").forward(request,response);
try{Con.close();}catch(Exception e){}
return;
}
}catch(Exception e){
messages.add("Erreur : " + e.getMessage());
}
if (messages.size()>0){
request.setAttribute("mess",messages);
request.setAttribute("coul",coul);
request.setAttribute("rs",Rs);
getServletContext().getRequestDispatcher("/Pages/Compte.jsp").forward(request,response);
}
else{
try{
param.lecture();
Class.forName(param.getDriver()); //Chaine de connexion
Con = DriverManager.getConnection(param.getURL(), param.getLogin(), param.getPwd()); //information venant du fichier de connexion
CallStmt=Con.prepareCall("{CALL PS_Enreg_Journal(?, ?, ?, ?)}");
CallStmt.setString(1,modul);
CallStmt.setString(2,num);
CallStmt.setString(3,dateop);
CallStmt.setString(4,codeutil);
CallStmt.executeUpdate();
session.setAttribute("nom", Rs.getString(1)+ " "+ Rs.getString(2));
session.setAttribute("num", num);
request.setAttribute("mess",messages);
request.setAttribute("coul",coul);
request.setAttribute("rs",Rs);
getServletContext().getRequestDispatcher("/Pages/Extraire.jsp").forward(request,response);
}catch(Exception e){
messages.add("Erreur lors de la consultation : " + e.getMessage());
coul="Magenta";
}
}
try{Rs.close(); Con.close();}catch(Exception ex){}
}
//Procédure DOGET
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException,
ServletException {
doPost(request, response);
}
} |
Partager