public List listar() {

		String sql = "SELECT * FROM PEDIDO as r inner join cliente as c on r.idCliente = c.idCliente";
		try {
			conn = GerenciaConexaoBD.getInstance().getConnection();
			PreparedStatement stmt = conn.prepareStatement(sql);
			ResultSet rs = stmt.executeQuery();

			List<Reserva> listarReserva = new ArrayList<Reserva>();

			while (rs.next()) {
				Reserva reserva = new Reserva();
				reserva.setIdReserva(rs.getInt("r.idReserva"));
				reserva.setIdProduto(rs.getInt("r.idProduto"));
				reserva.setIdCliente(rs.getInt("r.idCliente"));
				reserva.setReservaEstado(ReservaFactory.create(rs.getString("r.estadoReserva")));
				reserva.setNomeCliente(rs.getString("c.nome"));
				listarReserva.add(reserva);
			}
			stmt.close();
			return listarReserva;

		} catch (SQLException | ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}