Acceuil Circuit

Circuits

Trouver le circuit

-
<% String places = ""; int prix = 0 ; String img =""; String description =""; String themes =""; String id=""; String duree=""; int nbrplace= 0; String code= "" ; String programme=""; int idagence=0; try{ Class.forName("com.mysql.jdbc.Driver"); String req = "select * from circuit "; // 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()){ places = rs.getString(2); prix = rs.getInt(4); img= rs.getString(10); description = rs.getString(7); programme = rs.getString(9); duree=rs.getString(8); id=rs.getString(1); themes=rs.getString(6); nbrplace=rs.getInt(5); code=rs.getString(3); 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); } %>

<%=places %>

Agence : <%=Nom%>

<%=prix %> DT

<%=themes%> ,<%=duree %> Decouvrir

<%} } catch(Exception e){ System.out.print(e.toString()); } %>