public List<Endereco> select(){
		List<Endereco> listaEnd = new ArrayList<Endereco>();
		Endereco end;
		try {
			connection = Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();
			
			resultSet = statement.executeQuery("SELECT * FROM TB_ENDERECO");
			while (resultSet.next()) {
				end = new Endereco();
				end.setId(resultSet.getLong("id"));
				end.setRua(resultSet.getString("rua"));
				end.setNumero(resultSet.getInt("numero"));
				end.setComplemento(resultSet.getString("complemento"));
				end.setBairro(resultSet.getString("bairro"));
				end.setCidade(resultSet.getString("cidade"));
				end.setEstado(resultSet.getString("estado"));
				end.setPais(resultSet.getString("pais"));
				listaEnd.add(end);
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			try {
				if (connection != null && !connection.isClosed()) {
					connection.rollback();
				}
			} catch (Exception e2) {
				// TODO: handle exception
				e2.printStackTrace();
			}finally{
				try {
					if (resultSet != null) {
						resultSet.close();
					}
					if (statement != null) {
						statement.close();
					}
					if (connection != null) {
						connection.close();
					}
				} catch (Exception e3) {
					// TODO: handle exception
				}
			}
		}
		return listaEnd;
	}