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
|
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connexion_Session/connexionBddMysql.jsp" %>
<%
//requete MySQL
String reqOperateurMySQL = "select * from personne where statut = 1 order by nom";
ResultSet rsOperateurMySQL;
rsOperateurMySQL = lienMySQL.executeQuery(reqOperateurMySQL);
%>
<html>
<head>
<script language="javascript">
function changer_couleurs(elem, color)
{
alert(elem);
alert(color);
elem.style.backgroundColor = color;
}
</script>
</head>
<body>
<form name="form">
<table>
<tr><td><input type="text" name="profil_0" value="text" /></td><td>
<select size="1" name="bgColor_0" onchange="changer_couleurs(document.form.profil_0, this.value)">
<option>--Couleur--</option>
<option value="Blue">Bleu</option>
<option value="aquamarine">Bleu marine</option>
<option value="Navy">Bleu foncé</option>
<option value="darkslateblue">Bleu violet</option>
<option value="cadetblue">Bleu vert</option>
<option value="Green">Vert</option>
<option value="springgreen">Vert fluo</option>
<option value="darkkhaki">Vert khaki</option>
<option value="Yellow">Jaune</option>
<option value="Orange">Orange</option>
<option value="deeppink">rose</option>
<option value="tomato">Tomate</option>
<option value="Red">Rouge</option>
<option value="Violet">Violet</option>
<option value="darkred">Violet foncé</option>
<option value="turquoise">Turquoise</option>
<option value="salmon">Saumon</option>
<option value="darksalmon">Saumon foncé</option>
<option value="darkgoldenrod">Or sombre</option>
<option value="wheat">Marron clair</option>
<option value="tan">Marron</option>
<option value="chocolate" selected>Chocolat</option>
</select>
</td></tr>
<tr>
<% while (rsOperateurMySQL.next())
{
String nomMySQL = rsOperateurMySQL.getString("nom");
String id = rsOperateurMySQL.getString("idpersonne");
%>
<td><input type="text" name="profil_<% out.println(id); %>" value="<% out.println(nomMySQL); %>" /></td><td>
<select size="1" name="bgColor_<% out.println(id); %>" onchange="changer_couleurs(document.form.profil_<% out.println(id); %>, this.value)">
<option>--Couleur--</option>
<option value="Blue">Bleu</option>
<option value="aquamarine">Bleu marine</option>
<option value="Navy">Bleu foncé</option>
<option value="darkslateblue">Bleu violet</option>
<option value="cadetblue">Bleu vert</option>
<option value="Green">Vert</option>
<option value="springgreen">Vert fluo</option>
<option value="darkkhaki">Vert khaki</option>
<option value="Yellow">Jaune</option>
<option value="Orange">Orange</option>
<option value="deeppink">rose</option>
<option value="tomato">Tomate</option>
<option value="Red">Rouge</option>
<option value="Violet">Violet</option>
<option value="darkred">Violet foncé</option>
<option value="turquoise">Turquoise</option>
<option value="salmon">Saumon</option>
<option value="darksalmon">Saumon foncé</option>
<option value="darkgoldenrod">Or sombre</option>
<option value="wheat">Marron clair</option>
<option value="tan">Marron</option>
<option value="chocolate" selected>Chocolat</option>
</select>
</td>
<%
}
%>
</tr>
</form>
</body>
</html> |
