connecting through jsp
iam getting a below error while connecting to the database
here iam using Tomcat
<%@ page language="java" import="java.sql.*" %>
<%
Connection con=null;
ResultSet rst=null;
Statement stmt=null;
String driver ="sun.jdbc.odbc.JdbcOdbcDriver";
try
{
Class.forName(driver).newInstance();
con=DriverManager.getConnection("jdbc:odbc:sample","sa","pwd");
stmt=con.createStatement();
}
catch(Exception e){
System.out.println(e.getMessage());
}
if(request.getParameter("action") !=null){
String name=request.getParameter("name");
String pno=request.getParameter("pno");
String age=request.getParameter("age");
stmt.executeUpdate("insert into pur(name,pno,age) values('"+name+"','"+pno+"','"+age+"')");
rst=stmt.executeQuery("select * from pur");
}
%>
<html>
<body>
<center><h2>PURCHASE</h2>
<table border="1" cellspacing="0" cellpadding="0">
<tr><td><b>Name</b></td><td><b>pno</b></td></td><td><b>age</b></td></tr>
<%
int no=1;
System.out.print("while");
while(rst.next()){
%>
</td><td>
<%=rst.getString("name")%>
</td><td>
<%=rst.getString("pno")%>
</td></tr>
</td><td>
<%=rst.getString("age")%>
</td></tr>
<%
no++;
}
rst.close();
stmt.close();
con.close();
<%}else{%>
<tr>
</table>
</center>
</body>
</html>
<html>
<head>
<title>Book Entry FormDocument</title>
<script language="javascript">
function validate(objForm){
if(objForm.name.value.length==0){
alert("Please enter Name!");
objForm.name.focus();
returnfalse;
}
if(objForm.pno.value.length==0){
alert("Please enter pno!");
objForm.pno.focus();
returnfalse;
}
if(objForm.age.value.length==0){
alert("Please enter age!");
objForm.age.focus();
returnfalse;
}
returntrue;
}
</script>
</head>
<body><center>
<form action="BookEntryForm.jsp" method="post" name="entry" onSubmit="return validate(this)">
<input type="hidden" value="list" name="action">
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td>
<table>
<tr><td colspan="2" align="center"><h2>Book Entry Form</h2></td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td> Name:</td><td><input name="name" type="text" size="50"></td></tr>
<tr><td>pno:</td><td><input name="pno" type="text" size="50"></td></tr>
<tr><td>age:</td><td><input name="age" type="text" size="50"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="Submit"></td></tr>
</table>
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
<%}%>
HTTP Status 500 -
--
type Exception report
message
description The server encountered an internal error () that prevented it from fulfillingthis request.
exception
org.apache.jasper.JasperException: Unable to compileclassfor JSP:
An error occurred at line: 64 in the jsp file: /rajkumar/BookEntryForm.jsp
Syntax error on tokens, delete these tokens
61: con.close();
62:
63:
64: <%}else{%>
65:
66:
67: <tr>
An error occurred at line: 125 in the jsp file: /rajkumar/BookEntryForm.jsp
Syntax error, insert"}" to complete Block
122: </body>
123: </html>
124:
125: <%}%>
An error occurred at line: 125 in the jsp file: /rajkumar/BookEntryForm.jsp
Syntax error, insert"Finally" to complete TryStatement
122: </body>
123: </html>
124:
125: <%}%>
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
--
Apache Tomcat/6.0.10
