JAVA´æ´¢¹ý³ÌºÍµ÷ÓÃ
´úÂëÄÚÈÝ
create or replace procedure batchUpdateCustomer(p_age in number) as
begin
update CUSTOMERS set AGE=AGE+1 where AGE>p_age;
end;
ÒÔÉÏ´æ´¢¹ý³ÌÓÐÒ»¸ö²ÎÊýp_age£¬´ú±í¿Í»§µÄÄêÁ䣬ӦÓóÌÐò¿É°´ÕÕÒÔÏ·½Ê½µ÷Óô洢¹ý³Ì£º
´úÂëÄÚÈÝ
tx = session.beginTransaction();
Connection con=session.connection();
String procedure = "{call batchUpdateCustomer(?) }";
CallableStatement cstmt = con.prepareCall(procedure);
cstmt.setInt(1,0); //°ÑÄêÁä²ÎÊýÉèΪ0
cstmt.executeUpdate();
tx.commit();
create or replace produre batchUpdateStudent(a in number) as
begin
update STUDENT set AGE=AGE+1 where AGE>a;
end;
µ÷ÓôúÂëÈçÏ£º
Transaction tx=session.beginSession();
Connection conn=session.connection();
String pd=”...{call batchUpdateStudent(?)}”;
CallableStatement cstmt=conn.PrepareCall(pd);
cstmt.setInt(1,20); //°ÑÄêÁäÕâ¸ö²ÎÊýÉèΪ20
tx.commit()£»
Ïà¹ØÎĵµ£º
ϱßÊÇ×Ô¼º¶ÔÀàµÄһЩʹÓÃÈÏʶ£¬Èç¹ûÓв»¶ÔµÄ£¬¾´Çë´ïÈËÖ¸Õý¡£
ÈκÎÀàµÄʹÓö¼¾Àú£ºÀà¼ÓÔغÍÀà³õʼ»¯µÄ½×¶Î¡£
Àà³õʼ»¯:
*ÆÕͨ³ÉÔ±ÊôÐÔ£º
1.ϵͳĬÈϳõʼ»¯£¬»ù±¾ÀàÐÍĬÈÏΪ0»òfalse£¬ÒýÓÃÀàÐÍĬÈÏΪnull¡£
2.ÉùÃ÷ʱÏÔʾ³õʼ»¯»òÆÕͨ³õʼ»¯¿é(×¢Ò⣺ÆÕͨ³õʼ»¯Ö»ÓÐÔÚnew¹¹Ô캯Êý´´½¨ÊµÀýʱ£¬²Å»á±»×Ô¶¯µ÷ ......
ÒÔÇ°ÔÚ¼ÒÌýÕÅТÏéÀÏʦµÄÊÓƵʱ,ÂÅ´ÎÌýµ½ÕÅÀÏʦ½²µ½ÕÆÎÕJAVA»ù´¡¶ÔÓÚÎÒÃÇÒªÀ´´«ÖDzμӾÍÒµÅàѵҪѧϰµÄпγ̵ÄÖØÒª.ÏÖÔÚ¿´À´,ÕâЩ»°ÕæµÄÒ»µã¶¼²»Îª¹ý!ÓÐЩͬѧ»òÐíûÓÐÉî¿ÌÈÏʶÕÅÀÏʦ˵µÄÕâ·¬»°,×Ô¼ºÆ½Ê±¶¯ÊÖÓÖÌ«ÉÙ.¾ÍÄÃÏÖÔÚѧµÄ¾ÍÒµÅàѵ°àµÄ¿Î³ÌÀ´Ëµ,JAVA¿ª·¢ÓõŤ¾ßÏñMYECLIPSEµÈ,ÆäʹÓÃÕæµÄÊÇÈÃÈ˸е½¾ªÏ²,ÒÔÇ°ÕÅÀÏʦÔÚ ......
1 ÒýÑÔ
JavaµÄÒ»¸öÖØÒªÓŵã¾ÍÊÇͨ¹ýÀ¬»øÊÕ¼¯Æ÷GC £¨Garbage Collection£©×Ô¶¯¹ÜÀíÄÚ´æµÄ»ØÊÕ£¬³ÌÐòÔ±²»ÐèҪͨ¹ýµ÷Óú¯ÊýÀ´ÊÍ·ÅÄÚ´æ¡£Òò´Ë£¬ºÜ¶à³ÌÐòÔ±ÈÏΪJava ²»´æÔÚÄÚ´æй©ÎÊÌ⣬»òÕßÈÏΪ¼´Ê¹ÓÐÄÚ´æй©Ҳ²»ÊdzÌÐòµÄÔðÈΣ¬¶øÊÇGC »òJVMµÄÎÊÌâ¡£Æäʵ£¬ÕâÖÖÏë·¨ÊDz»ÕýÈ·µÄ£¬ÒòΪJava Ò²´æÔÚÄÚ´æ ......
ÏÂÊöÊ®Ëĸö¼¼ÇÉ£¬ÊÇÐí¶àÈËÔÚ´óÁ¿µÄÊý¾Ý¿â·ÖÎöÓëÉè¼Æʵ¼ùÖУ¬Öð²½×ܽá³öÀ´µÄ¡£¶ÔÓÚÕâЩ¾ÑéµÄÔËÓ㬶ÁÕß²»ÄÜÉú°ïÓ²Ì×£¬ËÀ¼ÇÓ²±³£¬¶øÒªÏû»¯Àí½â£¬ÊµÊÂÇóÊÇ£¬Áé»îÕÆÎÕ¡£²¢Öð²½×öµ½£ºÔÚÓ¦ÓÃÖз¢Õ¹£¬ÔÚ·¢Õ¹ÖÐÓ¦Óá£
1. Ôʼµ¥¾ÝÓëʵÌåÖ®¼äµÄ¹Øϵ
¡¡¡¡
  ......
ÓÐÈçÏÂÇé¿öÏ¿ÉÒÔÓõ½ÄÚ´æÎļþÓ³Éä¼¼Êõ½â¾öÎÊÌâ:
1.²»Òª¸´ÖÆÎļþÖÐËùÓеÄÊý¾Ý£¬Ö»ÐèÒªÐÞ¸ÄÎļþÖоֲ¿µÄÊý¾Ý¡£
2.²¢ÐÐ\·Ö¶Î´¦Àí´óÎļþ¡£
ÈçÏ´úÂëʾʹÓÃjavaNIO¾Ö²¿ÐÞ¸ÄÎļþÖÐÖ¸¶¨Î»ÖõIJ¿·ÖÊý¾Ý£º
Java´úÂë
/**
* ÐÞ¸ÄÎļþÖеÄijһ²¿·ÖµÄÊý¾ ......