Bonjour tout le monde
j"essaye de faire separation du partie traitement servlet au partie jsp présentation a travers récupération résultat d'une requete selection qui se trouve au page servlet mais ca marche pas voici le code du page servlet et page jsp
page servlet
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Administrateur
* @version
*/
public class liste23 extends HttpServlet {
public Connection con;
private PrintWriter out;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:test5";
con=DriverManager.getConnection(url,"","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM etud");
HttpSession session = request.getSession(true);
session.setAttribute("resultset", rs);
response.sendRedirect("liste2.jsp");}
catch(Exception e)
{
System.out.println(e);
}
}
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
et page jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>JSP Page</h1>
<form>
<form >
<table border="1">
<body>
<tr>
<td>Nom</td>
<td>Prenom</td>
</tr>
<% session.getAttribute("resultset");
ResultSet rs = (ResultSet) request.getAttribute("resultset"); %>
<% while(rs.next()){%>
<tr>
<td align="center"><%=rs.getString(2)%></td>
<td align="center"><%=rs.getString(3)%></td>
</tr>
<% } %>
</table>
</form>
</body>
</html>
et lorsque j'execute page servlet il s'affiche page blanche
Configuration: Windows XP
Internet Explorer 6.0
Access : remplir une zone de texte par le resultat d'une requete
