<%@ page import="java.sql.*" %>
<%!
String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
String DB_URL = "jdbcdbc:db";
%>
<html>
<head><title></title></head>
<body>
<%
Class.forName(DRIVER);
Connection connection = null;
connection = DriverManager.getConnection(DB_URL);
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery("SELECT * FROM myTb WHERE campo1 = 5");
while (resultset.next()) {
String campo2 = resultset.getString(2);
String campo3 = resultset.getString(3);
String campo4 = resultset.getString(4);
String campo5 = resultset.getString(5);
}
%>
line 46 Stampo <%= campo2%>.
</body>
</html>
__________________________________________
L'errore che mi genera è:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 46 in the jsp file: /lettura.jsp
Generated servlet error:
campo2 cannot be resolved
Cosa non sta andando ?
Rispondi quotando
