<%@ page contentType="text/html; charset=iso-8859-1" language="java" %> <%@ page import="java.sql.*" %> <%@ page import="com.mad.*" %> <%@ page import="javax.servlet.http.HttpUtils" %> <%@ include file="../inc/parameters.jsp" %> <% /*---------------------------------------------------------------- ----------------- CONNECTION VARIABLE DECLARATION ---------------- ----------------------------------------------------------------*/ Connection conn = null; PreparedStatement stmt; ResultSet rs; int result; String QS = ""; ResultSetMetaData rsmd; %> <% /*---------------------------------------------------------------- ------------------------ VARIABLE DECLARATION -------------------- ----------------------------------------------------------------*/ String[] nome_it; String[] nome_de; String[] nome_en; String[] testo_it; String[] testo_de; String[] testo_en; String[] data; %> <% /*--------------------------------------------------------------- ---------------------- DATABASE CONNECTION ---------------------- ---------------------------------------------------------------*/ try { DriverManager.registerDriver(new com.mysql.jdbc.Driver()); conn = DriverManager.getConnection (db_str_p, db_usr_p, db_psw_p); } catch (Exception e) { out.println("

Errore:

" + e.getMessage()); out.println("QS=" + QS + "
"); } %> <% /*---------------------------------------------------------------- ------------- EXTRACTS FROM DATABASE AND PRINT ------------------- ----------------------------------------------------------------*/ QS = "SELECT *, DATE_FORMAT(t1.data, '%d/%m/%Y') as data_format "; QS += " FROM rassegna t1"; QS += " WHERE eliminato_sn = 0"; QS += " AND visibile_sn = 1"; QS += " ORDER BY data DESC"; stmt = conn.prepareStatement(QS, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(); rs.last(); int arrayLength = rs.getRow(); rs.beforeFirst(); nome_it = new String[arrayLength]; nome_de = new String[arrayLength]; nome_en = new String[arrayLength]; testo_it = new String[arrayLength]; testo_de = new String[arrayLength]; testo_en = new String[arrayLength]; data = new String[arrayLength]; if (rs.next()) { int i = 0; do { nome_it[i] = rs.getString("nome_it"); if (rs.wasNull()) { nome_it[i] = ""; } nome_de[i] = rs.getString("nome_de"); if (rs.wasNull()) { nome_de[i] = ""; } nome_en[i] = rs.getString("nome_en"); if (rs.wasNull()) { nome_en[i] = ""; } testo_it[i] = rs.getString("testo_it"); if (rs.wasNull()) { testo_it[i] = ""; } testo_de[i] = rs.getString("testo_de"); if (rs.wasNull()) { testo_de[i] = ""; } testo_en[i] = rs.getString("testo_en"); if (rs.wasNull()) { testo_en[i] = ""; } data[i] = rs.getString("data_format"); if (rs.wasNull()) { data[i] = ""; } i++; } while (rs.next()); } else { out.println("XXX"); } %> <% /*--------------------------------------------------------------- ------------------- CLOSE DATABASE CONNECTION ------------------- ---------------------------------------------------------------*/ conn.close(); %> 4FilmFestival - 4 Film Festival in Bolzano Bozen: Opere Nuove, No Words, Borderlands, Rimusicazioni
 
 
 
 

press area

<% for (int i=0;i <% } %>
<%=nome_it[i]%>
<%=testo_it[i]%>