代码如下:
<%
String tempSTR,whereTo;
int bbbid=0;
tempSTR=request.getParameter("bbsid");
bbbid=java.lang.Integer.parseInt(tempSTR);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:bbs");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet sqlRst = stmt.executeQuery("delete * from bbs where bbsid="+bbbid);
sqlRst.close();
stmt.close();
con.close();
whereTo="bbslist.jsp";
%>
<jsp:forward page='<%=whereTo%>'/>数据删除了,但是报错如下:
javax.servlet.ServletException: No ResultSet was produced
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.msg.delnews_jsp._jspService(delnews_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97
<%
String tempSTR,whereTo;
int bbbid=0;
tempSTR=request.getParameter("bbsid");
bbbid=java.lang.Integer.parseInt(tempSTR);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:bbs");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet sqlRst = stmt.executeQuery("delete * from bbs where bbsid="+bbbid);
sqlRst.close();
stmt.close();
con.close();
whereTo="bbslist.jsp";
%>
<jsp:forward page='<%=whereTo%>'/>数据删除了,但是报错如下:
javax.servlet.ServletException: No ResultSet was produced
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.msg.delnews_jsp._jspService(delnews_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货