Sou nova em java não estou conseguindo chamar tabela do banco através do ArrayList usando Iterator alguém pode me ajudar ?
Erro:
type Exception report
messageInternal Server Error
descriptionThe server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP
PWC6199: Generated servlet error:
source value 1.5 is obsolete and will be removed in a future release
PWC6199: Generated servlet error:
target value 1.5 is obsolete and will be removed in a future release
PWC6199: Generated servlet error:
To suppress warnings about obsolete options, use -Xlint:-options.
PWC6199: Generated servlet error:
‘catch’ without ‘try’
PWC6199: Generated servlet error:
‘finally’ without ‘try’
PWC6199: Generated servlet error:
‘try’ without ‘catch’ or ‘finally’
PWC6199: Generated servlet error:
illegal start of expression
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
not a statement
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
illegal start of expression
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
not a statement
PWC6199: Generated servlet error:
’;’ expected
PWC6199: Generated servlet error:
reached end of file while parsing
note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 4.1.1 logs.
<%@page import="br.com.videoezuel.javabean.model.Usuarios" %>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<c:import url="cabecalho.jsp"/>
<h1>Lista de Usuarios via JSTL java: </h1>
<table border="1">
<tr>
<td>Usuario</td><td>Nivel de Acesso</td><td>Nome Completo</td>
</tr>
<%
List ListaDeUsuarios = (List) request.getAttribute("sessaolistausuarios");
for (Iterator iterator = ListaDeUsuarios.iterator(); iterator.hasNext();) {
Usuarios usuarios = (Usuarios) iterator.next();%>
<tr>
<td><%=usuarios.getUsuario() %></td>
<td><%=usuarios.getNivel()%></td>
<td><%=usuarios.getNomeCompleto() %></td>
</tr>
%>
}
%>
</table>
<c:import url="rodape.jsp"/>
DAO
public List getlistaUsuarios() throws SQLException {
String sql = "select * from usuarios";
PreparedStatement ps = null;
ResultSet ResultSet = null;
List<Usuarios> listaUsuarios = new ArrayList<Usuarios>();
try {
ps = connection.prepareStatement(sql);
ResultSet = ps.executeQuery();
while (ResultSet.next()) {
Usuarios usuarios = new Usuarios();
usuarios.setSenha(ResultSet.getString("senha"));
usuarios.setUsuario(ResultSet.getString("usuario"));
usuarios.setNivel(ResultSet.getInt("nivel"));
usuarios.setNomeCompleto(ResultSet.getString("nomecompleto"));
listaUsuarios.add(usuarios);
}
return listaUsuarios;
} catch (SQLException ex) {
Logger.getLogger(UsuarioDAO.class.getName()).log(Level.SEVERE, null, ex);
} finally {
connection.close();
ps.close();
ResultSet.close();
}
return null;
}
JSP
<table border="1">
<tr>
<td>Usuario</td><td>Nivel de Acesso</td><td>Nome Completo</td>
</tr>
<%
List ListaDeUsuarios = (List) request.getAttribute("sessaolistausuarios");
for (Iterator iterator = ListaDeUsuarios.iterator(); iterator.hasNext();) {
Usuarios usuarios = (Usuarios) iterator.next();%>
<tr>
<td><%=usuarios.getUsuario() %></td>
<td><%=usuarios.getNivel()%></td>
<td><%=usuarios.getNomeCompleto() %></td>
</tr>
%>
}
%>
</table>