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
| <%
String echeance=request.getParameter("echeance");
String Ncompte=request.getParameter("Ncompte");
String nompre=request.getParameter("nompre");
String banque=request.getParameter("banque");
int debit=request.getParameter("debit");
String piece=request.getParameter("piece");
String daterej=request.getParameter("daterej");
String dateencais=request.getParameter("dateencais");
int credit=request.getParameter("credit");
String moypay=request.getParameter("moypay");
String observation=request.getParameter("observation");
Connection connection=null;
java.sql.Date maDate = testParseDate(request.getParameter("echeance"));
java.sql.Date maDate1 = testParseDate(request.getParameter("daterej"));
java.sql.Date maDate2 = testParseDate(request.getParameter("dateencais"));
if ((Ncompte!="")){
try
{
Class.forName("com.mysql.jdbc.Driver");
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/banque","root","");
PreparedStatement pstmt = connection.prepareStatement("INSERT INTO utilisateur(echeance, Ncompte, nompre, banque, debit, piece, daterej, dateencais, credit, moypay, observation) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
pstmt.setDate(1,maDate);
pstmt.setString(2,Ncompte);
pstmt.setString(3,nompre);
pstmt.setString(4,banque);
pstmt.setInt(5,debit);
pstmt.setString(6,piece);
pstmt.setDate(7,maDate1);
pstmt.setDate(8,maDate2);
pstmt.setInt(9, credit);
pstmt.setString(10,moypay);
pstmt.setString(11,observation);
pstmt.execute();
response.sendRedirect("client.jsp");
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
connection.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
%> |
Partager