JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » Servlet/JSP 討論區  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友   
reply to postflat modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 Re:[問題]即時多層下拉選單 [Re:minichitina]
eidson72





發文: 25
積分: 0
於 2007-05-16 11:48 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
<%@ page language="java" contentType="text/html; charset=UTF-8" import="java.sql.*" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<%
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
Connection Conn = DriverManager.getConnection("proxool.xml-test");

int i=0;
Statement stmt = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Statement stmt2 = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String SQL = "Select * from unit";
ResultSet rs = stmt.executeQuery(SQL);
%>

<SCRIPT LANGUAGE="javascript">
<!--
function ChangeSelect(city, region)
{
val = city.options[city.options.selectedIndex].value;

<%
while(rs.next())
{
String SQL2 = " select * from class where unit="+rs.getString("unit_id");
ResultSet rs2 = stmt2.executeQuery(SQL2);

%>
if (val == '<%=rs.getString("unit")%>')
{

<%while(rs2.next()){
i++;
}%>
region.length = <%=i%>;
<%
i=0;
rs2.first();
do{%>
region.options[<%=i%>].value = '<%=rs2.getString("class")%>';
region.options[<%=i%>].text = '<%=rs2.getString("class")%>';
<%
i++;
}while(rs2.next());
i=0;%>
}
<%}
rs.first();%>
}
-->
</script>

<form name="selection">
<select name=city onChange="ChangeSelect(document.selection.city,document.selection.region)" size="1">
<option>==請選擇城市==</option>
<%do{%>
<option value="<%=rs.getString("unit_id")%>"><%=rs.getString("unit")%></option>
<%}while(rs.next());%>
</select><BR>
選擇您要的區域</font><br>
<SELECT name=region>

</SELECT> </p>
</form>

</body>
</html>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
請教一下各位大大..我是初學者...我不知道我那邊有錯...><---下面是apache log
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /sql/test.jsp:44

41: i=0;
42: rs2.first();
43: do{%>
44: region.options[<%=i%>].value = '<%=rs2.getString("class")%>';
45: region.options[<%=i%>].text = '<%=rs2.getString("class")%>';
46: <%
47: i++;

Stacktrace:
  org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)
  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

javax.servlet.ServletException: Illegal operation on empty result set.
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
  org.apache.jsp.sql.test_jsp._jspService(test_jsp.java:151)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
  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

java.sql.SQLException: Illegal operation on empty result set.
  com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:4341)
  com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:2137)
  com.mysql.jdbc.ResultSet.getString(ResultSet.java:2132)
  com.mysql.jdbc.ResultSet.getString(ResultSet.java:2250)
  org.apache.jsp.sql.test_jsp._jspService(test_jsp.java:100)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
  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)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.


