Details Circuits

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

<%=themes%>

<%= places %>

Agence :<%=Nom%>

code:<%=code%>
prix:<%=prix%>/Dinars
duree: <%=duree%>
nombre de places: <%=nbrplace%> personne

<%= description %>

Programme:
<%=programme%>

connexion