<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*,org.netbeans.modules.web.monitor.server.MonitorRequestWrapper"%> <%@ page import="java.lang.*,java.io.*,java.util.*" %> <%! Statement statement = null; Connection myConnection = null; String userName="taieb"; String password="BD2008"; %> <% try { String url = "jdbc:postgresql://nivose.informatique.univ-paris-diderot.fr/taieb"; Class.forName("org.postgresql.Driver"); myConnection= DriverManager.getConnection(url,userName,password); statement = myConnection.createStatement(); } catch (java.lang.Exception ex){ out.println(ex.toString());} %> <%! public void afficherObjets(String requete,JspWriter out) throws Exception{ //out.println("Affichage de la requete : "+requete); ResultSet rs = statement.executeQuery(requete); ResultSetMetaData rsmd = rs.getMetaData(); int taille = rsmd.getColumnCount(); out.println(""); //out.println(""); out.println(""); for(int i=1;i<=taille;i++){ out.println("");//+rsmd.getColumnName(i)+""); } out.println(""); while (rs.next()) { out.println(""); for(int i=1;i<=taille;i++){ String requete2 = new String("select * from objet where id='"+rs.getInt(1)+"'"); out.println(""); } out.println(""); } out.println("

Les Objets en vente

"); if((rsmd.getColumnName(i)).equals("photo")) out.println(""); else out.println(rs.getObject(i).toString()); out.println("

"); rs.close(); } public void afficherObjet(int idObjet,JspWriter out) throws Exception{ String requete = "select * from objet where id="+idObjet; ResultSet rs = statement.executeQuery(requete); rs.next(); out.println(""); out.println(rs.getString("nom")); rs.close(); } public void afficherTypes(JspWriter out) throws Exception{ ResultSet rs = statement.executeQuery("select * from type"); Statement statement2 = myConnection.createStatement(); while (rs.next()) { if(rs.getInt("father")==-1){ String req = new String("select * from didobject where type='"+rs.getInt("id")+"'"); out.println(""+rs.getString("name")+"
"); ResultSet sousRequete = statement2.executeQuery("select * from type where father="+rs.getInt("id")); while(sousRequete.next()){ String requete = new String("select * from didobject where type='"+sousRequete.getInt("id")+"'"); out.println("- "+sousRequete.getString("name")+"
"); } sousRequete.close(); } } rs.close(); } public void afficherCentre(HttpServletRequest r,JspWriter out) throws Exception{ if(r.getParameter("objet")!=null){ afficherObjet(new Integer(r.getParameter("objet")),out); } else{ if(r.getParameter("requete")!=null) afficherObjets(r.getParameter("requete"),out); else afficherObjets("select id,nom,date,photo from objet order by date DESC LIMIT 20 OFFSET 0",out); } } public void afficherCommentaires(JspWriter out) throws Exception{ try{ ResultSet rs = statement.executeQuery("select commentaire,prenom,date from commentaire Co,client C where C.numero=Co.auteur order by date DESC LIMIT 10 OFFSET 0"); while (rs.next()) { out.println("\""+rs.getString(1)+"\""); out.println("

"+rs.getString(2)+"
"); out.println("("+rs.getString(3)+")

"); } rs.close(); }catch ( java.lang.Exception ex){ ex.printStackTrace();} } %>

Heure officielle <%=new java.util.Date()%>		Login Mot de passe
Accéder à une rubriques <%afficherTypes(out);%>	<%afficherCentre(request,out);%>	<%afficherCommentaires(out);%>

<% try{myConnection.close();}catch(Exception e){out.println(e.toString());}%>