Ciao ragazzi, probabilmente mi sto ripetendo, ma dopo aver visto diversi post sono ancora al punto di partenza.
Sto facendo un programma in jsp che deve stampare a video dei risultati:
Codice PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"  pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>

<%
    Connection dbconn = null;
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException e) {
        System.out.println("Impossibile caricare il driver: "+ e);
    }
    
    try {
        //Apertura connessione al DataBase
        dbconn = DriverManager.getConnection("Jdbc:Odbc:statistica","root","");
    }
    catch (SQLException e) {
        System.out.println("Impossibile connettersi al DataBase.");
    }
%>
//// INTESTAZIONE HEAD DEL FILE

..............
<table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td>Id Partita</td>
            <td>Squadra</td>
            <td>Campionato</td>
            <td>Data</td>
            <td>Incontro</td>
            <td>risultato</td>
            <td>Parziali</td>
            <td>Modifica Partita</td>
            <td>Inserisci/Modifica dati</td>
            <td>Elimina Partita</td>
        </tr>
        <%
        try {
            Statement st = dbconn.createStatement();
            ResultSet rs = statement.executeQuery("SELECT * FROM partita ORDER BY squadra"); 
            
        }
        catch (SQLException e) {
            System.out.println("Errore Sql: " + e);
        }                         
            //if (results) {
                //ResultSet rs = st.getResultSet();
                while (rs.next()) {

                    int dat = rs.getInt("id_partita");
                    String squadra = rs.getString("squadra");
                    String tipo = rs.getString("tipo");
                    String data = rs.getString("data");
                    String incontro = rs.getString("incontro");
                    int set_casa = rs.getInt("set_casa");
                    int set_ospite = rs.getInt("set_ospite");
                    int par1 = rs.getInt("par1");
                    int par2 = rs.getInt("par2");
                    int par3 = rs.getInt("par3");
                    int par4 = rs.getInt("par4");
                    int par5 = rs.getInt("par5");
                    int par6 = rs.getInt("par6");
                    int par7 = rs.getInt("par7");
                    int par8 = rs.getInt("par8");
                    int par9 = rs.getInt("par9");
                    int par10 = rs.getInt("par10");
                    int conf = rs.getInt("conferma");
                %>
                <tr>
                    <td><% out.println(dat); %></td>
                    <td><% out.println(squadra); %></td>
                    <td><% out.println(tipo); %></td>
                    <td><% out.println(data); %></td>
                    <td><% out.println(incontro); %></td>
                    <td><% out.println(set_casa + " - " + set_ospite); %></td>
                    <td><% out.println("(" + par1 + "-" + par2 + ")(" + par3 + "-" + par4 + ")(" + par5 + "-" + par6 + ")(" + par7 + "-" + par8 + ")(" + par9 + "-" + par10 + ")"); %></td>
                    <td>[url="edit_partia.jsp?id_partita=<% out.println(dat); %>"]Modifica[/url]</td>
                    <td><%     if (conf == 1)
                                out.println("<a href=\"edit_scheda.jsp?id_partita=" + dat + "\">Modifica dati</a>");
                            else
                                out.println("<a href=\"ins_scheda.jsp?id_partita=" + dat + "\">Inserisci dati</a>");
                        %>
                    </td>
                    <td><%    if (conf == 1)
                                out.println("<a href=\"del_scheda.jsp?id_partita=" + dat + "\">Elimina Partita</a>");
                            else
                                out.println("<a href=\"del_partita.jsp?id_partita=" + dat + "\">Elimina Partita</a>"); 
                        %>
                    </td>
                </tr>
        <%     }
        //}
        dbconn.close();
        %> 
Quando lancio il file mi esce questo:
An error occurred at line: 79 in the jsp file: /statistica.jsp
statement cannot be resolved
76: <%
77: try {
78: Statement st = dbconn.createStatement();
79: ResultSet rs = statement.executeQuery("SELECT * FROM partita ORDER BY squadra");
80:
81: }
82: catch (SQLException e) {


An error occurred at line: 87 in the jsp file: /statistica.jsp
rs cannot be resolved
84: }
85: //if (results) {
86: //ResultSet rs = st.getResultSet();
87: while (rs.next()) {
88:
89: int dat = rs.getInt("id_partita");
90: String squadra = rs.getString("squadra");
Qualcuno sa spiegarmi l'errore che ormai io non ci capisco più niente?
Grazie mille!