JSP连接Oracle报错问题

来源:百度知道 编辑:UC知道 时间:2024/05/08 08:58:22
错误信息:
exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 22 in the jsp file: /Ora.jsp
Generated servlet error:
rs cannot be resolved

An error occurred at line: 23 in the jsp file: /Ora.jsp
Generated servlet error:
rs cannot be resolved

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 22 in the jsp file: /Ora.jsp
Generated servlet error:
rs cannot be resolved

An error o

同意楼上的看法
但是不用两个try
这样就可以了
<% Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:abc", "LIJIE", "abc");
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM USER");
while (rs.next()){ %>
<%=rs.getString(1)%>
<%
out.println(rs.getString(1));

}

} catch (ClassNotFoundException ex) {
} catch (SQLException e) {
e.printStackTrace();
}
%>
看看怎么样
你原来都没有异常处理 没有异常处理是不可以的

<%=rs.getString(1)%> 是把内容输出到JSP页面上,
换个写法试试<%out.println(rs.getString(1));%>

没有找到对象rs,rs声明在try里面,外面调用可能找不到这个对象
重新写了下,运行试试
<% Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {