public Email Abrir(int id){
        try{
            PreparedStatement comando = banco.getConexao()
                    .prepareStatement("SELECT * FROM emails WHERE id = ? AND ativo = 1");
            comando.setInt(1, id);
            ResultSet consulta = comando.executeQuery();
            comando.getConnection().commit();
            Email tmp = null;
            if(consulta.first()){
                tmp = new Email();
                tmp.setEndereco(consulta.getString("endereco"));
                tmp.setId(consulta.getInt("id"));
                
                
            }
            return tmp;
            
        }catch(SQLException ex){
            ex.printStackTrace();
            return null;
        }catch(ErroValidacaoException ex){
            ex.printStackTrace();
            return null;
        }
     
    
    }