Examples of faireRequete()

Examples of DAO.JDBCTableDAO.faireRequete()

132
133
134
135
136
137
138
139
140
141
142
      String admin = request.getParameter(" ADMINISTRATEUR").toString();
      String requete = "update UTILISATEUR set LOGIN='" + login + "' , MDP='" + mdp + "' , DATE_FIN_ABONNEMENT='" + datefinabo + "' , COMPTE_VALIDER="+ comptevalider + " , EMAIL='" + email + "' , NEWS_LETTER="+ newsletter + " , ADMINISTRATEUR=" + admin;
      requete = requete + " where LOGIN='" + loginOLD + "'";
      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("QUESTION_REPONSE")){
View Full Code Here

Examples of Interface.TableDAOInterface.faireRequete()

50
51
52
53
54
55
56
57
58
59
60
      String code_utilise = request.getParameter(" CODE_UTILISE").toString();
      String date_souscription = request.getParameter(" DATE_SOUSCRIPTION").toString();
      String requete = "update ABONNEMENT set NUM_ABONNEMENT=" + num_abonnement + " , LOGIN='" + login + "' , DUREE=" + duree + " , CODE_UTILISE='"+ code_utilise + "' , DATE_SOUSCRIPTION='" + date_souscription + "'";
      requete = requete + " 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 Interface.TableDAOInterface.faireRequete()

73
74
75
76
77
78
79
80
81
82
83
      String jeuxdumois = request.getParameter(" JEUX_DU_MOIS").toString();
      String requete = "update JEUX set NUM_JEUX=" + num_jeu + " , CATEGORIE='" + categorie + "' , NOM='" + nom + "' , TYPE='"+ type + "' , DESCRIPTION='" + description + "' , CONTEXTE='" + contexte + "' , REGLE='" + regle + "' , CONTROLS='"+ controls + "' , NUMBEROFPLAY=" + numberofplay + " , NUMBEROFRATES=" + numberofrates + " , RATES="+ rates + " , JEUX_DU_MOIS=" + jeuxdumois;
      requete = requete + " where NUM_JEUX=" + num_jeuOLD;
      TableDAOInterface tableDAO = new JDBCTableDAO();
      System.out.println(requete);
      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 Interface.TableDAOInterface.faireRequete()

87
88
89
90
91
92
93
94
95
96
97
      String numjeuxOLD = request.getParameter(" NUM_JEUXOLD").toString();
      String note = request.getParameter(" NOTE").toString();
      String requete = "update NOTER set LOGIN='" + login + "' , NUM_JEUX=" + numjeux + " , NOTE=" + note;
      requete = requete + " where LOGIN='" + loginOLD + "' AND NUM_JEUX=" + numjeuxOLD;
      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 Interface.TableDAOInterface.faireRequete()

101
102
103
104
105
106
107
108
109
110
111
      String header = request.getParameter(" HEADER").toString();
      String footer = request.getParameter(" FOOTER").toString();
      String requete = "update PAGE set URL='" + url + "' , TITRE='" + titre + "' , HEADER='" + header + "' , FOOTER='"+ footer + "'";
      requete = requete + " where URL='" + urlOLD + "'";
      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 Interface.TableDAOInterface.faireRequete()

114
115
116
117
118
119
120
121
122
123
124
      String titre = request.getParameter(" TITRE").toString();
      String description = request.getParameter(" DESCRIPTION").toString();
      String requete = "update SITE set ID_SITE=" + idsite + " , TITRE='" + titre + "' , DESCRIPTION='" + description + "'";
      requete = requete + " where ID_SITE=" + idsiteOLD;
      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 Interface.TableDAOInterface.faireRequete()

132
133
134
135
136
137
138
139
140
141
142
      String admin = request.getParameter(" ADMINISTRATEUR").toString();
      String requete = "update UTILISATEUR set LOGIN='" + login + "' , MDP='" + mdp + "' , DATE_FIN_ABONNEMENT='" + datefinabo + "' , COMPTE_VALIDER="+ comptevalider + " , EMAIL='" + email + "' , NEWS_LETTER="+ newsletter + " , ADMINISTRATEUR=" + admin;
      requete = requete + " where LOGIN='" + loginOLD + "'";
      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("QUESTION_REPONSE")){
View Full Code Here

Examples of Interface.TableDAOInterface.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 Interface.TableDAOInterface.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 Interface.TableDAOInterface.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
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.