Details Voitures

<% int id1=Integer.parseInt(request.getParameter("id")); String description =""; String Matricule = ""; String Modele= ""; String Silhouette = ""; String Energie = ""; String Couleur= ""; String adresse = ""; int prix=0; int idagence=0; String lat=""; String lng=""; try{ Class.forName("com.mysql.jdbc.Driver"); String req = "select * from voiture where idvoiture="+id1; //out.print(req); // 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()){ description = rs.getString(9); Matricule = rs.getString(2); Modele = rs.getString(3); Silhouette = rs.getString(4); Energie = rs.getString(5); Couleur = rs.getString(6); prix = rs.getInt(7); adresse = rs.getString(10); idagence=rs.getInt(11); lat = rs.getString(12); lng = rs.getString(13); } } catch(Exception e){ System.out.print(e.toString()); } %>
<% 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 %>

<%=Couleur%>

Matricule : <%=Matricule%>

Agence : <%=Nom%>


Energie : <%=Energie%>
Silhouette : <%=Silhouette%>
Prix : <%=prix%>
adresse : <%=adresse%>

description :
<%= description%>

connexion