public ArrayList<Local> listar(long pesquisaId) throws Exception
    {
    	String sql = "SELECT * FROM pesquisalocal WHERE id1 = ?";
        ArrayList<Local> listaLocal = new ArrayList<Local>();
        
        if (pesquisaId > 0)
        {
            try
            {
            	PreparedStatement stmt = ConnectionFactory.getConnection().prepareStatement(sql);
            	stmt.setLong(1, pesquisaId);
                ResultSet rs = stmt.executeQuery();
                LocalDAO ldao = new LocalDAO();
                
                while (rs.next())
                {
                    Local local = ldao.listar(" WHERE id = " + rs.getLong("id2")).get(0);
                    listaLocal.add(local);
                }
                
                rs.close();
            }
            catch (SQLException e)
            {
                throw e;
            }
        }
        
        return listaLocal;
    }