<%
String nom = "";
int prix = 0;
String img ="";
String description ="";
int cat = 0;
String Adresse ="";
String id="";
String categories = request.getParameter("5");
int idagence=0;
try{
Class.forName("com.mysql.jdbc.Driver");
String req = "select * from hotel ";
// 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(2);
prix = rs.getInt(8);
img=rs.getString(9);
description=rs.getString(10);
cat = rs.getInt(3);
Adresse=rs.getString(4);
id=rs.getString(1);
idagence = rs.getInt(11);
%>
<%=nom %>
<%
if(cat==1){
%>
<%
}
if(cat==2){
%>
<%
}
if(cat==3){
%>
<%
}
if(cat==4){
%>
<%
}
if(cat==5){
%>
<%
}
%>
<%
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);
}
%>
Agence :<%=Nom%>
<%=prix %> DT
/nuits
<%= Adresse %>
Decouvrir
<%} }
catch(Exception e){
System.out.print(e.toString());
}
%>