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);
}
} |
