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
| <form action="rech_membres.jsp" method="post">
>>Recherche par : <br><br>
<input type="checkbox" name="ON1" value="" /> Par Login : <input type="text" name="logg" value="" /><br><br>
<input type="checkbox" name="ON1" value="" /> Par Cin : <input type="text" name="cin" value="" /><br><br>
<input type="checkbox" name="ON1" value="" /> Par filière : <select name="file"><br><br>
<option>TDI</option>
<option>TDM</option>
<option>TRI</option>
</select> <br><br>
<input type="submit" value="Rechercher" />
<% ResultSet rs ; Statement st; Connection cc ; %>
<% String aa = request.getParameter("logg");
String bb = request.getParameter("cin");
String dd = request.getParameter("file");
String r = request.getParameter("rr");
%>
<br><br><br>
<table border="1">
<thead>
<tr>
<th>Num</th>
<th>Nom et prénom</th>
<th>Email</th>
<th>Télephone</th>
<th>Login</th>
</tr>
</thead>
<%
cc=cnx.connect();
st=cc.createStatement();
rs=st.executeQuery("select id,NOM_PRENOM,DATE_NAISSANCE,EMAIL,TELEPHONE,LOGIN,PASSE from etudiants where validation = 1 and login = '"+aa+"' ");
while(rs.next()){
%>
<tbody>
<tr>
<td><%=rs.getObject(1)%></td>
<td><%=rs.getObject(2)%></td>
<td><%=rs.getObject(4)%></td>
<td><%=rs.getObject(5)%></td>
<td><%=rs.getObject(6)%></td>
</tr>
<%}%>
</tbody>
</table>
</form> |
Partager