Servlet et JDBC(affichage d'une liste de client)

bonjour,
j'ai besoin d'une servlet qui affiche la liste des client dans une page web,
j'ai une base de donnée MYSQL.
Voila le mon programme de servlet:

Code:

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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
 
	public class ServletListeC extends HttpServlet {
 
	private Database db;
	PrintWriter out;
	RecordSet rs;
	public void init() {
	db=new Database(Database.MYSQL);
	db.open("gestion","root","karim");
	//RecordSet r = new RecordSet(db.getConnection(),"select * from client");
	}
	public void doGet(HttpServletRequest req, HttpServletResponse rep) 
		throws ServletException
	{
		doPost(req, rep);
	}
	//ServletInputStream getInputStream();
	public void doPost(HttpServletRequest req, HttpServletResponse rep) throws ServletException
	{
		try {
			rep.setContentType("text/html");  // type MIME pour l'en-tête http --> Page HTML
		    out = rep.getWriter();
		    out.println("<html>");
		    out.println("<head><title></title></head>");
		    out.println("<body >");		   
 
		    Client c = new Client(req.getParameter("matricule"),req.getParameter("nom"),req.getParameter("prenom"),	req.getParameter("raison sociale") ,req.getParameter("tel"), req.getParameter("email"), req.getParameter("ville"),req.getParameter("code postale"), req.getParameter("pays"), req.getParameter("fax"), req.getParameter("site web"), req.getParameter("adresse"));
		    out.println("<p>id_client :"
		    /*+req.getInt()+"</p>");
		    out.println("<p>nom :"
		    +req.getString()+"</p>");*/
			Client c = new Client(System.out.println("id_client: "+rs.getString("id_client")),System.out.println("nom: "+rs.getString("Nom")),System.out.println("prenom: "+rs.getString("prenom")),System.out.println("tel: "+rs.getString("tel")),System.out.println("adresse: "+rs.getString("adresse")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println("id_client: "+rs.getString("id_client")),System.out.println(": "+rs.getString("")));			
			out.println("<h1><font color='blue'>" + c + "</font></h1>");
		    c.rechercher(rs,db);
 
		}
		catch(Exception e) {
			out.println("Erreur de connexion: " + e.getMessage());}
	}
}
la méthode rechercher est dans la classe client:
[COLOR="DarkRed"]
public void rechercher(RecordSet rs,Database db){
		rs.doOutput(db,"Select id_client,nom,prenom,tel,adresse from client;");
 
 
	}

la méthode doOutput est dans la classe RecordSet:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
public void doOutput(Database d,String query){
		try {
			statement = db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
			ResultSet.CONCUR_UPDATABLE);
 
			rs = statement.executeQuery(query);
			while(rs.next()){ctrec++;
			System.out.println(rs.getString(1))	;					
			}
			System.out.println(toString());
			}
			catch(Exception e) {
			System.out.println("Erreur de recherche: " + e.getMessage());
		}
 
	}

voila l'error qui s'affiche lors de l'execution de la servlet

Code:

1
2
3
cannot find symbolsymbol  : method getInt()
location: interface javax.servlet.http.HttpServletRequest
                    +req.getInt()+"</p>");

s'ils vous plait aidez moi à trouver la solutionje suis certaine que la servlet est erronée.
merci