ResultSet rs=stmt.executQuery ("select id,g_id form table1 where id=1");
if (rs.next()){ResultSet rs1=stmt.executeQuery("select id,title,content form table2 where id="+rs.getString("g_id"));
while(rs1.next()){
out.println(rs1.getString("title"));
}
}上面的例子这种查询方法是不是有错的呢,还是我的语法有错,反正中间那个查询不能实现,有其实解决办法没有,我用标签传递参数让他返回值也不能实现。。急啊,各们帮助一小弟一下,小弟刚学习,jsp那个开发的模式还停留在,asp的思想里。
if (rs.next()){ResultSet rs1=stmt.executeQuery("select id,title,content form table2 where id="+rs.getString("g_id"));
while(rs1.next()){
out.println(rs1.getString("title"));
}
}上面的例子这种查询方法是不是有错的呢,还是我的语法有错,反正中间那个查询不能实现,有其实解决办法没有,我用标签传递参数让他返回值也不能实现。。急啊,各们帮助一小弟一下,小弟刚学习,jsp那个开发的模式还停留在,asp的思想里。
解决方案 »
- The constructor UploadResponse(int, null, null, String) is undefined
- sql问题
- 求解:struts框架问题
- 如何传递超连接参数
- 如何在上传网页(.html文件)的时候,一起将网页内的图片、FLASH、CSS、背景图片等一起上传到服务器?
- <input type="text" onchange=chang()/>执行不了,怎么会事?
- "\"是转义字符的简单问题?
- ssh 在action 里 private server 但是server一直为空
- xp系统,java虚拟机和tomcat都在D盘下,我设置tomcat的环境变量运行startup后出错,不知道为什么?
- 用jsp打开一篇word文档,非常非常的急用啊!(多少分都可以给你们)
- 谁能告诉我输出的第一条结果应该是库里面的第几条??
- ●●●●●●●怎么设置frameset的高度?
ResultSet rs=stmt.executeQuery ("select id,g_id from soyo_game ");
while(rs.next()){ResultSet rs1=stmt.executeQuery("select id,g_file from soyo_gamefile where g_id="+rs.getString("id"));
while(rs1.next()){
out.println(rs1.getString("g_file"));
out.println("</br>");
}
}
%>这样就会出错的哈,完整程序应该是这样,出错代码如下:
javax.servlet.ServletException: Operation not allowed after ResultSet closed
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.test_jsp._jspService(test_jsp.java:81)
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: Operation not allowed after ResultSet closed
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:666)
com.mysql.jdbc.ResultSet.next(ResultSet.java:7280)
org.apache.jsp.test_jsp._jspService(test_jsp.java:67)
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)帮助解决一下,急啊,
ResultSet rs=stmt.executeQuery ("select id,g_id from soyo_game ");
while(rs.next()){ResultSet rs1=stmt1.executeQuery("select id,g_file from soyo_gamefile where g_id="+rs.getString("id"));
while(rs1.next()){
out.println(rs1.getString("g_file"));
out.println("</br>");
}
}
%>