Java 6 RowSet ʹÓÃÍêÈ«ÆÊÎö(3)
	
    
    
	Java 6 RowSet ʹÓÃÍêÈ«ÆÊÎö(3)
¹Ø¼ü×Ö: rowset 
Çåµ¥ 24. Çåµ¥ 23 ÖеĴúÂëÖ´Ðнá¹û
1 Tom Tom is VIP. 2 Jim null
ÏÂÃæÒ»½ÚÀïÎÒÃǽ«»á¿´µ½ JdbcRowSet ÈçºÎ×÷Ϊһ¸ö RowSet ºÍÆäËûµÄ RowSet Ò»ÆðʹÓá£
ʹÓà JoinRowSet
Ö§³ÖµÄÁªºÏ·½Ê½
JoinRowSet ½Ó¿ÚÖжÔÎåÖÖ²»Í¬µÄÁªºÏ·½Ê½¶¼¶¨ÒåÁ˶ÔÓ¦µÄ³£ÊýºÍÅжϸÃʵÏÖÊÇ·ñÖ§³ÖµÄ·½·¨£¬ÈçϱíËùʾ¡£
±í 5. ÎåÖÖÁªºÏ·½Ê½ 
ÁªºÏ·½Ê½ ¶ÔÓ¦µÄ³£Êý ÅжÏÊÇ·ñÖ§³ÖµÄ·½·¨£¨·µ»Ø²¼¶ûÖµ£© 
ÄÚÁ¬½Ó£¨INNER JOIN£© JoinRowSet.INNER_JOIN supportsInnerJoin() 
×óÍâÁ¬½Ó£¨LEFT OUTER JOIN£©  JoinRowSet.LEFT_OUTER_JOIN supportsLeftOuterJoin() 
ÓÒÍâÁ¬½Ó£¨RIGHT OUTER JOIN£©  JoinRowSet.RIGHT_OUTER_JOIN supportsRightOuterJoin()  
È«ÍâÁ¬½Ó£¨FULL OUTER JOIN£© JoinRowSet.FULL_JOIN supportsFullJoin() 
½»²æÁ¬½Ó£¨CROSS JOIN£©  JoinRowSet.CROSS_JOIN supportsCrossJoin() 
ͬʱ»¹ÓÐÁ½¸ö·½·¨£¬getJoinType() ·µ»Øµ±Ç°µÄÁªºÏ·½Ê½£¬setJoinType(int) ÉèÖÃÁªºÏ·½Ê½¡£ÖµµÃ×¢ÒâµÄÊÇ£¬Java 5 ºÍ Java 6 Öж¼Ö§³ÖÄÚÁ¬½Ó (INNER JOIN) ÕâÒ»ÖÖÁªºÏ·½Ê½¡£ÔÚ setJoinType ·½·¨Öд«Èë³ý Inner_Join ÒÔÍâµÄÈκÎÒ»ÖÖÁªºÏ·½Ê½¶¼»áÅ׳ö UnsupportedOperationException µÄÒì³£¡£
ÁíÍâÒ»µãÐèҪעÒâµÄ£¬ËäȻĬÈϵÄÁªºÏ·½Ê½¾ÍÊÇÄÚÁ¬½Ó£¬µ«ÊÇÔÚûÓÐÏÔʾµÄµ÷Óà setJoinType() ֮ǰµ÷Óà getJoinType() »áÅ׳ö ArrayIndexOutOfBoundsException µÄÒì³£¡£ ËùÒÔÒ»°ãÀ´½²£¬ÎÒÃÇ¿ÉÒÔ²»ÐèÒªµ÷ÓÃÕ⼸¸ö·½·¨¶øÖ±½ÓÈÏΪ JoinRowSet ĬÈϲ¢ÇÒÖ»ÔÊÐíµÄÁªºÏ·½Ê½¾ÍÊÇÄÚÁ¬½Ó(INNER JOIN)¡£
ÈçºÎÁªºÏ¸÷ÖÖ RowSet
ÁªºÏ¶à¸ö RowSet µÄ·½·¨Æäʵ¾ÍÊÇÍùÒ»¸ö JoinRowSet Àïµ÷Óà add ·½·¨Ìí¼ÓÆäËû RowSet£¨Õâ¸ö RowSet ¿ÉÒÔÊÇÉÏÃæÌáµ½µÄÎåÖÖ RowSet ÖеÄÈÎÒâÒ»ÖÖ£¬°üÀ¨ÀëÏß²Ù×÷µÄ JdbcRowSet ºÍ JoinRowSet ±¾Éí£©µÄ¹ý³Ì¡£Ìí¼ÓÒ»¸ö RowSet µÄͬʱҲ±ØÐëÖÆ¶¨ÁªºÏʱƥÅäµÄÁС£JoinRowSet ½Ó¿ÚÖÐÌṩÁËÒÔϼ¸¸ö add ·½·¨£º
addRowSet(Joinable rowset) 
addRowSet(RowSet[] rowset, int[] columnIdx) 
addRowSet(RowSet[] rowset, String[] columnName) 
addRowSet(RowSet rowset, int columnIdx) 
addRowSet(RowSet rowset, String columnName) 
ÏÂÃæÊÇÒ»¸öÁªºÏÒ»¸ö JdbcRowSet ºÍÒ»¸ö CachedRowSet µÄ¼òµ¥Àý×Ó¡£
Çåµ¥ 25. ʹÓà JoinRowSet
// ¹¹ÔìÒ»¸öCachedRowSet²¢ÇÒÌî³äCUSTOMERS±íÖеÄÊý¾Ý¡£ 
Java´úÂë 
C
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Ò»¸öJava³ÌÐòÔ±Ó¦¸ÃÕÆÎÕµÄ10Ïî¼¼ÄÜ
1¡¢Óï·¨£º±ØÐë±È½ÏÊìϤ£¬ÔÚд´úÂëµÄʱºòIDEµÄ±à¼Æ÷¶ÔijһÐб¨´íÓ¦¸ÃÄܹ»¸ù¾Ý±¨´íÐÅÏ¢ÖªµÀÊÇʲôÑùµÄÓï·¨´íÎó²¢ÇÒÖªµÀÈκÎÐÞÕý¡£
2¡¢ÃüÁ±ØÐëÊìϤJDK´øµÄһЩ³£ÓÃÃüÁî¼°Æä³£ÓÃÑ¡ÏÃüÁîÖÁÉÙÐèÒªÊìϤ£ºappletviewer¡¢ HtmlConverter¡¢jar¡¢ java¡¢javac¡¢javadoc¡¢javap¡¢javaw¡¢nati ......
	
    
        
    
    Ô·¢±íÓÚhttp://saharabear.javaeye.com
 ºÍhttp://www.haulynjason.net(Ó¢)
