package Servlet;
import java.io.IOException;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import DAO.JDBCGameDAO;
import DAO.JDBCSiteDAO;
import DAO.JDBCTableDAO;
import DAO.JDBCUserDAO;
import Interface.GameDAOInterface;
import Interface.SiteDAOInterface;
import Interface.TableDAOInterface;
import Interface.UserDAOInterface;
import beans.Faq;
import beans.ListOfGames;
import beans.QuestionReponse;
import beans.SiteInfo;
import beans.User;
/**
* Servlet implementation class UpdateLigne
*/
public class UpdateLigne extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UpdateLigne() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String tableName = request.getParameter("table").toString();
tableName=tableName.toUpperCase();
if(tableName.equals("ABONNEMENT")){
String num_abonnement = request.getParameter("NUM_ABONNEMENT").toString();
String num_abonnementOLD = request.getParameter("NUM_ABONNEMENTOLD").toString();
String login = request.getParameter(" LOGIN").toString();
String duree = request.getParameter(" DUREE").toString();
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")){
String num_jeu = request.getParameter("NUM_JEUX").toString();
String num_jeuOLD = request.getParameter("NUM_JEUXOLD").toString();
String categorie = request.getParameter(" CATEGORIE").toString();
String nom = request.getParameter(" NOM").toString();
String type = request.getParameter(" TYPE").toString();
String description = request.getParameter(" DESCRIPTION").toString();
String contexte = request.getParameter(" CONTEXTE").toString();
String regle = request.getParameter(" REGLE").toString();
String controls = request.getParameter(" CONTROLS").toString();
String numberofplay = request.getParameter(" NUMBEROFPLAY").toString();
String numberofrates = request.getParameter(" NUMBEROFRATES").toString();
String rates = request.getParameter(" RATES").toString();
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")){
String login = request.getParameter("LOGIN").toString();
String loginOLD = request.getParameter("LOGINOLD").toString();
String numjeux = request.getParameter(" NUM_JEUX").toString();
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")){
String url = request.getParameter("URL").toString();
String urlOLD = request.getParameter("URLOLD").toString();
String titre = request.getParameter(" TITRE").toString();
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")){
String idsite = request.getParameter("ID_SITE").toString();
String idsiteOLD = request.getParameter("ID_SITEOLD").toString();
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")){
String login = request.getParameter("LOGIN").toString();
String loginOLD = request.getParameter("LOGINOLD").toString();
String mdp = request.getParameter(" MDP").toString();
String datefinabo = request.getParameter(" DATE_FIN_ABONNEMENT").toString();
String comptevalider = request.getParameter(" COMPTE_VALIDER").toString();
String email = request.getParameter(" EMAIL").toString();
String newsletter = request.getParameter(" NEWS_LETTER").toString();
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")){
String num_qr = request.getParameter("NUM_QR").toString();
String num_qrOLD = request.getParameter("NUM_QROLD").toString();
String id_site = request.getParameter(" ID_SITE").toString();
String id_siteOLD = request.getParameter(" ID_SITEOLD").toString();
String text = request.getParameter(" TEXT").toString();
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;
}
}
public void updateSite(){
SiteDAOInterface site = new JDBCSiteDAO();
ServletContext context = getServletContext();
site.loadFAQ();
site.loadListOfGames();
site.loadSiteInfo();
context.setAttribute("listOfGames", ListOfGames.getListOfGames());
context.setAttribute("siteTitre", SiteInfo.getTitre());
context.setAttribute("siteDescription", SiteInfo.getDescription());
context.setAttribute("faq",Faq.getFaq());
GameDAOInterface game = new JDBCGameDAO();
context.setAttribute("gameOfTheMonth", game.getGameOfTheMonth());
}
}