reply to postreply to post
話題樹型展開
人氣 標題 作者 字數 發文時間
81906 [精華] [問題]即時多層下拉選單 ㄚ孝 384 2003-06-07 09:05
79007 Re:[問題]即時多層下拉選單 browser 1054 2003-06-07 18:19
75946 Re:[問題]即時多層下拉選單 x3711699 138 2004-04-08 20:41
75752 Re:[問題]即時多層下拉選單 alanting 710 2004-04-11 01:41
78991 Re:[問題]即時多層下拉選單 AdaHsu 3345 2004-04-19 12:23
76863 Re:[問題]即時多層下拉選單 tsechun 95 2004-04-21 02:01
74027 Re:[問題]即時多層下拉選單 andowson 474 2004-08-01 11:07
73750 Re:[問題]即時多層下拉選單 yingssu 663 2004-08-01 19:48
72814 Re:[問題]即時多層下拉選單 ting626 38 2004-08-25 16:57
72886 Re:[問題]即時多層下拉選單 i22616899 2298 2004-09-04 17:55
72071 Re:[問題]即時多層下拉選單 GuanChih 175 2004-09-05 18:51
72813 Re:[問題]即時多層下拉選單 jonz 873 2004-09-12 10:27
66064 Re:[問題]即時多層下拉選單 pulse 1193 2005-04-18 23:22
69862 Re:[問題]即時多層下拉選單 joshua 1019 2004-11-17 16:02
70196 Re:[問題]即時多層下拉選單 joshua 2357 2004-11-17 17:27
76447 Re:[問題]即時多層下拉選單 ㄚ孝 61 2003-06-09 08:34
76683 Re:[問題]即時多層下拉選單 browser 135 2003-06-09 09:23
68911 Re:[問題]即時多層下拉選單 Madagascar 141 2004-12-04 02:06
68709 Re:[問題]即時多層下拉選單 yannru 360 2004-12-07 16:19
68566 Re:[問題]即時多層下拉選單 Madagascar 465 2004-12-07 21:20
68569 Re:[問題]即時多層下拉選單 small3 388 2004-12-13 09:52
68948 Re:[問題]即時多層下拉選單 EPHT 3599 2004-12-18 09:45
56337 Re:[問題]即時多層下拉選單 yulie 2015 2006-06-06 12:47
56058 Re:[問題]即時多層下拉選單 yulie 102 2006-06-06 13:21
56313 Re:[問題]即時多層下拉選單 estrelas 1620 2006-06-06 18:51
47116 Re:[問題]即時多層下拉選單 minichitina 1875 2007-05-05 16:25
47013 Re:[問題]即時多層下拉選單 eidson72 4781 2007-05-16 11:48
21901 Re:[問題]即時多層下拉選單 catte 1960 2011-06-27 14:44
21788 Re:[問題]即時多層下拉選單 bernardvai 54 2011-06-27 16:56
46581 Re:[問題]即時多層下拉選單 alvin0224 309 2007-05-16 14:54
46666 Re:[問題]即時多層下拉選單 eidson72 21 2007-05-16 15:41
76266 Re:[問題]即時多層下拉選單 ㄚ孝 75 2003-06-09 14:05
76225 Re:[問題]即時多層下拉選單 jackyliu 201 2003-06-22 02:06
46119 Re:[問題]即時多層下拉選單 minichitina 188 2007-05-31 08:33
45985 Re:[問題]即時多層下拉選單 minichitina 2335 2007-06-04 08:04
46446 Re:[問題]即時多層下拉選單 minichitina 2718 2007-06-07 08:00
21915 Re:[問題]即時多層下拉選單 catte 2014 2011-06-28 03:14
21753 Re:[問題]即時多層下拉選單 bernardvai 1202 2011-06-28 09:54
21869 Re:[問題]即時多層下拉選單 catte 2970 2011-06-28 11:36
21726 Re:[問題]即時多層下拉選單 bernardvai 545 2011-06-28 14:21
21818 Re:[問題]即時多層下拉選單 catte 146 2011-06-28 17:54
21748 Re:[問題]即時多層下拉選單 bernardvai 2904 2011-06-29 09:58
21695 Re:[問題]即時多層下拉選單 catte 43 2011-06-29 21:58
21579 Re:[問題]即時多層下拉選單 bernardvai 219 2011-06-30 14:40
21395 Re:[問題]即時多層下拉選單 catte 269 2011-07-13 10:41
21469 Re:[問題]即時多層下拉選單 bernardvai 660 2011-07-13 11:34
20904 Re:[問題]即時多層下拉選單 catte 4035 2011-08-15 09:35
21135 Re:[問題]即時多層下拉選單 jk47 288 2011-08-15 11:19
76201 Re:[問題]即時多層下拉選單 mousetail 89 2003-06-22 13:06
77848 Re:[問題]即時多層下拉選單 alanting 1777 2003-06-22 23:21
76366 Re:[問題]即時多層下拉選單 alanting 87 2003-06-22 23:24
22018 Re:[問題]即時多層下拉選單 catte 54 2011-06-27 04:33
75777 Re:[問題]即時多層下拉選單 evenlin 132 2003-08-02 00:55
77935 Re:[問題]即時多層下拉選單 anthonycs 301 2003-08-02 15:43
75415 Re:[問題]即時多層下拉選單 ajax0953 232 2004-03-31 15:05
75185 Re:[問題]即時多層下拉選單 shyan68 261 2004-04-07 18:11
73616 Re:[問題]即時多層下拉選單 yafeng 122 2004-07-29 10:53
69042 Re:[問題]即時多層下拉選單 javaer 216 2004-12-20 00:40
» JWorld@TW »  Servlet/JSP 討論區

reply to postflat modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8