index.html page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>User Registration form</title>
</head>
<body>
<form action="registration.jsp" method="post">
<table align="center" width="70%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="19%">User Name</td>
<td width="10%">:</td>
<td width="71%"><input type="text" name="user_name" />
</td>
</tr>
<tr>
<td>User ID </td>
<td>:</td>
<td><input type="text" name="user_id" /></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="pswd"/></td>
</tr>
<tr>
<td>Mobile</td>
<td>:</td>
<td><input type="text" name="mobile" /></td>
</tr>
<tr>
<td>Email-id</td>
<td>:</td>
<td><input type="text" name="email_id" /></td>
</tr>
<tr>
<td>Address</td>
<td>:</td>
<td><input type="textarea" name="address" /></td>
</tr>
<tr>
<td>Date Of Birth </td>
<td>:</td>
<td><input type="text" name="dob" /></td>
</tr>
<tr>
<td>Marks in 10th</td>
<td>:</td>
<td><input type="text" name="marks10th" /></td>
</tr>
<tr>
<td>Marks in 12th</td>
<td>:</td>
<td><input type="text" name="marks12th" /></td>
</tr>
<tr>
<td>Marks in Graduation</td>
<td>:</td>
<td><input type="text" name="marksgraduation" /></td>
</tr>
<tr>
<td>Marks in Post Graduation</td>
<td>:</td>
<td><input type="text" name="markspg" /></td>
</tr>
<tr>
<td>Other Certification</td>
<td>:</td>
<td><input type="text" name="othercertification" /></td>
</tr>
<tr>
<td>Experience</td>
<td>:</td>
<td><input type="text" name="experience" /></td>
</tr><br/>
<tr >
<td></td>
<td ><br />
<input type="submit" value="Submit" /></td>
</tr>
</table>
</form>
</body>
</html>
registration.jsp page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >
<html>
<body>
<%@page language="java"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%!
Connection con;
PreparedStatement pstmt;
//Statement stmt;
//ResultSet res;
String url,user_name,email,address,date_of_birth,other_ce rtification,user_id,password;
int marks_10,marks_12,marks_ug,marks_pg,experience;
int mobile;
%>
<%
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
url = "jdbc:odbc:attendance";
con = DriverManager.getConnection(url);
user_name = request.getParameter("user_name");
email = request.getParameter("email_id");
address = request.getParameter("address");
date_of_birth = request.getParameter("dob");
other_certification = request.getParameter("othercertification");
user_id = request.getParameter("user_id");
password = request.getParameter("pswd");
mobile = Integer.parseInt(request.getParameter("mobile"));
marks_10 = Integer.parseInt(request.getParameter("marks10th") );
marks_12 = Integer.parseInt(request.getParameter("marks12th") );
marks_ug = Integer.parseInt(request.getParameter("marksgradua tion"));
marks_pg = Integer.parseInt(request.getParameter("markspg"));
experience = Integer.parseInt(request.getParameter("experience" ));
//stmt= con.createStatement();
//res = pstmt.executeQuery("select id from registration");
//sid = Integer.parseInt(res.getInt(id));
pstmt = con.prepareStatement("insert into registration(user_name,mobile,email,address,date_o f_birth,marks_10th,marks_12th,marks_ug,marks_pg,ot her_certification,experience,user_id,password) values(?,?,?,?,?,?,?,?,?,?,?,?,?)");
//res.setInt(1,sid);
pstmt.setString(1,user_name);
pstmt.setInt(2,mobile);
pstmt.setString(3,email);
pstmt.setString(4,address);
pstmt.setString(5,date_of_birth);
pstmt.setInt(6,marks_10);
pstmt.setInt(7,marks_12);
pstmt.setInt(8,marks_ug);
pstmt.setInt(9,marks_pg);
pstmt.setString(10,other_certification);
pstmt.setInt(11,experience);
pstmt.setString(12,user_id);
pstmt.setString(13,password);
pstmt.executeUpdate();
con.close();
%>
</body>
</html>
and the error is:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: For input string: ""
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
root cause
java.lang.NumberFormatException: For input string: ""
java.lang.NumberFormatException.forInputString(Unk nown Source)
java.lang.Integer.parseInt(Unknown Source)
java.lang.Integer.parseInt(Unknown Source)
org.apache.jsp.registration_jsp._jspService(regist ration_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.16