ͬʱ·¢±íÔÚÕâÀï.
ÔÚÎÒÖÜΧ,ÓкܶàÈËÊÇJava³ÌÐòÔ±»òÕß¼ÆËã»úרҵµÄѧÉú.ÓÐʱ,ÎÒ°ïËûÃǵ÷ÊÔ³ÌÐòµÄʱºò,·¢ÏÖËûÃǵĻúÆ÷ÉÏ×ÜÊǰ²×°×źܶàûÓÐÊÚȨµÄ¹¤¾ß,±ÈÈçµÁ°æµÄ
windows,ûÓÐLicenseµÄMyEclipseµÈ,ÉõÖÁÓÐһЩÈË·Ö²»ÇåeclipseºÍmyeclipse ......
	
    
        
    
    
Ò»¡¢´´½¨ÈÎÎñ
 
ÈÎÎñ¿ÉÒÔÀí½âΪһ¶Î¶ÀÁ¢Ö´ÐеĴúÂ룬ËüÍê³ÉÒ»¶¨µÄ¹¦ÄÜ¡£
ÔÚJava 5¼°ÒÔÉϰ汾Öв»½ö¿ÉÒÔÀûÓà Runnable½Ó¿Ú£¬»¹¿ÉÒÔÀûÓÃCallable½Ó¿Ú¡£
    Á½ÖÖÈÎÎñµÄÇø±ð£ºRunnable µÄrun()·½·¨Íê³ÉµÄÈÎÎñÊÇûÓзµ»ØÖµµÄ - void
    ¶øCallable µÄcall()·½·¨Íê³ÉµÄÈÎÎñÊÇÓзµ»ØÖ ......
	
    
        
    
    
×÷Õß
:
ÀîÖ¾ÌÎ
ÓÊÏ䵨ַ
:lizhitao67116961@163.com
ÉîÛÚÓÅÍø¿Æ¼¼ÓÐÏÞ¹«Ë¾
 
ǰ¼¸Ìì¿´µ½ÓÐÄ³Î»ÍøÓÑдÁËÓÃhttp½øÐжϵãÏÂÔØÎļþ£¬µ«ÊÇÍøÉÏûÓп´µ½ftp¶ÏµãÏÂÔØµÄÎÄÕ»ò´úÂ룬ÏÖÔÚ±¾ÈËдÁËһϡ£¾¹ý²âÊÔûÓÐÎÊÌâ¡£Çë´ó¼Ò¶à¶àÖ¸½Ì¡£ÈçÓÐÊ詵ĵط½Çë¸÷λ¼¼ÊõÓÑÈËÖ¸³ö¡£±¾È˲»Ê¤¸Ð¼¤¡£
 
package
test.d ......