import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import beans.com.opentour.*;
import java.sql.*;

public class TesteServlet extends HttpServlet {
	
	public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		ConnectionBean con = new ConnectionBean();
		res.setContentType("text/html");
		PrintWriter out = res.getWriter();
		try	{
			ResultSet rs = con.executeQuery("Select * from associados");
			while (rs.next()) {
				out.println(rs.getString("nomeassociado") + "<br>");
			}
		}
		catch (SQLException e) {
			out.println("Erro de SQL:" + e.getMessage());
		}

	}

}