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