Validation Issues & Image submission In JSP project.

Question

I am new to jsp and I am trying to make an apllication form in jsp which saves the details of the member in the mysql . Connectivity part is done it is taking in the details and saving them to mysql DB , issue is that few columns like pincode , mobile number & fax  ,validation is not working with them .

Please suggest me how to add validation to these columns .

Also I am trying to save the image of the applicant but it takes the image as an attachment and when I try to fetch the data from DB it only shows the attachment not the image .

Answer 1

can any body solve this SQL code running total, it is not working  MS ACCESS Database?

 

ID-OrderID-OrderDate-Amount-Running_Total

1-1-11/11/2016-120-120
2-2-11/11/2016-40-160
3-3-11/11/2016-30-190

4-4-11/11/2016-80-270

 

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<%
//java Code 25/11/2016

try
{
String date = (new java.util.Date()).toString();
String OrderDate=request.getParameter("OrderDate");


int OrderID = Integer.parseInt(request.getParameter("OrderID"));
int Amount = Integer.parseInt(request.getParameter("Amount"));
int Running_Total=Integer.parseInt(request.getParameter("Running_Total"));

String sql_debit="select OrderID,OrderDate,Amount,(select sum(Amount) from CustomerOrders where OrderID <= OrderID)'Running_Total' from CustomerOrders";
String s="jdbc:odbc:Database2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(s);
Statement pstmt=conn.createStatement();
Calendar calendar = Calendar.getInstance();
java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());

ResultSet result = pstmt.executeQuery(sql_debit);
//int count = 0;
while (result.next())
{
//result.getInt("Running_Total");
Running_Total = result.getInt(1);
//result.getInt(1);
String output = "User #%d: %s ";
System.out.println(String.format(output, Running_Total));
}
conn.close();
}
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
%>

</body>
</html> 

Answer 2

Use regex those are best for validation for phonenumbers,pincode and so on

http://stackoverflow.com/questions/28716539/how-to-validate-pin-code-mobile-number-and-email-in-javascript

For saving and rerieving images

http://stackoverflow.com/questions/21452418/source-code-to-store-image-into-mysql-database-and-retrieve-it-and-display-in-js