Récupérer des données d'une base de donnés en utilisant les beans

Version imprimable

16/07/2011, 18h02
Cyang

Récupérer des données d'une base de donnés en utilisant les beans

Salut tout le monde.Svp J'ai besoin d'un petit coup de main.
en fait j'essaie d'implementer un petit programme qui sert a afficher des données a partir d'une base de données.mais ren vain une fenetre apparait brusquement quand j'essaie d'afficher ma jsp(http://localhost/TP/ShowEtudiant.jsp)===>une fenetre ou est ecrit debug(.....)et quand je la ferme voila l'erreur qui s'affiche
<strong>GRAVE: The web application [/TP] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation.<strong>

bon assez parler voila mn code:

package com.packbeans;

import java.io.Serializable;

public class EtudiantInfo implements Serializable {
private String firstname;
private String lastname;
private String CodeNatE;
private String FiliereE;

//@author Imane

public EtudiantInfo()
{
this.firstname="";
this.lastname="";
this.CodeNatE="";
this.FiliereE="";
}

public String getFirstname() {
return firstname;
}

public void setFirstname(String firstname) {
this.firstname = firstname;
}

public String getLastname() {
return lastname;
}

public void setLastname(String lastname) {
this.lastname = lastname;
}

public String getCodeNatE() {
return CodeNatE;
}

public void setCodeNatE(String codeNatE) {
CodeNatE = codeNatE;
}

public String getFiliereE() {
return FiliereE;
}

public void setFiliereE(String filiereE) {
FiliereE = filiereE;
}

//End Class Etudiant EtudiantInfo

}
16/07/2011, 18h03
Cyang

package com.packbeans;
import java.sql.*;
import java.util.ArrayList;

import javax.servlet.ServletException;
public class PersonneDao {

private Connection conn;

public PersonneDao()
{

}

public void establishconnection()throws ClassNotFoundException,SQLException
{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/db_ensaf";
conn=DriverManager.getConnection(url,"root","ensaf");
//Estabilishing Connection

}
public ArrayList listPersonne() throws SQLException
{
ArrayList listPerson=new ArrayList();
//Preparing Query
String sql="Select * from etudiant ";
Statement state=conn.createStatement();
//Excute Query

ResultSet rs=state.executeQuery(sql);
String firstname;
String lastname;
String CodeNatE;
String FiliereE;

while(rs.next())
{
firstname=rs.getString("firstname");
lastname=rs.getString("lastname");
CodeNatE=rs.getString("CodeNatE");
FiliereE=rs.getString("FiliereE");

EtudiantInfo etudiant=new EtudiantInfo();
etudiant.setFirstname(firstname);
etudiant.setLastname(lastname);
etudiant.setCodeNatE(CodeNatE);
etudiant.setFiliereE(FiliereE);
listPerson.add(etudiant);

}

return listPerson;

}

public void finalize()
{

try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println(e);
System.out.println(e.getMessage());
}

}

}
16/07/2011, 18h05
Cyang

package com.controller;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.packbeans.PersonneDao;

public class ShowServlet extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
{
try{

HttpSession session=request.getSession(true);
PersonneDao personne=new PersonneDao();

ArrayList list=personne.listPersonne();
session.setAttribute("list",list);
response.sendRedirect("ShowEtudiant.jsp");

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
log(e.getMessage());
}

}

}
16/07/2011, 18h05
Cyang

finalement voila le code de la jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.util.*" %>
<%@page import="com.packbeans.*" %>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<h2>Resultat DE la Recherche</h2>

<%

ArrayList list=(ArrayList)(session.getAttribute("list"));
EtudiantInfo etudiant=null;
for(int i=0;i<list.size();i++)
{
etudiant=((EtudiantInfo)(list.get(i)));
%>

<%= etudiant.getFirstname() %>
<%=etudiant.getLastname() %>
<%=etudiant.getCodeNatE() %>
<%=etudiant.getFiliereE() %>

<%
}
%>

</body>
</html>