public Passageiro selectById(long id) {
		Passageiro pass = new Passageiro(null);
		try {
			connection = Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();

			resultSet = statement
					.executeQuery("SELECT * FROM TB_AEROPORTO WHERE ID = " + id);
			resultSet.next();
			pass.setId(resultSet.getLong("id"));
			pass.setNome(resultSet.getString("nome"));
			pass.setEndereco(endDAO.selectById(resultSet.getLong("id_endereco")));
			pass.setEmail(resultSet.getString("email"));
			pass.setTelefone(resultSet.getString("telefone"));
			pass.setDataNascimento(resultSet.getDate("data_nasc"));
			pass.setNumeroCartao(resultSet.getString("numero_cartao"));
			pass.setDocumento(resultSet.getString("documento"));

		} 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 COM SUCESSO");
		System.out.println(pass.getId());
		System.out.println(pass.getNome());
		System.out.println(pass.getEndereco().getRua());
		return pass;

	}