Aqui está minha jsp de pesquisa:
pesquisa.jsp
<html>
<head>Pesquisa</head>
<body>
<form method="POST" name="incluir" id="incluir" action="/Water_Fast/pesquisa">
Nome: <input type="text" name="pesquisa" id="pesquisa">
<input type="submit" name="gravar" value="gravar">
</form>
</body>
</html>
Minha Servlet
servlet.java
package Controller;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Model.Banco;
import Model.Funcionario;
public class Servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public Servlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
Funcionario testeCons = new Funcionario();
Banco BD = new Banco();
String result = request.getParameter("pesquisa");
System.out.println("teste"+result);
ArrayList<Funcionario> relacaoFunc = BD.ConsulFunc(result);
request.setAttribute("listaFunc", relacaoFunc);
request.getRequestDispatcher("alterar.jsp").forward(request, response);
} catch (ClassNotFoundException e) {
System.out.println("Classe não encontrada"+e);
} catch (SQLException e) {
System.out.println("Problemas com o BD"+e);
}
}
}
A jsp que vai trazer os resultados
alterar.jsp:
<%@page import="java.util.ArrayList" %>
<%@page import="model.Funcionario" %>
<html>
<head>Consulta</head>
<% ArrayList<Funcionario> relacaoFunc = (ArrayList<Funcionario>) request.getAttribute("listaFunc");%>
<body>
<form method="GET" name="alterar" id="alterar" action="/Projeto/altera">
<table>
<% for (int i=0; i<relacaoFunc.size();i++){ %>
<tr>
<td>
<%=relacaoFunc.get(i).getNome() %>
</td>
</tr>
<%}%>
</table>
</form>
</body>
</html>
E minha segunda servlet
servlet2.java
package Controller;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Model.*;
public class Servlet2 extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Banco consFunc = new Banco();
try {
ArrayList<Funcionario> relacaoFunc = consFunc.consultaFunc();
System.out.println(relacaoFunc.size());
request.setAttribute("listaFunc", relacaoFunc);
request.getRequestDispatcher("alterar.jsp").forward(request, response);
} catch (ClassNotFoundException e) {
System.out.println("Classe não encontrada"+e);
} catch (SQLException e) {
System.out.println("Problemas com o BD"+e);
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
