public List<Voo> select(){
		List<Voo> vooLista = new ArrayList<Voo>();
		Voo voo;
		try {
			connection =Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();
			resultSet = statement.executeQuery("SELECT * FROM TB_VOO");
			while (resultSet.next()) {
				voo = new Voo(	ciaAereaDAO.selectById(resultSet.getLong("id_cia_aerea")), 
								aeroportoDAO.selectById(resultSet.getLong("id_embarque")), 
								aeroportoDAO.selectById(resultSet.getLong("id_desembarque")));
				
				voo.setId(resultSet.getLong("id"));
				voo.setNome(resultSet.getString("nome"));
				voo.setDescricao(resultSet.getString("descricao"));
				
				vooLista.add(voo);
			}
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			try {
				if (connection != null && !connection.isClosed()) {
					connection.rollback();
				}
			} catch (SQLException e2) {
				e2.printStackTrace();
			}
		}finally {
			try {
				if (resultSet != null) {
					resultSet.close();
				}
				if (statement != null) {
					statement.close();
				}
				if (connection != null) {
					connection.close();
				}
			} catch (SQLException e) {
				// Nada a fazer
			}

		}
		return vooLista;
	}