示例#1
0
文件: Vues.java 项目: T4g1/3eme
  public static String payement(HttpServletRequest request, HttpServletResponse response) {
    String html = "";
    try {
      // Ouvre la BDD
      BeanDBAccessORA dba = (BeanDBAccessORA) Beans.instantiate(null, "Bean.BeanDBAccessORA");

      if (dba.init()) {

        int session = 0;
        session = Integer.parseInt(request.getAttribute("session").toString());
        ResultSet result = dba.getcaddie(session);

        if (request.getParameter("action").equals("payer")) {
          dba.Paycaddie(session, 1);
          html += "paiement réussis !!!";
        } else {
          dba.Paycaddie(session, 0);
          html += "Annulation acceptée :( ";
        }

      } else {
        html = "dba.init() error";
      }
    } catch (SQLException ex) {
      html += "SQLException: " + ex.getMessage();
    } catch (IOException ex) {
      html += "IOException: " + ex.getMessage();
    } catch (ClassNotFoundException ex) {
      html += "ClassNotFoundException: " + ex.getMessage();
    }

    return html;
  }
示例#2
0
文件: Vues.java 项目: T4g1/3eme
  /**
   * Donne le code HTML du contenu du caddie donné
   *
   * @param caddie Caddie voulu
   * @return Code HTML du contenu
   */
  public static String getCaddieContent(HttpServletRequest request, HttpServletResponse response) {
    int session = 0;
    session = Integer.parseInt(request.getAttribute("session").toString());
    String html =
        "<table border=1px>\n"
            + "    <tr>\n"
            + "        <th>salle</th>\n"
            + "        <th>sceance</th>\n"
            + "        <th>film</th>\n"
            + "        <th>date</th>\n"
            + "        <th>nombre de place</th>\n"
            + "    </tr>";

    try {
      // Ouvre la BDD
      BeanDBAccessORA dba = (BeanDBAccessORA) Beans.instantiate(null, "Bean.BeanDBAccessORA");

      if (dba.init()) {

        ResultSet result = dba.getcaddie(session);

        // Parcourt le caddie
        if (result != null) {
          while (result.next()) {
            html += "<tr>";
            html += "<td>" + result.getInt("idsalle") + "</td>";
            html += "<td>" + getHeureSceances(result.getInt("numsceance")) + "</td>";
            html += "<td>" + result.getString("titre") + "</td>";
            html += "<td>" + result.getString("datejour") + "</td>";
            html += "<td align=\"center\">" + result.getInt("nbplace") + "</td>";
            html += "</tr>";
          }
        }

      } else {
        html = "dba.init() error";
      }
    } catch (SQLException ex) {
      html = "SQLException: " + ex.getMessage();
    } catch (IOException ex) {
      html = "IOException: " + ex.getMessage();
    } catch (ClassNotFoundException ex) {
      html = "ClassNotFoundException: " + ex.getMessage();
    }

    html += "</table>";
    html += "<a href=\"Search?action=payer&id=" + session + " \">Payer</a>  ";
    html += "<a href=\"Search?action=annuler&id=" + session + "\">Annuler</a>";
    return html;
  }
