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);
}
}
} |
