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 .

Manish kumar · Answer

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 //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 OrderIDOrderDateAmount(select sum(Amount) from CustomerOrders where OrderID 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()); } %>

Akshay Phadke · Answer

Use regex those are best for validation for phonenumberspincode 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