<%
String Modele = "";
int prix =0;
String img ="";
String description ="";
String Energie = "";
String Matricule ="";
String Silhouette ="";
String Couleur ="";
String id="";
String adresse="";
int idagence=0;
try{
Class.forName("com.mysql.jdbc.Driver");
String req = "select * from voiture ";
// connection base
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/guidegate?autoReconnect=true&useSSL=false","root","admin");
// bibliotheque pour executer les requetes
Statement stt = con.createStatement();
//execution requete
ResultSet rs=stt.executeQuery(req);
while(rs.next()){
Modele = rs.getString(3);
Matricule = rs.getString(2);
Silhouette = rs.getString(4);
Couleur = rs.getString(6);
prix = rs.getInt(7);
img=rs.getString(8);
description=rs.getString(9);
Energie = rs.getString(5);
adresse=rs.getString(10);
id=rs.getString(1);
idagence=rs.getInt(11);
%>
<%
String Nom="";
String requet = "select * from agence where idagence="+idagence;
// connection base
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/guidegate?autoReconnect=true&useSSL=false","root","admin");
// bibliotheque pour executer les requetes
Statement sttt = conn.createStatement();
//execution requete
ResultSet rs1=sttt.executeQuery(requet);
while(rs1.next()){
Nom = rs1.getString(2);
}
%>
<%=Modele %>
Agence : <%=Nom%> <%=Matricule %><%=Couleur %>
<%=prix %> DT
/Jours
<%=adresse%>
Decouvrir
<%} }
catch(Exception e){
System.out.print(e.toString());
}
%>