ths is the jsp page:
<[EMAIL PROTECTED] import="java.sql.*,java.util.*,logcheck.settings" errorPage="
errorpage.jsp"%>
<html>
<head>
<title> classification</title> </head>
<script type="text/javascript" src="dropdown.js"></script>
<body bgcolor="#FFFFFF" >
<LINK rel="stylesheet" href="style.css" type="text/css" />
<form action="classification.jsp" method="POST" name="classif"
onSubmit="return check()">
<%
settings set=new settings();
int flag = 0;
flag = set.islogedin(request,response);
if(flag!=1){
out.println("<html><body><center><b>Your session is
invalidate..Press F5 or refresh it</b></center></body></html>");
}
else if(session.isNew()){
out.println("<script language=javascript>
parent.location.href='expair.jsp';</script>");
}
else
{
%>
<br>
<script language="javascript">
function check()
{
var id = document.getElementById("clname");
if(id.value ==''){
alert("Empty");
return false;
}
return true;
}
function ses_check(url)
{
if(confirm("It will delete all the question coming under this
Classification !!!!! DO You Want to Proceed ????")){
document.location.href=url;
}
}
function online(level,cid)
{
document.location.href="online.jsp?level="+level+"&CID="+cid+"&e_type=1";
}
function written(level,cid)
{
document.location.href="wedastr.jsp?level="+level+"&CID="+cid+"&e_type=0";
}
function onlineedit(level,cid)
{
document.location.href="mangquest.jsp
?e_type=1&sel_level="+level+"&CID="+cid+"";
}
function writtenedit(level,cid)
{
document.location.href="mangquest.jsp?sel_level="+level+"&CID="+cid+"&e_type=0"
;
}
</script>
<%
int userid=0;
if(session.getAttribute("uid")!=null){
userid=
Integer.valueOf(""+session.getAttribute("uid"));
}
else {
out.println("<script language=javascript>
parent.location.href='expair.jsp';</script>");
}
PreparedStatement stmt = null;
Connection conn= null;
ResultSet resultset=null;
ResultSet resultset1=null;
ResultSet result=null;
ResultSet res=null;
ResultSet resdel=null;
Statement statement=null;
Statement statement1=null;
String subject=new String();
String class_name=new String();
String noqt=new String();
conn=set.getcon();
String PID_str = request.getParameter("PID");
int PID=0;
statement = conn.createStatement();
statement1 = conn.createStatement();
String delete = request.getParameter("delete");
if((request.getParameter("delete")!= null) && (request.getParameter
("delete").equals("yes")))
{
ResultSet rss=null;
int C_Id_todel = Integer.parseInt(
request.getParameter("CID"));
ArrayList tnoarr=new ArrayList();
ArrayList cidarr=new ArrayList();
if((request.getParameter("CID") != null)&&(userid != 0))
{
cidarr.clear();
int avail=0;
rss=statement.executeQuery("select CID from
classification where PID="+C_Id_todel+" and UID="+userid+" ");
while(rss.next())
{
avail=1;
}
if(avail==1){
out.println("<script
language='javascript'>alert('NOT POSSIBLE!!!!it contains a sub
classification');</script>");
}
else{
rss=statement.executeQuery("select T_No from
questionbank where CID="+C_Id_todel+" ");
while(rss.next())
{
tnoarr.add(rss.getInt(1));
}
statement.execute("delete from classification
where CID="+C_Id_todel+" and UID="+userid+"");
for(int j=0;j<tnoarr.size();j++)
{
statement.execute("delete from
questionbank where T_No="+tnoarr.get(j)+" ");
statement.execute("delete from
options_table where T_No="+tnoarr.get(j)+" ");
}
}
}
}
if(PID_str == null)
{
PID=-1;
out.println("<input type=hidden name='PID'
value='"+PID+"'>");
}else{
PID = Integer.parseInt(PID_str);
out.println("<input type=hidden name='PID'
value='"+PID+"'>");
}
if(PID != -1){
ResultSet rs1=statement.executeQuery("select
PID,class_name,level_disp from classification where CID="+PID+"");
while(rs1.next())
{
subject=(rs1.getString(2));
String show_level=rs1.getString(3);
int back=rs1.getInt(1);
out.println("<div align='left'><b
class='label'>Under the heirarchy of <font color=#FF0000> "+subject+"
</font> and Level <font color=#FF0000>"+show_level+" </font>
</div>");
out.println("<table
align=right><tr><td></td><td></td><td></td><td class='label'><a href='http:
classification.jsp?PID="+back+"'
style=text-decoration:none><b> Back</b></a></td></tr>");
}
}
%>
<table align="center" ><tr><td ><b class="label">Add More
</b></td><td><input class="input" id='clname' type="text" name="ctype"
size="13" autocomplete=off></td>
<td><select class="normal" size="1" name="levels">
<% result=statement.executeQuery("select * from level
");
while(result.next())
{
out.println(" <option value="+result.getInt(1)+"
"+result.getString(3)+"</option>");}%>
</select></td><td><input class="butt" width="30"
type="submit" name="create" value="create"/> </td></tr></table>
<%
int sel_level=0;
String dis_level=new String();
if(request.getParameter("levels") != null)
{
sel_level=Integer.parseInt(request.getParameter
("levels"));
}
result=statement.executeQuery("select level_name
from level where levelID="+sel_level+" ");
if(result.next())
{
dis_level=result.getString(1);
}
if((request.getParameter("create") != null) && (
request.getParameter("create").equals("create")))
{
int available=0;
String cltype=request.getParameter("ctype");
int pd=Integer.parseInt(request.getParameter
("PID"));
int levl=0;
if(request.getParameter("levels") != null)
{
levl=Integer.parseInt(request.getParameter
("levels"));
}
res=statement.executeQuery("select * from
classification where class_name='"+cltype+"' and level="+levl+"");
if(res.next())
{
available=1;
}
if(available==1){
out.println("<script
language=javascript>alert('not possible,It have
Sub-Classification');</script>");
}
else
{
stmt=conn.prepareStatement("INSERT INTO
classification(UID,class_name,PID,level,level_disp)values(?,?,?,?,?)");
String cctype=request.getParameter("ctype");
//cctype=cctype.replace("#","#");
stmt.setInt(1,userid);
stmt.setString(2,cctype);
stmt.setInt(3,PID);
stmt.setInt(4,sel_level);
stmt.setString(5,dis_level);
stmt.executeUpdate();
stmt.close();
}
}else{ }
resultset=statement.executeQuery("select * from
classification where PID="+PID+" and UID="+userid+" ");
int i=1;
%>
<br><br><div align='center'><TABLE border='0' align=top
<TR class='head'><TH class='back'
SrNo</TH><TH>Classification</TH><TH>Level</TH><TH width="120">Add
Question</TH><TH width="70">no.ofquest</TH><TH>Edit
Question</TH><th>Action</th></TR></B>
<%
while(resultset.next())
{
String level=resultset.getString(6);
class_name=resultset.getString(3);
String cctest=resultset.getString(3);
// String url= "classification.jsp
?PID="+resultset.getInt(4)+"&CID="+resultset.getInt(1)+"&delete=yes";
int selected=resultset.getInt(5);
int cid=resultset.getInt(1);
request.setAttribute("c_id",cid);%>
<tr class="row"><td><%=i%></td><td><a class="one"
href='classification.jsp?PID=<%=resultset.getInt(1)%>&backPID="+PID+"'><%=class_name%></a></td><td
class="one"><%=level%></td>
<%out.println("<td>");
out.println("<a class='one' style='display: block;
border: 1px solid black;' href='#'
onClick=\"online('"+selected+"','"+cid+"')\">Online</a>");
out.println("<a class='one' style='display: block; border:
1px solid black;' href='#settings'
onClick=\"written('"+selected+"','"+cid+"')\">Written</a>");
out.println("</td>");
resultset1=statement1.executeQuery("select count(*) from
questionbank where CID="+cid+"");
while(resultset1.next())
{
noqt=resultset1.getString(1);
}
out.println("<td align='center'>"+noqt+"</td>");
out.println("<td align='center'>");
out.println("<a class='one' style='display: block;
border: 1px solid black;' href='#'
onClick=\"onlineedit('"+selected+"','"+cid+"')\">Online</a>");
out.println("<a class='one' style='display: block;
border: 1px solid black;' href='#settings'
onClick=\"writtenedit('"+selected+"','"+cid+"')\">Written</a>");
out.println("</td>");
%>
<%
String url= "classification.jsp
?PID="+resultset.getInt(4)+"&CID="+resultset.getInt(1)+"&delete=yes";
%>
<td><a class="one" href='#delete'
onclick="ses_check('<%=url%>')">Delete</a></td>
<%
out.println("</tr>");
// out.println("<td><a class='one' href='#delete'
onclick='ses_check('+url+')'>Delete</a></td></tr>");
out.println("</td></tr>");
i++;
}
statement1.close();
statement.close();
conn.close();
request.setAttribute("level",sel_level);
%>
</div></TABLE >
<% } %>
</p>
</form>
</body>
</html>
This is the Exception error
type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 67 in the jsp file: /classification.jsp
Generated servlet error:
Type mismatch: cannot convert from Integer to int
An error occurred at line: 67 in the jsp file: /classification.jsp
Generated servlet error:
The method add(int, Object) in the type ArrayList is not applicable for the
arguments (int)
An error occurred at line: 226 in the jsp file: /classification.jsp
Generated servlet error:
The method setAttribute(String, Object) in the type ServletRequest is not
applicable for the arguments (String, int)
An error occurred at line: 263 in the jsp file: /classification.jsp
Generated servlet error:
The method setAttribute(String, Object) in the type ServletRequest is not
applicable for the arguments (String, int)
org.apache.jasper.compiler.DefaultErrorHandler.javacError(
DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(
ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java
:397)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(
JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.9 logs.
Our development Envrnment is
mysql 5.0.27
jdk 1.5.0_06
jre 1.5.0_06
tomcat 5.5.20
Apache 2
phpMyAdmin 2.9.2
Servlets 2.3
JSP 1.2
Our application is showing errors when deployed on tomcat 5.5.9(the
Hosting company is using Tomcat 5.5.9.)
so what is the solution.
