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
| <%@ include file="configuration.jsp"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>Les Alertes</title>
<link rel="stylesheet" href="css.css" media="screen"/>
<script language="javascript" src="jquery.js"></script>
</head>
<body>
<%
try{
st1=con.createStatement();
requette1= " select * from alerte";
rs1=st1.executeQuery(requette1);
out.print("<table border=1 width=20% height=50% align=center cellspacing=4 cellpadding=5>");
out.print("<tr><td id=c1>Code_Alerte</td>");
out.print("<td id=c2>Libellée_alerte</td>");
out.print("<td id=c3>Niveau_Alerte</td>");
out.print("<td id=c3>Text_alerte</td>");
out.print("<td id=c3>Code_Type_alerte</td>");
out.print("<td id=c3>Code_Service</td>");
out.print("<td id=c4>Code_Matériel </td>");
out.print("<td colspan=2 id=c3>Supprimer</td>");
out.print("<td id=c3>Modifier</td></tr>");
while(rs1.next())
{
String ca=rs1.getString("code_alerte");
String liba=rs1.getString("lib_alerte");
String niva=rs1.getString("niveau_alerte");
String txta=rs1.getString("text_alerte");
String cta=rs1.getString("code_talerte");
String cs=rs1.getString("code_serv");
String cm=rs1.getString("code_mat");
out.print(" <tr><td>"+rs1.getString("code_alerte")+"</td>");
out.print("<td>"+rs1.getString("lib_alerte")+"</td>");
out.print("<td>"+rs1.getString("niveau_alerte")+"</td>");
out.print("<td>"+rs1.getString("text_alerte")+"</td>");
out.print("<td>"+rs1.getString("code_talerte")+"</td>");
out.print("<td>"+rs1.getString("code_serv")+"</td>");
out.print("<td>"+rs1.getString("code_mat")+"</td>");
out.print("<td><a href=# class=lien_supp>Supprimer</a></td>");
out.print("<td><a href=\'Suppression_alerte.jsp?code="+ca+"' class=ok><img src=1.jpg alt= width=40 height=20></a></td>");
out.print("<td><a href=\'Modification_alerte.jsp?code="+ca+"&lib="+liba+"&niv="+niva+"&txt="+txta+"&codeta="+cta+"&codes="+cs+"&codem="+cm+"'>Modifier</a>");
out.print("</td></tr>");
}
out.print("</table>");
st1.close();
}
catch(Exception sqlE){
out.println("La Requête n'a pas abouti");
sqlE.printStackTrace();
out.print(sqlE.getMessage());
}
%>
</body>
</html> |
