public List<Horario> select(){
		List<Horario> horarioLista = new ArrayList<Horario>();
		Horario horario = new Horario(null, null);
		try {
			connection =Conexao.getInstance().obterConexao();
			connection.setAutoCommit(false);
			statement = connection.createStatement();
			statement.executeQuery("SELECT * from TB_HORARIO");
			while (resultSet.next()) {
				horario.setId(resultSet.getLong("id"));
				horario.setAviao(aviaoDAO.selectById(resultSet.getLong("id_aviao")));
				horario.setVoo(vooDAO.selectById(resultSet.getLong("id_voo")));
				horario.setDataPartida(resultSet.getDate("data_partida"));
				horario.setDataChegada(resultSet.getDate("data_chegada"));
				horario.setCodigo(resultSet.getString("codigo"));
				horario.setQtdEconomica(resultSet.getInt("qtd_economica"));
				horario.setQtdPrimeira(resultSet.getInt("qtd_primeira"));
				horario.setQtdExecutiva(resultSet.getInt("qtd_executiva"));
				
				horarioLista.add(horario);
			}
			
		} catch (Exception e) {
			// TODO: handle exception
			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 horarioLista;
	}