Olá
Estou tentato recuperar os dado do banco utilizando um list… porem está me dando o seguinte erro… se alguém puder me orientar o que devo fazer …
Erro…
[b][b][b]
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 3 in the jsp file: /lista-contatos.jsp
Generated servlet error:
o cannot be resolved
An error occurred at line: 3 in the jsp file: /lista-contatos.jsp
enerated servlet error:
contatos.size cannot be resolved or is not a field
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)[/b
package br.com.jdbc.modelo;
public class Contato {
long id;
String nome;
String email;
String endereco;
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getEndereco() {
return endereco;
}
public void setEndereco(String endereco) {
this.endereco = endereco;
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
}
package br.com.jdbc.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import br.com.jdbc.ConnectionFactory;
import br.com.jdbc.modelo.Contato;
public class ContatoDAO {
private Connection con;
public ContatoDAO() throws SQLException {
this.con = ConnectionFactory.getConnection();
}
public void adciona(Contato contato) throws SQLException {
PreparedStatement stmt = this.con
.prepareStatement("insert into contatos (nome,email,endereco) values (?,?,?)");
stmt.setString(1, contato.getNome());
stmt.setString(2, contato.getEmail());
stmt.setString(3, contato.getEndereco());
stmt.execute();
stmt.close();
}
public List<Contato> getLista() throws SQLException {
PreparedStatement stmt = this.con
.prepareStatement("select * from contatos");
ResultSet rs = stmt.executeQuery();
List<Contato> contatos = new ArrayList<Contato>();
while (rs.next()) {
Contato contato = new Contato();
contato.setNome(rs.getString("nome"));
contato.setEmail(rs.getString("email"));
contato.setEndereco(rs.getString("endereco"));
contatos.add(contato);
}
stmt.execute();
stmt.close();
return contatos;
}
}
<%@ page import=“java.util.,br.com.jdbc,br.com.jdbc.dao.,br.com.jdbc.modelo.” %>
<%
ContatoDAO dao = new ContatoDAO();
List contatos = dao.getLista();
for (int i = o; i< contatos.size; i++){
Contato contato = (Contato) contatos.get(i);
%>
<li><%= contato.getNome()%>, <%= contato.getEmail()%>
<%= contato.getEndereco()%></li>
<%
}
%>
