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
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
È磺 @superwaring("unchecked");
Õâ¸öÀïÃ涼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£
¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......