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
Ïà¹ØÎĵµ£º
һЩÆóÒµÔÚÕÐÆ¸³ÌÐòÔ±µÄʱºò£¬×Ü»áÌØÒâÌá³öÒ»¸öÒªÇ󣬼´ÒªÇó¾ßÓÐÁ¼ºÃµÄ±àÂë¹æ·¶¡£È·ÊµÏÖÔÚ³ÌÐò¿ª·¢ÈËÔ±ÒѾ²»ÔÚÊǵ¥Ç¹Æ¥ÂíµÄµ¥¸É£¬¶øÊǽ²¾¿ÍÅÌå×÷Õ½¡£´Ëʱ¾ÍÒªÇóÍŶÓÄڵijËÔ±¶¼¿ÉÄܹ»ã¡ÊØ´úÂëµÄ±àд¹æ·¶£¬Õâ¶ÔÓÚ³ËÔ±Ö®¼ä¹²Ïí´úÂë¡¢ÅÅ´íµÈ×÷Òµ¶¼¾ßÓзdz£ÏÖʵµÄÒâÒå¡£ÕâÔÚJavaÓïÑÔÖе±È»Ò²²»ÀýÍâ¡£±ÊÕß½èÕâ´Î»ú»á£¬ ......
ÔÌùµØÖ·http://www.javaeye.com/topic/257191
½ñÌìÏÂÎçÑо¿Á˰ëÌìhashcode()ºÍequals()·½·¨£¬ÖÕÓÚÓÐÁËÒ»µãµãµÄÃ÷°×£¬Ð´ÏÂÀ´Óë´ó¼Ò·ÖÏí£¨zhaoxudong
2008.10.23Íí21.36£©¡£
1. Ê×ÏÈequals()ºÍhashcode()ÕâÁ½¸ö·½·¨¶¼ÊÇ´ÓobjectÀàÖм̳йýÀ´µÄ¡£
equals()·½·¨ÔÚobjectÀàÖж¨ÒåÈçÏ£º
public boolean equals( ......
Ò»¡¢´´½¨ÈÎÎñ
ÈÎÎñ¿ÉÒÔÀí½âΪһ¶Î¶ÀÁ¢Ö´ÐеĴúÂ룬ËüÍê³ÉÒ»¶¨µÄ¹¦ÄÜ¡£
ÔÚJava 5¼°ÒÔÉϰ汾Öв»½ö¿ÉÒÔÀûÓà Runnable½Ó¿Ú£¬»¹¿ÉÒÔÀûÓÃCallable½Ó¿Ú¡£
Á½ÖÖÈÎÎñµÄÇø±ð£ºRunnable µÄrun()·½·¨Íê³ÉµÄÈÎÎñÊÇûÓзµ»ØÖµµÄ - void
¶øCallable µÄcall()·½·¨Íê³ÉµÄÈÎÎñÊÇÓзµ»ØÖ ......
×÷Õß : ÀîÖ¾ÌÎ
ÓÊÏ䵨ַ :lizhitao67116961@163.com
ÉîÛÚÓÅÍø¿Æ¼¼ÓÐÏÞ¹«Ë¾
ǰ¼¸Ìì¿´µ½ÓÐÄ³Î»ÍøÓÑдÁËÓÃhttp½øÐжϵãÏÂÔØÎļþ£¬µ«ÊÇÍøÉÏûÓп´µ½ftp¶ÏµãÏÂÔØµÄÎÄÕ»ò´úÂ룬ÏÖÔÚ±¾ÈËдÁËһϡ£¾¹ý²âÊÔûÓÐÎÊÌâ¡£Çë´ó¼Ò¶à¶àÖ¸½Ì¡£ÈçÓÐÊ詵ĵط½Çë¸÷λ¼¼ÊõÓÑÈËÖ¸³ö¡£±¾È˲»Ê¤¸Ð¼¤¡£
package t ......
Java 6 RowSet ʹÓÃÍêÈ«ÆÊÎö(1)
¹Ø¼ü×Ö: rowset
javax.sql.rowset ×Ô JDK 1.4 ÒýÈ룬´Ó JDK 5.0 ¿ªÊ¼ÌṩÁ˲ο¼ÊµÏÖ¡£ËüÖ÷Òª°üÀ¨ CachedRowSet£¬WebRowSet£¬FilteredRowSet£¬JoinRowSet ºÍ JdbcRowSet¡£ ³ýÁË JdbcRowSet ÒÀÈ»±£³Ö×ÅÓëÊý¾ÝÔ´µÄÁ¬½ÓÖ®Í⣬ÆäÓàËĸö¶¼ÊÇ Disconnected RowSet¡£
Ïà±È½Ï java.sql.ResultSet ......