<% // 05-08-2009 Sonia String connectionURL = "jdbc:mysql://192.168.1.3/offerte2009?user=webmaster&password=wms"; Connection connection = null; Statement statement = null; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "", ""); statement = connection.createStatement(); // Visualizzo tutte le offerte di tipologia = "STR" = Strutture e catalogo = "BAIA" , non annullate String query = "SELECT * FROM offerte WHERE tipologia='S_EN' "+ "AND catalogo = 'BAIA' " + "AND annullato = 'N' " + "ORDER BY idOfferta desc"; ResultSet selectAll = statement.executeQuery(query); String idOfferta = ""; int count = 0; while (selectAll.next()) { count++; idOfferta = selectAll.getString("idOfferta"); if (!selectAll.getString("pdf").equals("")) { out.println("

-  " + selectAll.getString("titolo") + "

"); if (!selectAll.getString("sottotitolo").equals("")) { out.println(""); out.println(" " + selectAll.getString("sottotitolo") + "
"); } out.print(""); out.print("CLICK HERE TO SEE ALL THE DETAILS OF THE OFFER!!!"); out.println("


"); } } // endwhile if (count == 0) { out.println("

"); out.println("ACTUALLY THERE ARE NO OFFERS AVAILABLE."); out.println("

"); } selectAll.close(); %>