回allike(***) : 注:我给下列的SQL String sql="select * from yenoadmin where yenous='"+us+"' and yenopassword='"+ps+"';"; 改成 String sql="select * from yenoadmin"; 可是问题依旧呀
错误信息为:javax.servlet.ServletException: ResultSet is closed
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 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) root cause java.lang.NullPointerException org.apache.jsp.checklogin_jsp._jspService(checklogin_jsp.java:63) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:856) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) org.apache.jasper.servlet.JspServlet.service(JspServlet.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.18
对了,在Resin3.04里调试的错误如下:Resin can't load com.sun.tools.javac.Main. Usually this means that the JDK tools.jar is missing from the classpath, possibly because of using a JRE instead of the JDK. You can either add tools.jar to the classpath or change the compiler to an external one with <java compiler='javac'/> or jikes.java.lang.ClassNotFoundException: com.sun.tools.javac.Main
out.println(rs.getString(XXX));
}
rs是String对象吗?
out.println();
是对String对象的吧!
你用while (rs.next()){
out.println(rs.getString(XXX));
}
这个试试看!
你的SQL语有问题。
注:我给下列的SQL
String sql="select * from yenoadmin where yenous='"+us+"' and yenopassword='"+ps+"';";
改成
String sql="select * from yenoadmin";
可是问题依旧呀
两个办法:第一个修改你的代码,第二办法用一个第三方包:CachedRowSet把结果集放进去
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.NullPointerException
org.apache.jsp.checklogin_jsp._jspService(checklogin_jsp.java:63)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.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.18
JDK tools.jar is missing from the classpath, possibly because of using
a JRE instead of the JDK. You can either add tools.jar to the classpath
or change the compiler to an external one with <java compiler='javac'/>
or jikes.java.lang.ClassNotFoundException: com.sun.tools.javac.Main
你需要修改你的程序了,可以把Connection对象返回给具体适用的程序,然后程序自己控制什么时候关闭,而不是像现在这样,取出结果集之后立即关闭连接
我现在已经离职了,新的岗位要明天才能去上班,我会接着调试的,到时再来跟大伙研讨,非常感谢你们的关心与支持