Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
ÒýÓÃ


Ïà¹ØÎÊ´ð£º

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

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


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

²»»á¡£

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

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

ÓÃmap ¼üÖµ¶ÔÓ¦

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

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃ涼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......

java ÇóÖú - Java / Java EE

insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