bom dia pessoal tenho a seguinte servlet que deveria mostrar os dados resgatados do db, mas nao está mostrando nada, nem dá erro, apenas fica em branco
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
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 java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Wagner Vielmond
*/
public class pesquisaContrib extends HttpServlet {
@Override
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
//pega a conexao e o statement
Connection con = new ConnectionFactory().getConnection();
PreparedStatement stmt = con.prepareStatement("SELECT * FROM CONTRIBUINTE");
//executa um sql
ResultSet rs = stmt.executeQuery();
List<Contrib> contr = new ArrayList<Contrib>();
while(rs.next()){
Contrib contrib = new Contrib();
contrib.setNome(rs.getString("NOME_CONTRIBUINTE"));
contrib.setRua(rs.getString("FONE"));
contrib.setNumero(rs.getInt("NUMERO"));
//add o objeto à lista
contr.add(contrib);
}
rs.close();
stmt.close();
} catch (SQLException ex) {
Logger.getLogger(pesquisaContrib.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(pesquisaContrib.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
