imen_amouna
Messages postés1Date d'inscriptionmercredi 25 mars 2015StatutMembreDernière intervention25 mars 2015
-
Modifié par KX le 25/03/2015 à 18:43
bonsoir à tous,
S'il vous plait je suis débutant en jee, j'ai un mini projet avec servlet JSP(vue Ajouter et vue supprimer), Javabeans(Etudiant). Je veux obtenir la connexion dans la méthode init() du servlet. Aprés la recupération des données du formulaire , comment je peux insérer les données dans une base de donnée MYSQL à travers le javabeans. Voici ma servlet
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package trait;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author HP
*/
@WebServlet(name = "myservlet", urlPatterns = {"/myservlet"})
public class myservlet extends HttpServlet {
/**
* Processes requests for both HTTP GET and POST
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
Connection con;
Statement state;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet myservlet</title>");
out.println("</head>");
out.println("<body>");
out.println("<h1>Servlet myservlet at " + request.getContextPath() + "</h1>");
out.println("</body>");
out.println("</html>");
String adresse = request.getParameter("adre");
String mat = request.getParameter("mat");
String nom = request.getParameter("nom");
String prenom = request.getParameter("pren");
Etudiant e =new Etudiant(mat,nom,prenom,adresse);
}
}
@Override
public void init() throws ServletException {
Connexion c = new Connexion();
con = c.ObtenirConnexion();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP GET method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP POST method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}