ResultSet is closed!为什么？该如何处理
日期：2014-05-20 浏览次数：20873 次
ResultSet is closed!!!为什么？
<%@ page contentType= "text/html; charset=GBK " %>
<html>
<head>
<title> connect the db </title>
</head>
<%@ page import= "java.sql.* "%>
<body bgcolor= "#ffffff ">
<%
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
String url= "jdbc:odbc:JSPuser "; // message_DSN 为你的用户数据源名称；
String user= " ";
String password= " "; // 用户名和密码在此都设为空；
String name;
String pwd;
String c;
name=request.getParameter( "name ");
pwd=request.getParameter( "pwd ");
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql= "select * from TBuser where name= ' "+name+ " '; ";
String pd= "select * from TBuser where password= ' "+pwd+ " '; ";
ResultSet rs1=stmt.executeQuery(pd);
ResultSet rs=stmt.executeQuery(sql);
%>
<%
if ((rs1.getString(2)).equals(rs.getString(2)))
out.println( "OK ");
else
out.println( "Error ");
%>
<%rs.close();
rs1.close();
stmt.close();
conn.close();
%>
</body>
</html>
以上是JSP代码。。。
问题是出现了
javax.servlet.ServletException: ResultSet is closed
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.JSPco_jsp._jspService(JSPco_jsp.java:143)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.sql.SQLException: ResultSet is closed
sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6647)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:256)
org.apache.jsp.JSPco_jsp._jspService(JSPco_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
高手帮帮 怎么改
------解决方案--------------------
客气了 我也是刚开始做J2EE的 也刚来CSDN不久 大家互相学习嘛 我们公司白天不让上QQ和MSN 我晚上加你吧
<%@ page contentType= "text/html; charset=GBK " %>
<html>
<head>
<title> connect the db </title>
</head>
<%@ page import= "java.sql.* "%>
<body bgcolor= "#ffffff ">
<%
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
String url= "jdbc:odbc:JSPuser "; // message_DSN 为你的用户数据源名称；
String user= " ";
String password= " "; // 用户名和密码在此都设为空；
String name;
String pwd;
String c;
name=request.getParameter( "name ");
pwd=request.getParameter( "pwd ");
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql= "select * from TBuser where name= ' "+name+ " '; ";
String pd= "select * from TBuser where password= ' "+pwd+ " '; ";
ResultSet rs1=stmt.executeQuery(pd);
ResultSet rs=stmt.executeQuery(sql);
%>
<%
if ((rs1.getString(2)).equals(rs.getString(2)))
out.println( "OK ");
else
out.println( "Error ");
%>
<%rs.close();
rs1.close();
stmt.close();
conn.close();
%>
</body>
</html>
以上是JSP代码。。。
问题是出现了
javax.servlet.ServletException: ResultSet is closed
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.JSPco_jsp._jspService(JSPco_jsp.java:143)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.sql.SQLException: ResultSet is closed
sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(JdbcOdbcResultSet.java:6647)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:256)
org.apache.jsp.JSPco_jsp._jspService(JSPco_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
高手帮帮 怎么改
------解决方案--------------------
客气了 我也是刚开始做J2EE的 也刚来CSDN不久 大家互相学习嘛 我们公司白天不让上QQ和MSN 我晚上加你吧
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
