javaÖÐResultSet is closed ÎÊÌâ - Java / Java EE
´úÂ룺
i1=1;
for (i = 0; i < 2000; i++,i1++){
if(user[i]==null||user_name[i]==null)continue;
sql4="update JQBD set user='"+user[i]+"',user_name='"+user_name[i]+"' where num='"+num[i]+"'";
stmt1.executeUpdate(sql4);
System.out.print(df.format((float)(i1)/(float)(2000)*100));
p("% ²åÈëÊý¾Ý");
p(i1);
}
Ϊʲôµ± i1=1998µÄʱºò»á³öÏÖResultSet is closed µÄÒì³££¿Çë´ó¼ÒÖ¸½Ì£¬¼±
¿´ÏÂÊDz»ÊÇi1ºÍi·¶Î§ÎÊÌâ
ÊäÈëËüÃÇÁ½¸öµÄÖµ
Õâ¸öÓ¦¸Ã²»ÊÇ£¬i1ºÍiµÄ·¶Î§Ã»¹Øϵ£¬Ö»ÒªÃ»Ñ»·Ò»´ÎÖ»ÊǸøi1¼Ó1¶øÒÑ£¬Ã»ÓÐÏ໥ӰÏì
num[i]ÔÚi=1998ʱԽ½çÁË°É »¹ÊÇûÓÐÕâÒ»Ïî Ä㿴һϰÉ
²Ù×÷Êý¾Ý¿âʱҪ¼°Ê±µÄ¹Ø±ÕÁ¬½Ó£¬ÎÒ¹À¼ÆÄãµÄÊý¾Ý¿âÒѾ³¬³öÁ¬½ÓÉÏÏÞ¡£
ÿ´Îstmt1.executeUpdate¶¼»á½¨Á¢Ò»¸öÁ¬½Ó
½¨ÒéÄãÒÔ100»ò500Ϊһ×é²åÈë
Ó¦¸ÃÊÇÕâ¸öÔÒò
²Ù×÷Êý¾Ý¿âʱҪ¼°Ê±µÄ¹Ø±ÕÁ¬½Ó£¬ÎÒ¹À¼ÆÄãµÄÊý¾Ý¿âÒѾ³¬³öÁ¬½ÓÉÏÏÞ¡£
ÿ´Îstmt1.executeUpdate¶¼»á½¨Á¢Ò»¸öÁ¬½Ó
½¨ÒéÄãÒÔ100»ò500Ϊһ×é²åÈë
ÊÔÊÔ¿´
ÕâÑùµÄ»°»áÌáʾ¿ÕÖ¸Õë
ÄÜ˵Ïêϸµãô£¬ÎÒµÄÈ·ÊÇÔÚ³ÌÐòÖжà´ÎÓõ½ÁËstmt1.executeUpdate
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆڶԼܹ¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæʱ»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌصØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......