Examples of faireRequete()

Examples of DAO.JDBCTableDAO.faireRequete()

148
149
150
151
152
153
154
155
156
157
158
   
      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()

44
45
46
47
48
49
50
51
52
53
54
    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()

54
55
56
57
58
59
60
61
62
63
64
    }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()

64
65
66
67
68
69
70
71
72
73
74
    }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()

73
74
75
76
77
78
79
80
81
82
83
      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()

82
83
84
85
86
87
88
89
90
91
92
      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()

91
92
93
94
95
96
97
98
99
100
101
      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()

100
101
102
103
104
105
106
107
108
109
110
      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()

49
50
51
52
53
54
55
56
57
58
59
      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()

69
70
71
72
73
74
75
76
77
78
79
      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.