1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| package ProjetIteration;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.UnavailableException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class RegisterServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
String protocol,nom,prenom,mail;
String userName,password;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response );
}
public void init()
{
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.print("Driver JDBC chargé");
}
catch (ClassNotFoundException e) {
System.out.print(e.toString());
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// obtenir la session, la crée si elle n'existe pas
HttpSession session=request.getSession();
//if (session!=null)
//{
//String mailSe=(String)session.getAttribute("mail");
String logicielSe=(String)session.getAttribute("logiciel");
String systemeSe=(String)session.getAttribute("systeme");
String problemeSe=(String)session.getAttribute("probleme");
nom=request.getParameter("nom");
prenom=request.getParameter("prenom");
mail=request.getParameter("mail");
String pseudo=request.getParameter("pseudo");
String passe=request.getParameter("motPasse");
String confirmPasse=request.getParameter("confirmPasse");
if(passe != confirmPasse && passe == null)
getServletContext().getRequestDispatcher("/ProjetIteration1/register.html").forward(request,response);
try{
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/frontal","root","xav");
System.out.println(" ::: connection obtenue avec succès ::: ");
Statement stat=con.createStatement();
String sql=
"INSERT INTO user (prenom, nom, userName, password, mail)" +
" VALUES ('"+prenom+"','"+nom+"','"+pseudo+"','"+passe+"','"+mail+"');";
//System.out.println(sql);
int i=stat.executeUpdate(sql);
if (i==1){
System.out.println("succes insertion, redirection ::::: ");
RequestDispatcher rd=request.getRequestDispatcher("/ReponseServlet");
rd.forward(request,response);
}
stat.close();
con.close();
}
catch(SQLException e){
String message="Error."+e.toString();
}
//}
}
} |
Partager