Examples of loadDatas()

Examples of DAO.JDBCTableDAO.loadDatas()

70
71
72
73
74
75
76
77
78
79
80
      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();
      String numjeux = request.getParameter(" NUM_JEUX").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

81
82
83
84
85
86
87
88
89
90
91
      String note = request.getParameter(" NOTE").toString();
      String requete = "insert into NOTER(LOGIN,NUM_JEUX,NOTE)";
      requete = requete + "values ('"+ login +"',"+ numjeux +","+ note +")";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
    }else if(tableName.equals("PAGE")){
      String url = request.getParameter("URL").toString();
      String titre = request.getParameter(" TITRE").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

93
94
95
96
97
98
99
100
101
102
103
      String footer = request.getParameter(" FOOTER").toString();
      String requete = "insert into PAGE(URL,TITRE,HEADER,FOOTER)";
      requete = requete + "values ('"+ url +"','"+ titre +"','"+ header +"','"+ footer +"')";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
    }else if(tableName.equals("SITE")){
      String idsite = request.getParameter("ID_SITE").toString();
      String titre = request.getParameter(" TITRE").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

104
105
106
107
108
109
110
111
112
113
114
      String description = request.getParameter(" DESCRIPTION").toString();
      String requete = "insert into SITE(ID_SITE,TITRE,DESCRIPTION)";
      requete = requete + "values ("+ idsite +",'"+ titre +"','"+ description +"')";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response);
    }else if(tableName.equals("UTILISATEUR")){
      String login = request.getParameter("LOGIN").toString();
      String mdp = request.getParameter(" MDP").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

119
120
121
122
123
124
125
126
127
128
129
      String admin = request.getParameter(" ADMINISTRATEUR").toString();
      String requete = "insert into UTILISATEUR(LOGIN,MDP,DATE_FIN_ABONNEMENT,COMPTE_VALIDER,EMAIL,NEWS_LETTER,ADMINISTRATEUR)";
      requete = requete + "values ('"+ login +"','"+ mdp +"','"+ datefinabo +"',"+ comptevalider +",'"+ email +"',"+ newsletter +","+ admin +")";
      TableDAOInterface tableDAO = new JDBCTableDAO();
      tableDAO.faireRequete(requete);
      tableDAO.loadDatas();
      updateSite();
      request.getRequestDispatcher("administration.jsp").forward(request, response); 
    }else if(tableName.equals("QUESTION_REPONSE")){
      String num_qr = request.getParameter("NUM_QR").toString();
      String id_site = request.getParameter(" ID_SITE").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

131
132
133
134
135
136
137
138
139
140
141
      String requete = "insert into QUESTION_REPONSE(TEXT,NUM_QR,ID_SITE) values (TEXT=\"" + text + "\", NUM_QR=" + num_qr + ", ID_SITE=" + id_site+")";
      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.loadDatas()

51
52
53
54
55
56
57
58
59
60
61
      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")){
      String num_jeu = request.getParameter("NUM_JEUX").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

74
75
76
77
78
79
80
81
82
83
84
      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")){
      String login = request.getParameter("LOGIN").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

88
89
90
91
92
93
94
95
96
97
98
      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")){
      String url = request.getParameter("URL").toString();
View Full Code Here

Examples of DAO.JDBCTableDAO.loadDatas()

102
103
104
105
106
107
108
109
110
111
112
      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")){
      String idsite = request.getParameter("ID_SITE").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.