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 82 83
| <%
<form method="post">
<input type=hidden name=action value="ajouter">
<table>
<TR>
<TD>Nom:</TD>
<TD><INPUT TYPE=TEXT NAME=NOM></TD>
</TR>
<TR>
<TD>Prénom:</TD>
<TD><INPUT TYPE=TEXT NAME=PRENOM></TD>
</TR>
<TR>
<td>Civilité</td>
<td><SELECT NAME="CIVILITE">
<OPTION SELECTED>
<OPTION> Mme
<OPTION> Mlle
<OPTION>Mr
</SELECT>
</td>
</TR>
<TR>
<TD>Adresse:</TD>
<TD><INPUT TYPE=TEXT NAME=ADRESSE></TD>
</TR>
<TR>
<TD>Téléphone:</TD>
<TD><INPUT TYPE=TEXT NAME=PHONE></TD>
</TR>
<TR>
<TD>Pseudo:</TD>
<TD><INPUT TYPE=TEXT NAME=PSEUDO></TD>
</TR>
<TR>
<TD>Mot de passe:</TD>
<TD><INPUT TYPE=PASSWORD NAME=PASS></TD>
</TR>
<TR>
<TD align="center"><INPUT TYPE=RESET VALUE="Annuler"></TD>
<TD><INPUT type=submit value="ajouter"></TD>
</TR>
</table>
</form>
<br><br><br><br><br><br>
<%
String NOM=request.getParameter("NOM");
String PRENOM=request.getParameter("PRENOM");
String CIVILITE=request.getParameter("CIVILITE");
String ADRESSE=request.getParameter("ADRESSE");
String PHONE=request.getParameter("PHONE");
String PSEUDO=request.getParameter("PSEUDO");
String PASS=request.getParameter("PASS");
String action=request.getParameter("action");
String sql="";
try{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/resto";
Connection con=DriverManager.getConnection(url,"root","");
Statement s=con.createStatement();
if(action!=null && action.equals("ajouter")){
sql="INSERT INTO client"+
"(NOM,PRENOM,CIVILITE,ADRESSE,PHONE,PSEUDO,PASS)"+
"VALUES"+
"( '" + NOM + "', "+" '" + PRENOM + "', "+" '" + CIVILITE + "',"+" '" + ADRESSE + "', "+" '" + PHONE + "', "+" '" + PSEUDO + "', "+" '" + PASS + "')";
s.executeUpdate(sql);
out.println("<h3>Inscription reussi</h3>");
}
s.close();
con.close();
}
catch(SQLException e){
}
catch(Exception e){
}
%> |
Partager