Re:LocaWeb / Servlet

<form name="form1" id="formulario" method="post" action="/sitecurves/BuscaFranquia">

<display-name>
		BuscaFranquia</display-name>
		<servlet-name>BuscaFranquia</servlet-name>
		<servlet-class>
		br.com.curves.model.BuscaFranquia</servlet-class>
	</servlet>

Servlet[code]
package br.com.curves.model;

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 javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import br.com.curves.dao.BeanFranquia;
import br.com.curves.dao.Conexao;

 public class BuscaFranquia extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		int estado = Integer.parseInt(request.getParameter("estado"));
		
		Connection con;
		List <BeanFranquia> beanFranquias = new ArrayList<BeanFranquia>();
		
		try {

			con = Conexao.abreConexao();
			PreparedStatement stmt = con.prepareStatement("select * from tb_franquia where estado =" + estado);
			ResultSet rs = stmt.executeQuery();
			
			while (rs.next()) {
			
				BeanFranquia franquia = new BeanFranquia();
				
				franquia.setId(Integer.parseInt(rs.getString("id")));	
				franquia.setCidade(rs.getString("cidade"));	
				franquia.setEmail(rs.getString("email"));	
				franquia.setEstado(Integer.parseInt(rs.getString("estado")));
				beanFranquias.add(franquia);
				PrintWriter pw = response.getWriter();
			}
			stmt.close();
			con.close();
			
			request.setAttribute("franquia", beanFranquias);
			request.getRequestDispatcher("semanagratis/formulario.jsp").forward(request, response);
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}