Examples of faireRequete()


Examples of DAO.JDBCTableDAO.faireRequete()

   
      String requete = "update QUESTION_REPONSE set TEXT=\"" + text + "\" , NUM_QR=" + num_qr + " , ID_SITE=" + id_site+"";
      requete = requete + " where NUM_QR=" + num_qrOLD + "";
      System.out.println(requete);
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response)
      return;
    }
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

    tableName=tableName.toUpperCase();
    if(tableName.equals("ABONNEMENT")){
      String num_abonnementOLD = request.getParameter("NUM_ABONNEMENT").toString();
      String requete = "delete from ABONNEMENT where NUM_ABONNEMENT=" + num_abonnementOLD;
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
      return;
    }else if(tableName.equals("JEUX")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

    }else if(tableName.equals("JEUX")){
      String num_jeuOLD = request.getParameter("NUM_JEUX").toString();
      String requete = "delete from JEUX where NUM_JEUX=" + num_jeuOLD;
      System.out.println(requete);
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
      return;
    }else if(tableName.equals("NOTER")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

    }else if(tableName.equals("NOTER")){
      String login = request.getParameter("LOGIN").toString();
      String numjeux = request.getParameter(" NUM_JEUX").toString();
      String requete = "delete from NOTER where LOGIN='" + login + "' AND NUM_JEUX=" + numjeux;
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
      return;
    }else if(tableName.equals("PAGE")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      return;
    }else if(tableName.equals("PAGE")){
      String url = request.getParameter("URL").toString();
      String requete = "delete from PAGE where URL='" + url + "'";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
      return;
    }else if(tableName.equals("SITE")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      return;
    }else if(tableName.equals("SITE")){
      String idsite = request.getParameter("ID_SITE").toString();
      String requete = "delete from SITE where ID_SITE=" + idsite;
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
      return;
    }else if(tableName.equals("UTILISATEUR")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      return;
    }else if(tableName.equals("UTILISATEUR")){
      String login = request.getParameter("LOGIN").toString();
      String requete = "delete from UTILISATEUR where LOGIN='" + login + "'";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response)
      return;
    }else if(tableName.equals("QUESTION_REPONSE")){
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      return;
    }else if(tableName.equals("QUESTION_REPONSE")){
      String num_qr = request.getParameter("NUM_QR").toString();
      String requete = "delete from QUESTION_REPONSE where NUM_QR="+num_qr;
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response)
      return;
    }
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      String code_utilise = request.getParameter(" CODE_UTILISE").toString();
      String date_souscription = request.getParameter(" DATE_SOUSCRIPTION").toString();
      String requete = "insert into ABONNEMENT(NUM_ABONNEMENT,LOGIN,DUREE,CODE_UTILISE,DATE_SOUSCRIPTION)";
      requete = requete + "values ("+ num_abonnement +",'"+ login +"','"+ duree +"','"+ code_utilise +"','"+ date_souscription +"')";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
    }else if(tableName.equals("JEUX")){
      String num_jeu = request.getParameter("NUM_JEUX").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.faireRequete()

      String rates = request.getParameter(" RATES").toString();
      String jeuxdumois = request.getParameter(" JEUX_DU_MOIS").toString();
      String requete = "insert into JEUX(NUM_JEUX,CATEGORIE,NOM,TYPE,DESCRIPTION,CONTEXTE,REGLE,CONTROLS,NUMBEROFPLAY,NUMBEROFRATES,RATES,JEUX_DU_MOIS)";
      requete = requete + "values ("+ num_jeu +",'"+ categorie +"','"+ nom +"','"+ type +"','"+ description +"','"+ contexte +"','"+ regle +"','"+ controls +"',"+ numberofplay +","+ numberofrates +","+ rates +","+ jeuxdumois +")";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
    }else if(tableName.equals("NOTER")){
      String login = request.getParameter("LOGIN").toString();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.