558903.xml

论坛精华帖子

<PostDateTime>2002-3-7 11:33:11</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3736797</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>對不起,應該再加上:
rs1=null;rs2=null;statement1=null;statement2=null;conn=null;
將它們釋放較好.</Content>
<PostDateTime>2002-3-7 11:35:20</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>笨笨</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>120</credit>
<ReplyID>3737634</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>115764</PostUserId>
<PostUserName>yanchang</PostUserName>
<Point>0</Point>
<Content>我刚才说了
如果你是用ODBC连接的，恐怕连Connection都要两个，否则包错&#32;
但用JDBC连接的Oracle就可以&#32;
只要生命两个Statement就可以

ODBC的不可！
</Content>
<PostDateTime>2002-3-7 12:26:58</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3737776</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>我用Kin_CIOM的方法，系统仍然报错：&#32;
[Microsoft][ODBC&#32;SQL&#32;Server&#32;Driver]连接占线导致另一个hstmt

我用了两个Connection对象，系统报错：
Result&#32;set&#32;type&#32;is&#32;TYPE_FORWARD_ONLY

请问什么原因。</Content>
<PostDateTime>2002-3-7 12:37:08</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3739165</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>yanchang(笨笨)&#32;說得對,
用
statement1=conn.create...&#32;&#32;
statement2=conn.create...&#32;&#32;
會出錯的.
妳為何不用:
statement=conn.create...&#32;&#32;
ResultSet&#32;&#32;rs1=statement.execute("select&#32;&#32;语句1");&#32;&#32;&#32;&#32;
ResultSet&#32;&#32;rs2=null;&#32;
while&#32;&#32;(rs1.next()){&#32;&#32;&#32;&#32;
&#32;&#32;&#32;&#32;rs2=statement.execute("select&#32;&#32;语句2");&#32;&#32;&#32;&#32;
&#32;&#32;&#32;&#32;while&#32;&#32;(rs2.next()){&#32;&#32;&#32;&#32;
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;...&#32;
&#32;&#32;&#32;&#32;}&#32;&#32;&#32;&#32;
&#32;&#32;&#32;&#32;...&#32;&#32;
&#32;&#32;&#32;
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;rs2.close();&#32;&#32;
}&#32;&#32;
...</Content>
<PostDateTime>2002-3-7 13:52:37</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3739658</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>rs.last()为什么不好用？是jdbc不支持吗？
将游标移到第一条记录怎么办，rs.first();对吗？</Content>
<PostDateTime>2002-3-7 14:19:50</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3740541</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>只有rs.next()用,rs.last,rs.first,rs.recordcount等都沒有,有時很不方便.</Content>
<PostDateTime>2002-3-7 15:07:59</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3740591</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>Kin_CIOM,我想知道记录总数怎么办？</Content>
<PostDateTime>2002-3-7 15:10:28</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3740616</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>我想知道记录总数怎么办？</Content>
<PostDateTime>2002-3-7 15:11:41</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3740806</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>rs=stmt.executeQuery("select&#32;count(1)&#32;from&#32;aaa");
rs.next();
i_total=rs.getInt(1);
i_total就是紀錄總數,是不是比較繁啊,呵呵!</Content>
<PostDateTime>2002-3-7 15:22:48</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3741093</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>呵呵，我已经想到了。
又有问题：
&#32;&#32;tempStr1=listRs.getString("Code");
&#32;&#32;tempStr4=listRs.getString("Name");
为什么第二条语句报错：No&#32;data&#32;found？
而且这样写也不行：
&#32;&#32;tempStr1=listRs.getString("Code");
&#32;&#32;tempStr4=listRs.getString("Code");
可气死我了。
</Content>
<PostDateTime>2002-3-7 15:38:59</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3741243</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>妳的select語句是否是select&#32;name,code&#32;form&#32;aaaa?
如果先取code,再取name&#32;可能會出錯,一般是按順序全都取出到變量中,然后使用變量.</Content>
<PostDateTime>2002-3-7 15:47:03</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3741494</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>就是生气在这，明明是"select&#32;Code,Name&#32;from&#32;XXXX"的啊！
</Content>
<PostDateTime>2002-3-7 16:01:05</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3741594</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>那妳取數据的順序有沒有打亂呢,如果按順序,應該不會,會不會是別的地方的錯誤啊???</Content>
<PostDateTime>2002-3-7 16:06:19</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3741810</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>我是在选择语句中取数据，是不是不行啊，必须一次性按顺序取出呢？</Content>
<PostDateTime>2002-3-7 16:17:57</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3741887</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>142296</PostUserId>
<PostUserName>Kin_CIOM</PostUserName>
<Point>0</Point>
<Content>最好是一次性按顺序取出,然后再使用!</Content>
<PostDateTime>2002-3-7 16:21:55</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞翔</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>3742810</ReplyID>
<TopicID>558903</TopicID>
<PostUserId>177448</PostUserId>
<PostUserName>yuanfy</PostUserName>
<Point>0</Point>
<Content>I&#32;see,谢谢各位的帮忙</Content>
<PostDateTime>2002-3-7 17:07:54</PostDateTime>
</Reply>
</Replys>
</Topic>