示例#3
0
文件: Vues.java 项目: T4g1/3eme
  /**
   * retourne toutes les infos sur un film
   *
   * @param request
   * @param response
   * @return
   */
  public static String getFilmInfo(HttpServletRequest request, HttpServletResponse response) {
    int i = -1;
    String html = "";
    Blob image = null;
    byte[] imgData = null;
    // SearchSignaletique(ident films.idfilm%type)
    try {
      // Ouvre la BDD
      BeanDBAccessORA dba = (BeanDBAccessORA) Beans.instantiate(null, "Bean.BeanDBAccessORA");

      if (dba.init()) {
        String param = request.getParameter("id");
        int idfilm = Integer.parseInt(param);

        ResultSet result = dba.SearchSignaletique(idfilm);
        // ResultSet result = array.getResultSet();
        if (result == null) html += "Aucun résultat trouvé<br/>";
        int count = 0;
        while (result.next()) {
          if (count == 0) {
            html += "<p>Titre: " + result.getString("Titre") + "</p>";
            html += "<p>Durée: " + result.getString("Duree") + "</p>";
            html += "<p>Cote: " + result.getString("Cote") + "</p>";
            html += "<p>Date de sortie: " + result.getString("Datesortie") + "</p>";
            html += "<p>Tagline: " + result.getString("Tagline") + "</p>";
            html += "<p>Votes: " + result.getString("Votes") + "</p>";
            // récupération de l'image
            final String path = "..\\webapps\\Web_Applic_Reservations\\" + idfilm + ".jpg";

            InputStream instream = result.getBlob("POSTER").getBinaryStream();
            BufferedInputStream bis = new BufferedInputStream(instream);

            if (!new File(path).exists()) {
              FileOutputStream fos = new FileOutputStream(path);
              BufferedOutputStream bos = new BufferedOutputStream(fos);
              IOUtils.copy(bis, bos);
              bos.close();
            }
            // html += "<p>Affiche: <img
            // src=\"D:\\Serveur\\apache-tomcat-7.0.33-windows-x64\\apache-tomcat-7.0.33\\bin\\75.jpg\" /></p>";
            html += "<p>current dir:" + System.getProperty("user.dir") + " </p>";
            html += "<p>Affiche: <img src=\"./" + idfilm + ".jpg\" width=200 height=300/></p>";
            html += "<p>Producteur: " + result.getString("Producteur") + "</p>";
            html += "<p>Certification: " + result.getString("Certification") + "</p>";
            html += "<p>Acteurs: </p>";
          } else {
            html += "<dd>" + result.getString("acteur") + "</br>";
          }
          count++;
        }
      } else {
        html = "dba.init() error2<br/>";
      }
    } catch (NumberFormatException ex) {
      html += "NumberFormatException: " + ex.getMessage();
    } catch (SQLException ex) {
      html += "SQLException: " + ex.getMessage();
    } catch (IOException ex) {
      html += "IOException: " + ex.getMessage();
    } catch (ClassNotFoundException ex) {
      html += "ClassNotFoundException: " + ex.getMessage();
    } catch (NullPointerException ex) {
      html += "nullPointerException: " + ex.getMessage();
    }

    return html;
  }
