<%
String nom = "";
int prix =0;
String img ="";
String description ="";
String adresse ="";
String id="";
String code = "";
String date="";
int idagence=0;
try{
Class.forName("com.mysql.jdbc.Driver");
String req = "select * from evenement ";
// 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()){
nom = rs.getString(3);
prix = rs.getInt(7);
img=rs.getString(6);
description=rs.getString(4);
adresse=rs.getString(5);
code=rs.getString(2);
id=rs.getString(1);
date=rs.getString(8);
idagence=rs.getInt(9);
%>
<%
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);
}
%>
<%=nom %>
Agence : <%=Nom%>
<%=prix %> DT
/personne
<%= adresse %>
Decouvrir
<%} }
catch(Exception e){
System.out.print(e.toString());
}
%>