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
| <%@ page import="java.sql.*" %>
<html>
<head>
<title>Résultat</title>
</head>
<body>
<%
String nom=request.getParameter("nom");
String prenom=request.getParameter("prenom");
out.print(nom+" "+prenom+" est joignable au(x) numéro(s) suivants:");
Class.forName("com.mysql.jdbc.Driver");
Connection dbCon=DriverManager.getConnection("jdbc:mysql://localhost/annuaire");
String requete="select lieu,num from joignable where (nom="+nom+" and prenom="+prenom+")";
Statement stmt=dbCon.createStatement();
ResultSet resultat=stmt.executeQuery(requete);
while (resultat.next()){
String lieu = resultat.getString("lieu");
String num = resultat.getString("num");
out.println("<ul>");
out.println("<li>"+lieu);
out.println(num);
out.println("</ul>");}
resultat.close();
dbCon.close();
%>
</body>
</html> |
