public Endereco selectById(long id){
			Endereco end = new Endereco();
			try {
				connection = Conexao.getInstance().obterConexao();
				connection.setAutoCommit(false);
				statement = connection.createStatement();
		 
				resultSet = statement.executeQuery("SELECT * FROM TB_ENDERECO WHERE ID = " + id);
				resultSet.next();
				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"));
		 
			} catch (Exception e) {
				// TODO: handle exception
				try {
					if (connection != null && !connection.isClosed()) {
						connection.rollback();
					}
				} catch (SQLException 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
					}
				}
			}
		 
			System.out.println("SELECT TB_ENDERECO FEITO COM SUCESSO");
			return end;
		 
		}