示例#4
0
文件: Vues.java 项目: T4g1/3eme
  /**
   * Donne la liste des produits disponnible
   *
   * @return Code HTML du listing
   */
  public static String getListing(HttpServletRequest request, HttpServletResponse response) {
    String requete = "";
    int i = -1;
    String html =
        "<table border='1' id=\"tablepaging\" class=\"yui\" align=\"center\">"
            + "    <thead>"
            + "    <tr>\n"
            + "        <th>Date</th>"
            + "        <th>Salle</th>"
            + "        <th>Sceances</th>"
            + "        <th>Places restantes</th>"
            + "        <th>Titre</th>"
            + "        <th>détails</th>"
            + "        <th>nombre de place</th>"
            + "        <th>commander</th>"
            + "    </tr>"
            + "    <thread/>";
    String criteres = request.getParameter("criteres");

    if (criteres.equals("sceances")) {
      String titre = null;
      if (!request.getParameter("titre").equals("na")) titre = request.getParameter("titre");
      String heure = null;
      int iheure = -1;
      if (!request.getParameter("heure").equals("na")) {
        heure = request.getParameter("heure");
        iheure = Integer.parseInt(heure);
      }

      String placemin = null;
      int iplacemin = -1;
      if (!request.getParameter("placemin").equals("na")) {
        placemin = request.getParameter("placemin");
        iplacemin = Integer.parseInt(placemin);
      }

      String placemax = null;
      int iplacemax = -1;
      if (!request.getParameter("placemax").equals("na")) {
        placemax = request.getParameter("placemax");
        iplacemax = Integer.parseInt(placemax);
      }

      // on crée l'objet en passant en paramétre une chaîne representant le format
      SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
      // récupération de la date courante
      java.util.Date currentTime_1 = new java.util.Date();
      // on crée la chaîne à partir de la date
      String dateinf = formatter.format(currentTime_1);
      if (!request.getParameter("dateinf").equals("na")) {
        dateinf = request.getParameter("dateinf");
      }

      // on crée l'objet en passant en paramétre une chaîne representant le format
      SimpleDateFormat formatter2 = new SimpleDateFormat("dd/MM/yyyy");
      // récupération de la date courante
      java.util.Date currentTime_2 = new java.util.Date();
      // on crée la chaîne à partir de la date
      String datesup = formatter2.format(currentTime_2);
      String dt = datesup; // Start date
      SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
      Calendar c = Calendar.getInstance();
      try {
        c.setTime(sdf.parse(dt));
      } catch (ParseException ex) {
        Logger.getLogger(Vues.class.getName()).log(Level.SEVERE, null, ex);
      }
      c.add(Calendar.DATE, 7);
      datesup = sdf.format(c.getTime());

      if (!request.getParameter("datesup").equals("na")) {
        datesup = request.getParameter("datesup");
      }

      try {
        // Ouvre la BDD
        BeanDBAccessORA dba = (BeanDBAccessORA) Beans.instantiate(null, "Bean.BeanDBAccessORA");

        if (dba.init()) {
          // METTRE BOUCLE
          do {
            // Sélectionne les chambres non réservées
            // ResultSet result = dba.executeQuery(requete);

            ResultSet result = dba.SearchSceances(titre, iheure, iplacemin, iplacemax, dateinf);
            // ResultSet result = array.getResultSet();
            if (result == null) html += "Aucun résultat trouvé<br/>";
            int couleur = 0;
            while (result.next()) {
              if (couleur % 2 == 0) html += "<tr class=\"even\">";
              else html += "<tr class=\"odd\">";

              html += "<td>" + dateinf + "</td>";
              html += "<td>" + result.getInt("idsalle") + "</td>";
              html += "<td>" + getHeureSceances(result.getInt("numsceance")) + "</td>";
              html += "<td>" + result.getInt("placerestantes") + "</td>";
              html += "<td>" + result.getString("titre") + "</td>";
              html +=
                  "<td><a href=\"Search?action=details&id="
                      + result.getInt("idfilm")
                      + "\">détails</a></td>";
              html +=
                  "<td><a href=\"Search?action=commander&id="
                      + result.getInt("idfilm")
                      + "&sceance="
                      + result.getInt("numsceance")
                      + "&salle="
                      + result.getInt("idsalle")
                      + "&datejour="
                      + dateinf
                      + "\">Commander"
                      + "</td>";
              html += "</tr>";
            }
            i++;
            // mise à jour de la date
            String dt2 = dateinf; // Start date
            SimpleDateFormat sdf2 = new SimpleDateFormat("dd/MM/yyyy");
            Calendar c2 = Calendar.getInstance();
            c.setTime(sdf.parse(dt2));
            c.add(Calendar.DATE, 1);
            dateinf = sdf.format(c.getTime());

          } while (!dateinf.equals(datesup));

        } else {
          html = "dba.init() error2<br/>";
        }
      } catch (ParseException ex) {
        html += "ParseException: " + ex.getMessage();
      } catch (SQLException ex) {
        html += "SQLException: " + ex.getMessage();
      } catch (IOException ex) {
        html += "IOException: " + ex.getMessage();
      } catch (ClassNotFoundException ex) {
        html += "ClassNotFoundException: " + ex.getMessage();
      } catch (NullPointerException ex) {
        html += "nullPointerException: " + ex.getMessage();
      }
      html += "</table>";
    }
    return html;
  }