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

**Cyang** · 16/07/2011, 18h02

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

}

**Cyang** · 16/07/2011, 18h03

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());
}

}

}

**Cyang** · 16/07/2011, 18h05

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());
}

}

}

**Cyang** · 16/07/2011, 18h05

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>

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

Servlets/JSP Java

Discussions similaires

Partager

Partager