I'm sending the two jsp pages.
first page
<%@ page import="java.util.Date, java.sql.*, java.util.*" %>
<%@ page contentType="text/html; charset=iso-8859-7" %>
<html>
<head>
<title>New User -- Registration</title>
</head>
<body>
<Table width="140%">
<TR>
<TD> <img src="/images/logo.JPG" width="217" height="117"> </TD>
</Table>
<hr align="center" width="100%" size="7" noshade color="Red">
<Form method="post" name="form" action = "Validation.jsp">
<H3 align="center" color="red">Please Fill All Fields With * Besides Them </H3>
<Table width="20%">
<TR> <TD>Όνομα</TD> <TD> <input type="text" name="FName" size="20"> </TD> <TD>*</TD> </TR>
<TR> <TD>Επώνυμο</TD> <TD> <input type="text" name="LName" size="20"> </TD> <TD>*</TD> </TR>
<TR> <TD>Διεύθυνση</TD> <TD> <input type="text" name="Address" size="20"> </TD> <TD>*</TD> </TR>
<TR> <TD>Χώρα</TD> <TD> <input type="text" name="Country" size="20"> </TD> <TD>*</TD> </TR>
<TR> <TD>Περιοχή</TD> <TD> <input type="text" name="City" size="20"> </TD> </TR>
<TR> <TD>Τηλέφωνο</TD> <TD> <input type="text" name="Telephone" size="20"> </TD> <TD>*</TD> </TR>
<TR> <TD>E-Mail</TD> <TD> <input type="text" name="e_mail" size="20"> </TD> <TD>*</TD> </TR>
<TR>
<TD> <input type="Submit" name="Submit" value="Submit"> </TD>
<TD> <input type="Reset" name="Clear" value="Clear"> </TD>
</TR>
</Table>
</Form>
</Body>
</HTML>
second page
<%@ page import="java.util.Date, java.sql.*, java.util.*" %>
<%@ page contentType="text/html; charset=iso-8859-7" %>
<html>
<head>
<title>New User -- Validation</title>
</head>
<body>
<%
String FName = request.getParameter("FName");
String LName = request.getParameter("LName");
String Address = request.getParameter("Address");
String Country = request.getParameter("Country");
String City = request.getParameter("City");
String Telephone = request.getParameter("Telephone");
String e_mail = request.getParameter("e_mail");
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/e_store");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT @max_CuID := MAX(Customer_ID) FROM Customers;");
String flag;
if ((FName == " ") | (LName == " ") | (Address == " ") | (Country == " ") | (Telephone == " ") | (e_mail == " "))
flag = "f";
else
flag = "t";
while (rs.next())
{
String m = rs.getString(1);
}
if (flag == "f")
response.sendRedirect("NSuccess.jsp");
else
{
stmt.executeUpdate("Insert into Customers (Customer_ID,FName,LName,Address,Country,City,Telephone,e_mail) " +
"Values('m +1',FName,LName,Address,Country,
City,Telephone,'he_mail');");
stmt.close();
con.close();
response.sendRedirect("Success.jsp");
}
rs.close();
stmt.close();
%>
</Body>
</HTML>
The parameters take the values but the sql statement doesn't.Maybe i am doing something wrong.
