Hi,
I'm new here, sorry for my english I'm Italian Student. :)
I written this JavaBeans:
package beans;
import oggetti.cassetta;
import java.io.Serializable;
import java.sql.*;
import java.util.ArrayList;
public class catalogList implements Serializable {
private Connection conn;
private ArrayList eml;
public catalogList() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/videoteca","root","");
} catch (SQLException e) {
e.printStackTrace();
}
eml = new ArrayList();
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM cassette");
while (rs.next())
eml.add(new cassetta(rs.getInt(1), rs.getString(2),rs.getString(3),rs.getFloat(4)));
rs.close();
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public Object[] getEml() {
return eml.toArray();
}
public void destroy() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
And tried to use with this JSP:
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
<title>Videoteca P&P > catalogo</title>
</head>
<body>
<h1>VIEDEOTECA P&P | catalogo</h1>
<p>Ecco gli oggetti disponibili in magazzino</p>
<table width="100%" border="0" cellpadding="4" cellspacing="4">
<tr>
<td>ID</td>
<td>Titolo</td>
<td>Genere</td>
<td>Costo</td>
</tr>
<jsp:useBean id="cat" scope="application" class="beans.catalogList" />
<%--<jsp:getProperty name="cat" property="eml" />--%>
<c:forEach items="${cat.eml}" var="curr">
<tr>
<td><c:out value="${curr.getId()}"/></td>
<td></td>
<td>1</td>
<td>1</td>
</tr>
</c:forEach>
</table>
</body>
</html>
But at execute time isn't work and throw this exception:
>
org.apache.jasper.JasperException: /catalogo.jsp(23,12) The function getId must be used with a prefix when a default namespace is not specified
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:39)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:405)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:146)
org.apache.jasper.compiler.Validator$1FVVisitor.visit(Validator.java:1243)
org.apache.jasper.compiler.ELNode$Function.accept(ELNode.java:122)
Can yuo help me???? why append that???
Thanks lot!