Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¶¼»á½¨Á¢Ò»¸öÁ¬½Ó
½¨ÒéÄãÒÔ100»ò500Ϊһ×é²åÈë
ÊÔÊÔ¿´

ÕâÑùµÄ»°»áÌáʾ¿ÕÖ¸Õë
ÒýÓÃ
num[i]ÔÚi=1998ʱԽ½çÁË°É »¹ÊÇûÓÐÕâÒ»Ïî Ä㿴һϰÉ


ÄÜ˵Ïêϸµãô£¬ÎÒµÄÈ·ÊÇÔÚ³ÌÐòÖжà´ÎÓõ½ÁËstmt1.executeUpdate
ÒýÓÃ


Ïà¹ØÎÊ´ð£º

C/SÏîÄ¿¼Ü¹¹Éè¼Æ----ÇóÖú - Java / Java SE

±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ 
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆڶԼܹ¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæʱ»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ 
ËùÒÔÌصØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......

¹ØÓÚAJAXºÍJSPµÄһЩСÎÊÌâ¡« - Java / Web ¿ª·¢

ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
  %>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......

JAVAµç×Ӵʵ䣿 - Java / Java SE

¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£


´Ê¿âÔõôÉú³ÉÄØ£¿

²»»á¡£

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ

ÓÃmap ¼üÖµ¶ÔÓ¦

Èç¹ûÓÃÊý¾Ý¿ ......

php¸újspÖ®¼äsession¹²ÏíµÄÎÊÌâ - Java / Web ¿ª·¢

×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔ­ÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬Ô­À´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......

java windows7 MSSQL - Java / Java SE

ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates
ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