简单代码报错,哪位碰到过类似问题?(jsp操作数据库时)
代码如下:
<%@ page import="java.io.*,java.sql.*,java.util.*,java.lang.*" contentType="text/html;charset=gb2312"%>
<%
try{
//数据库链接参数
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载驱动
con = DriverManager.getConnection("jdbc:odbc:misDB"); //建立链接
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //建立Statement对象
rs = stmt.executeQuery("select * from inform_list");
}
catch(Exception ex){
System.out.println(ex);
System.out.println("inform_query.jsp");
}
finally{
rs.close();
stmt.close();
con.close();
}
%>
结果居然报错如下:
cannot resolve symbol
symbol : variable rs
location: class org.apache.jsp.a_jsp
rs.close();
cannot resolve symbol
symbol : variable rs
location: class org.apache.jsp.a_jsp
stmt.close();
cannot resolve symbol
symbol : variable rs
location: class org.apache.jsp.a_jsp
con.close();
去掉finally{rs.close();...}这段的话,则不报错,数据库链接是成功的。这是什么问题?哪位碰到过类似问题的,盼指教!谢谢!