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;");
} |
Partager