在用java语言连接数据库时出现以下错误是为什么?

来源:百度知道 编辑:UC知道 时间:2024/05/26 16:17:07
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 15 in the jsp file: /sql.jsp
Generated servlet error:
E:\tomcat\jakarta-tomcat-5.0.28\work\Catalina\localhost\_\org\apache\jsp\sql_jsp.java:66: cannot resolve symbol
symbol : variable stmt
location: class org.apache.jsp.sql_jsp
ResultSet rs=stmt.executeQuery(sql);
^

An error occurred at line: 32 in the jsp file: /sql.jsp
Generated servlet error:
E:\tomcat\jakarta-tomcat-5.0.28\work\Catalina\localhost\_\org\apache\jsp\sql_jsp.java:85: cannot resolve symbol
symbol : method colse ()
location: interface java.sql.ResultSet
rs.colse();
^

An error occurred at line: 32 in the jsp file: /sql.jsp
Generated servlet error:
E:\tomcat\jakarta-tomcat-5.0.28\work\Catalina\localhost\_\

你能确定你的 Statement 对象 stmt 成功生成了吗?
在你的代码
Statement stmt = con.createStatement();
附近用自己喜欢的debug方式看看 stmt 是否是空
还有,如果你的SQL语句是SELECT的话,建议用Statement的execute()方法