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
   |  
package servlet;
import bean.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.RequestDispatcher;
public class InscriptionServlet extends HttpServlet
{
 PreparedStatement stmt = null;
 ResultSet rs = null;
 RequestDispatcher dispatch = null;
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException
  {
 
  PrintWriter out = response.getWriter();
 String nom = request.getParameter("txtnom");
 String prenom = request.getParameter("txtprenom");
 String mail = request.getParameter("txtemail");
 String pseudo = request.getParameter("txtpseudo");
 String pays = request.getParameter("slpays");
 String pass = request.getParameter("txtpass");
 String confirm = request.getParameter("txtconfpass");
 
  String pilote = "sun.jdbc.odbc.JdbcOdbcDriver";
     try
  {
      Class.forName(pilote);
         java.sql.Connection conn = java.sql.DriverManager.getConnection("jdbc:odbc:MyDataSource");
         String requete="INSERT INTO mb_member (mb_nom,mb_prenom,mb_mail,mb_pseudo,mb_pays,mb_pass,mb_confirm) VALUES (?,?,?,?,?,?,?)";
         stmt = conn.prepareStatement(requete);
         stmt.setString(1, nom);
         stmt.setString(2, prenom);
   stmt.setString(3, mail);
   stmt.setString(4, pseudo);
   stmt.setString(5, pays);
   stmt.setString(5, pass);
   stmt.setString(7, confirm);
   stmt.executeUpdate();
   out.println(" Insertion faite");
     }
     catch(Exception e)
  {
      out.println(" Mauvaise insertion: "+e);
     }
 
  }
} | 
Partager