public void inserir(long pesquisaId, ArrayList<Local> locais) throws Exception
    {
    	String sql = "INSERT INTO pesquisalocal(id1,id2) VALUES (?, ?)";
    	
    	try
    	{
    		PreparedStatement stmt = ConnectionFactory.getConnection().prepareStatement(sql);
    		
	        for (Local local : locais)
	        {
	        	stmt.setLong(1, pesquisaId);
	        	stmt.setLong(2, local.getId());
	        	
	        	stmt.execute();
	        	
	        	stmt.clearParameters();
	        }
        }
        catch (SQLException e)
        {
            throw e;
        }
    }