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
| <body>
<form action="/Testsql/servlet/servletCalcul" method="post">
Tableau resultat <input type="text" name="variableSql"> REQUETTE <input type="submit" value="Valider" name="Valider">
<%String url = request.getAttribute("urlconnection").toString(); String user = request.getAttribute("utilisateur").toString();
String password = request.getAttribute("mot de passe").toString(); %>
<%Connection conn = DriverManager.getConnection(url,user,password);%>
<%Statement stmt=conn.createStatement();
String maRequeteSql="SELECT nom,prenom FROM Candidat";
ResultSet monResultSet=stmt.executeQuery(maRequeteSql);%>
<table border=1 bordercolor=#C0C0C0 cellspacing="0" cellpadding="4">
<tr><td>Nom</td><td>prenom</td></tr>
<%while (monResultSet.next()) {
out.println("<tr>");
out.print("<td>");
out.print(monResultSet.getString(1));
out.print("</td>");
out.print("<td>");
out.print(monResultSet.getString(2));
out.print("</td>");
out.print("</tr>");
}stmt.close();
conn.close();%>
</table>
</form>
</body> |