org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 6 in the jsp file: /view.jsp
Generated servlet error:
con cannot be resolved
Generated servlet error:
con cannot be resolved
解决方案 »
- 快速查询数据
- jquery ajax方法在ie中有问题
- tomcat Redeploy时出错,请帮忙看看怎么解决
- 我想修改按钮X的内容怎么没用 而且问题是程序被调用了两次
- 使用axis2开发webservice,想部署在tomcat上,怎么配置数据源?
- 关于tomcat5.5.17的虚拟路径和servlet的问题,急,在线等待
- struts 无法从页面上得到表单的数据
- myEclipse开发EJB,怎样生成其他类文件?
- XML 中文处理问题
- struts2不执行全局拦截器
- [100分求助]HPUNIX、WebLogic700环境下deploy CMP的问题
- Java里面如何调入oracle存储过程
<head><title></title></head>
<body>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<%try
{
//注册数据库驱动程序为oracle驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (java.lang.ClassNotFoundException e)
{ System.err.println("mydb(): " + e.getMessage());
} String url="jdbc:oracle:thin:@localhost:1521:sun1";
Connection con=DriverManager.getConnection(url,"chat","chat");
Statement smt=con.createStatement();
ResultSet rs;
String sql;String errmsg=request.getParameter("errmsg");
if(errmsg!=null)
{
out.print("<font color=red size=5>"+errmsg+"</font>");
}
else
{
String nick,sex,color,time,note;
String refresh=(String)session.getValue("change");
if(!refresh.equals("0"))
response.setHeader("Refresh",refresh);
sql="select * from chatroom order by id";
rs=smt.executeQuery(sql);
while(rs.next())
{
nick=rs.getString(1);
sex=rs.getString(2);
color=rs.getString(3);
time=rs.getString(4);
note=rs.getString(5);
out.print(time+"><font color="+color+">"+nick+"说:"+note+"</font><img src="+sex+"><br>");
}
}smt.close();
rs.close();%></body>
</html>错误变成:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 6 in the jsp file: /view.jsp
Generated servlet error:
The local variable rs may not have been initialized
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:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
ResultSet.CONCUR_UPDATABLE);
ResultSet rs;这个在if之前啥
在else中的rs=smt.executeQuery(sql);这句话才是为rs赋值。也就是说初始化。只有在初始化这个之后才可以执行close()这个方法。不然就会提示未初始化The local variable rs may not have been initialized