|
JavaTM 2 Platform Standard Ed. 5.0 |
|||||||||
ÀÌÀü Ŭ·¡½º ´ÙÀ½ Ŭ·¡½º | ÇÁ·¹ÀÓÀ¸·Î ÇÁ·¹ÀÓ ¾øÀÌ | |||||||||
°³¿ä: NESTED | Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå | »ó¼¼: Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå |
public interface JoinRowSet
JoinRowSet
ÀÎÅÍÆäÀ̽º´Â ´Ù¸¥ RowSet
°´Ã¼ÀÇ °ü·Ã µ¥ÀÌÅ͸¦, SQL JOIN
¸¦ ³ªÅ¸³»´Â 1°³ÀÇ JoinRowSet
°´Ã¼¿¡ Á¤¸®ÇÏ´Â µµ±¸¸¦ Á¦°øÇÕ´Ï´Ù. Áï, JoinRowSet
°´Ã¼´Â
SQL JOIN
°ü°è¸¦ Çü¼ºÇÏ´Â RowSet
°´Ã¼·ÎºÎÅÍÀÇ µ¥ÀÌÅÍÀÇ ÄÁÅ×À̳ʷμ µ¿ÀÛÇÕ´Ï´Ù.
Joinable
ÀÎÅÍÆäÀ̽º´Â SQL JOIN
°ü°è È®¸³ÀÇ ±â¹ÝÀÌ µÇ´Â ÀÏÄ¡¿ÀÇ ¼³Á¤, Ãëµæ ¹× ¼³Á¤ ÇØÁ¦ÀÇ ¸Þ¼µå¸¦ Á¦°øÇÕ´Ï´Ù. ¶Ç´Â ÀÏÄ¡¿Àº JointRowSet
addRowSet
¸Þ¼µåÀÇ ÀûÀýÇÑ ¹öÀüÀ» ÁöÁ¤ÇÏ´Â °Í¿¡
Çصµ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
RowSet
°´Ã¼ (CachedRowSet
°´Ã¼¿ÍCachedRowSet
ÀÎÅÍÆäÀ̽º¸¦ È®ÀåÇÏ´Â ±¸Çö)´Â µ¥ÀÌÅÍ ¼Ò½º¿¡ ÀçÁ¢¼ÓÇÏ´Â ¼ö°í¾øÀÌ, RowSet
°´Ã¼°£¿¡ SQL JOIN
¸¦ È®¸³Çϴ ǥÁØÀÇ ¹æ¹ýÀ» °¡ÁöÁö ¾Ê½À´Ï´Ù. JoinRowSet
ÀÎÅÍÆäÀ̽º´Â ÀÌ ¿ä±¸¿¡ ´ëÀÀÇϱâ À§Çؼ ¼³°èµÇ°í ÀÖ½À´Ï´Ù.
Joinable
°´Ã¼¿¡ RowSet
°´Ã¼¸¦ Ãß°¡ÇØ, SQL JOIN
°ü°è¸¦ ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. Áï, RowSet
°´Ã¼´Â
Á¢¼ÓµÇ°í ÀÖ´Â °æ¿ì¿¡¼µµ ¹ÌÁ¢¼ÓÀÇ °æ¿ì¿¡¼µµ, JOIN
¸¦ ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù
. Á¢¼Ó ȯ°æ¿¡¼ µ¿ÀÛÇÏ´Â RowSet
°´Ã¼ (JdbcRowSet
°´Ã¼)´Â À̹Ì
Á¢¼ÓÇÏ°í ÀÖ´Â µ¥ÀÌŸº£À̽º¸¦ »ç¿ëÇØ, Ç¥°£¿¡ Á÷Á¢ SQL JOIN
°ü°è¸¦ È®¸³ÇÏ´Â °ÍÀ» ÃßõÇÕ´Ï´Ù. ±×·¯³ª, ÇÊ¿ä¿¡ µû¶ó¼, JoinRowSet
°´Ã¼¿¡ JdbcRowSet
°´Ã¼¸¦ Ãß°¡ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
´ÜÀÏÀÇ SQL JOIN
¿¡ °ü·ÃµÈ
JoinRowSet
ÀνºÅϽºÀ̸é, ÀÓÀÇÀÇ ¼öÀÇ RowSet
°´Ã¼¸¦ JoinRowSet
ÀνºÅϽº¿¡ Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. Á¤ÀÇ¿¡ÀÇÇϸé SQL JOIN
¹®Àº º¹¼öÀÇ RDB Å×ÀÌºí¿¡ Æ÷ÇÔµÈ µ¥ÀÌÅ͸¦, °øÅëÀÇ ¼Ó¼º¿¡ ±Ù°ÅÇØ Á¤¸®Çϱâ À§Çؼ »ç¿ëµË´Ï´Ù. Joinable
ÀÎÅÍÆäÀ̽º´Â ¡¸ÀÏÄ¡¿¡¹ÀÇ ¼³Á¤¿¡ ÀÇÇØ °øÅë ¼Ó¼ºÀ» ÀÛ¼ºÇÏ´Â ¸Þ¼µå¸¦ Á¦°øÇÕ´Ï´Ù. ÀÏÄ¡¿Àº ÀϹÝÀûÀ¸·Î ÁÖÅ°¿Í ÀÏÄ¡ÇÕ´Ï´Ù¸¸, ¹Ýµå½Ã ÀÏÄ¡¿ÀÌ ÁÖÅ°¿Í µ¿ÀÏÇÑ ÇÊ¿ä´Â ¾ø½À´Ï´Ù. ¿ÀÇ ÀÏÄ¡¸¦ È®¸³ÇØ, Àû¿ëÇÏ´Â °ÍÀ¸·ÎJoinRowSet
°´Ã¼´Â
»ç¿ë °¡´ÉÇÑ RDB¸¦ »ç¿ëÇÏÁö ¾Ê°í,
RowSet
°´Ã¼°£¿¡ JOIN
°ü°è¸¦ È®¸³ÇÕ´Ï´Ù.
È®¸³µÇ´Â JOIN
ÇüÅ´ setJoinType
¸Þ¼µå¸¦ »ç¿ëÇØ JoinRowSet
Á¤¼ö¸¦ 1°³
¼³Á¤ÇÏ´Â °ÍÀ¸·Î °áÁ¤µË´Ï´Ù. ´ÙÀ½ÀÇ SQL JOIN
ÇüÀ» ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
CROSS_JOIN
FULL_JOIN
INNER_JOIN
- JOIN
ÇüÀÌ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ìÀÇ µðÆúÆ®
LEFT_OUTER_JOIN
RIGHT_OUTER_JOIN
JOIN
´Â ÀÚµ¿ÀûÀ¸·Î ³»ºÎ °áÇÕÀÌ µË´Ï´Ù. JoinRowSet
ÀÎÅÍÆäÀ̽ºÀÇ ÇʵåÀÇ ÄÚ¸àÆ®¿¡
Ç¥ÁØ SQL JOIN
ÇüÀÎ ÀÌ·¯ÇÑ JOIN
ÇüÀÌ ¼³¸íµÇ°í ÀÖ½À´Ï´Ù.
JoinRowSet
°´Ã¼¿¡
ÇÑ JOIN
ÀÛ¼ºJoinRowSet
°´Ã¼ÀÇ ÀÛ¼º½Ã¿¡´Â ÀÌ °´Ã¼´Â ºñ¾îÀÖ´Â »óÅÂÀÔ´Ï´Ù. ÃÖÃÊ·Î Ãß°¡µÈ RowSet
°´Ã¼°¡ JOIN
°ü°èÀÇ ±â¹ÝÀ¸·Î µË´Ï´Ù. ¾îÇø®ÄÉÀ̼ǿ¡¼´Â JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇÏ´Â °¢ RowSet
°´Ã¼ÀÇ ¾î´À ¿À» ÀÏÄ¡¿·Î Çұ °áÁ¤ÇÒ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. ¸ðµç RowSet
°´Ã¼¿¡ ÀÏÄ¡¿ÀÌ Æ÷ÇÔµÇ¾î °¢ ÀÏÄ¡¿ÀÇ °ªÀº ´Ù¸¥ ÀÏÄ¡¿ÀÇ °ª°ú ºñ±³ °¡´ÉÇÑ °ªÀÏ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. ¿¿¡´Â °°Àº À̸§À» ºÙÀÌ´Â °ÍÀÌ ¸¹½À´Ï´Ù¸¸, ±× ÇÊ¿ä´Â ¾ø°í, ºñ±³ °¡´ÉÇÑ µ¥ÀÌÅÍÇüÀ̸é, ÀüÇô °°Àº µ¥ÀÌÅÍÇüÀ» Æ÷ÇÔÇÒ ÇÊ¿äµµ ¾ø½À´Ï´Ù.
ÀÏÄ¡¿Àº ´ÙÀ½ÀÇ 2 Åë°úÇØ ¹æ¹ýÀ¸·Î ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Joinable
setMatchColumn
¸Þ¼µåÀÇ È£Ãâ¿¡
ÇÑ ¼³Á¤. RowSet
°´Ã¼¸¦ JoinRowSet
°´Ã¼¿¡ Ãß°¡Çϱâ Àü¿¡ ÀÏÄ¡¿À» ¼³Á¤ÇÒ ¼ö ÀÖ´Â À¯ÀÏÇÑ ¹æ¹ýÀÔ´Ï´Ù. setMatchColumn
¸Þ¼µå¸¦ »ç¿ëÇÏ·Á¸é,
RowSet
°´Ã¼°¡ Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÏ°í ÀÖÀ» ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. ÀÏÄ¡·ÄÄ¡¸¦ ¼³Á¤Çϸé, ÀÌ ¸Þ¼µå¸¦ »ç¿ëÇØ, ¾ðÁ¦¶óµµ ÀÏÄ¡¿À» ¸®¼Â ÇÒ ¼ö ÀÖ½À´Ï´Ù. JoinRowSet
addRowSet
¸Þ¼µåÀÇ ¸î°³ÀÇ ¹öÀüÀÇ È£Ãâ¿¡
ÇÑ ¼³Á¤. addRowSet
¸Þ¼µåÁß 4 °³´Â ÀÏÄ¡¿À» ÆĶó¹ÌÅÍ¿¡ ÃëÇÕ´Ï´Ù. ÀÌ·¯ÇÑ 4°³ÀÇ ¸Þ¼µå´Â RowSet
°´Ã¼°¡ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÉ ¶§, ÀÏÄ¡¿À» ¼³Á¤ ¶Ç´Â ¸®¼Â ÇÕ´Ï´Ù.
´ÙÀ½ÀÇ ÄÚµåÀÇ ¹ßÃé¿¡¼´Â JoinRowSet
°´Ã¼¿¡ 2°³ÀÇ CachedRowSet
°´Ã¼¸¦ Ãß°¡ÇÕ´Ï´Ù. ÀÌ ¿¹¿¡¼´Â SQL JOIN
ÇüÀº ¾Æ´Ï°í, µðÆúÆ®ÀÇ JOIN
ÇüÀÎ INNER_JOIN°¡ È®¸³µÇ¾î ÀÖ´Â Á¡¿¡ ÁÖ¸ñÇØ ÁÖ¼¼¿ä.
´ÙÀ½ÀÇ ÄÚµåÀÇ ¹ßÃé¿¡¼´Â °Ñ(Ç¥) EMPLOYEES
(ÃÖÃÊÀÇ ¿ EMP_ID
°¡ ÀÏÄ¡¿·Î ¼³Á¤µÇ¾î ÀÖ´Ù)°¡JoinRowSet
°´Ã¼ jrs¿¡ Ãß°¡µË´Ï´Ù. °è¼ÓµÇ¾î, °Ñ(Ç¥) ESSP_BONUS_PLAN
(ÀÏÄ¡¿Àº °°ÀÌ EMP_ID
¿)°¡ Ãß°¡µË´Ï´Ù. ÀÌ 2¹ø°ÀÇ °Ñ(Ç¥)°¡ jrs¿¡ Ãß°¡µÉ ¶§, Ãß°¡µÇ´Â °ÍÀº °Ñ(Ç¥) EMPLOYEES
³»ÀÇ EMP_ID
Ä¡¿¡ ÀÏÄ¡ÇÑ EMP_ID
°ªÀ» °¡Áö´Â ESSP_BONUS_PLAN
³»ÀÇ ¿ »ÓÀÔ´Ï´Ù. ÀÌ °æ¿ì
º¸³Ê½º Á¦µµ (bonus plan)ÀÇ Àü¿øÀÌ Á¾¾÷¿ø (employee)À̱⠶§¹®¿¡
°Ñ(Ç¥) ESSP_BONUS_PLAN
¸ðµç ÇàÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µË´Ï´Ù. ÀÌ ¿¹¿¡¼´Â Ãß°¡µÇ´Â ¾çÂÊ ¸ðµÎÀÇ CachedRowSet
°´Ã¼°¡ Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÏ°í Àֱ⠶§¹®¿¡
Joinable
setMatchColumn
¸Þ¼µå¸¦ È£ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù
.
JoinRowSet jrs = new JoinRowSetImpl(); ResultSet rs1 = stmt.executeQuery("SELECT * FROM EMPLOYEES"); CachedRowSet empl = new CachedRowSetImpl(); empl.populate(rs1); empl.setMatchColumn(1); jrs.addRowSet(empl); ResultSet rs2 = stmt.executeQuery("SELECT * FROM ESSP_BONUS_PLAN"); CachedRowSet bonus = new CachedRowSetImpl(); bonus.populate(rs2); bonus.setMatchColumn(1); // EMP_ID is the first column jrs.addRowSet(bonus);
ÀÌ ½ÃÁ¡¿¡¼
jrs´Â
2°³ÀÇ RowSet
°´Ã¼ÀÇ EMP_ID
¿¿¡ ±Ù°ÅÇÏ´Â ³»ºÎ JOIN°¡ µË´Ï´Ù. ¾îÇø®ÄÉÀ̼ÇÀº ¸¶Ä¡ ´ÜÀÏÀÇ RowSet
°´Ã¼¸¦ ºê¶ó¿ìÁî ÇÏ´Â°Í °°ÀÌ ÇØ, °áÇÕµÈ µ¥ÀÌÅ͸¦ ºê¶ó¿ìÁî ÇÒ ¼ö ÀÖ½À´Ï´Ù. jrs ÀÚü°¡ RowSet
°´Ã¼À̹ǷΠ¾îÇø®ÄÉÀ̼ÇÀº, RowSet
¸Þ¼µå¸¦ »ç¿ëÇØ, jrs
¾È³»³ª º¯°æÀ» ½Ç½ÃÇÒ ¼ö ÀÖ½À´Ï´Ù
.
jrs.first(); int employeeID = jrs.getInt(1); String employeeName = jrs.getString(2);
¾îÇø®ÄÉÀ̼ÇÀÌ 2¹ø° ¶Ç´Â ÈļÓÀÇ RowSet
°´Ã¼¸¦ Ãß°¡ÇÏ´Â °æ¿ì´Â SQL JOIN
¸¦ Àû¿ëÇÒ ÇÊ¿ä°¡ ÀÖÀ¸¹Ç·ÎJOIN
½ÇÇà½Ã¿¡ Ãʱâ ÆÛÆ÷¸Õ½º°¡ ÀúÇÏÇÒ °¡´É¼ºÀÌ ÀÖ½À´Ï´Ù.
´ÙÀ½ÀÇ ÄÚµåÀÇ ¹ßÃé´Â ±× ¿ÜÀÇ CachedRowSet
°´Ã¼¸¦ Ãß°¡ÇÕ´Ï´Ù. ÀÌ ¿¹¿¡¼´Â JoinRowSet
°´Ã¼¿¡ CachedRowSet
ÀÌ Ãß°¡µÉ ¶§, ÀÏÄ¡¿ (EMP_ID
)ÀÌ ¼³Á¤µË´Ï´Ù.
ResultSet rs3 = stmt.executeQuery("SELECT * FROM 401K_CONTRIB"); CachedRowSet fourO1k = new CachedRowSetImpl(); four01k.populate(rs3); jrs.addRowSet(four01k, 1);
JoinRowSet
°´Ã¼ jrs ¿¡
3°³ÀÇ °Ñ(Ç¥)ÀÇ °ªÀÌ ¸ðµÎ Ãß°¡µÇ¾ú½À´Ï´Ù. EMP_ID
¿ÀÇ °ªÀÌ jrs ³»ÀÇ EMP_ID
¿ÀÇ °ª°ú ÀÏÄ¡ÇÏ°í ÀÖ´Â four01k ³»ÀÇ °¢ ÇàÀÇ µ¥ÀÌÅÍ°¡jrs¿¡ Ãß°¡µÇ°í ÀÖ½À´Ï´Ù.
JoinRowSet
¸Þ¼µåJoinRowSet
ÀÎÅÍÆäÀ̽º´Â RowSet
°´Ã¼ÀÇ Ãß°¡³ª JoinRowSet
°´Ã¼ÀÇ Á¤º¸ÀÇ ÃëµæÀ» ½Ç½ÃÇÏ´Â º¹¼öÀÇ ¸Þ¼µå¸¦ Á¦°øÇÕ´Ï´Ù.
RowSet
°´Ã¼¸¦ Ãß°¡ÇÏ´Â ¸Þ¼µåRowSet
°´Ã¼¸¦ Ãß°¡ÇÏ´Â Àϵµ, ¶Ç´Â µ¿½Ã¿¡ º¹¼öÀÇ RowSet
°´Ã¼¸¦ Ãß°¡ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ¾î´À ÂÊÀÇ °æ¿ì¿¡¼µµ, ¸Þ¼µå´Â Ãß°¡µÇ´Â °¢ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿À» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
JoinRowSet
°´Ã¼³»ÀÇ RowSet
°´Ã¼¸¦ ¾ò´Â ¸Þ¼µå, RowSet
¸íÀ» ¾ò´Â ¸Þ¼µå¿Ü, JOIN
¸¦ ±¸¼ºÇϱâ À§Çؼ ¹èÈÄ¿¡¼ »ç¿ëµÇ´Â SQL WHERE
ÀýÀΰ¡WHERE
ÀýÀÇ ½ÇÇà ³»¿ëÀ» ¼³¸íÇÏ´Â ÅؽºÆ®¸¦ ¾ò´Â ¸Þ¼µå°¡ ÀÖ½À´Ï´Ù.
JOIN
ÇüÅ¿¡ °ü·ÃµÈ ¸Þ¼µåJOIN
ÇüÀ» ¼³Á¤ÇÏ´Â ¸Þ¼µå°¡ 1°³, JoinRowSet
°´Ã¼°¡ ÁöÁ¤µÈ ÇüŸ¦ Áö¿ø
ÇÒÁö ¾î¶³Áö¸¦ È®ÀÎÇÏ´Â ¸Þ¼µå°¡ 5 °³ ÀÖ½À´Ï´Ù.
JoinRowSet
°´Ã¼ÀÇ º¹»çº»À» ÀÛ¼ºÇÏ´Â ¸Þ¼µå
ÇÊµå °³¿ä | |
---|---|
static int |
CROSS_JOIN
2°³ÀÇ °Ñ(Ç¥)ÀÇ Å©·Î½º Á¦Ç°À» Á¦°øÇÏ´Â ANSI Çü JOIN ÀÔ´Ï´Ù. |
static int |
FULL_JOIN
¿ÏÀü JOIN¸¦ Á¦°øÇÏ´Â ANSI Çü JOIN ÀÔ´Ï´Ù. |
static int |
INNER_JOIN
2°³ÀÇ °Ñ(Ç¥)¸¦ ³»ºÎ °áÇÕ½ÃÅ°´Â ANSI Çü JOIN ÀÔ´Ï´Ù. |
static int |
LEFT_OUTER_JOIN
2°³ÀÇ °Ñ(Ç¥)¸¦ ¿ÞÂÊ ¹Ù±ùºÎ °áÇÕ½ÃÅ°´Â ANSI Çü JOIN ÀÔ´Ï´Ù. |
static int |
RIGHT_OUTER_JOIN
2°³ÀÇ °Ñ(Ç¥)¸¦ ¿À¸¥ÂÊ ¿ÜºÎ °áÇÕ½ÃÅ°´Â ANSI Çü JOIN ÀÔ´Ï´Ù. |
ÀÎÅÍÆäÀ̽º javax.sql.rowset. WebRowSet ·ÎºÎÅÍ »ó¼ÓµÈ Çʵå |
---|
PUBLIC_XML_SCHEMA,
SCHEMA_SYSTEM_ID |
ÀÎÅÍÆäÀ̽º javax.sql.rowset. CachedRowSet ·ÎºÎÅÍ »ó¼ÓµÈ Çʵå |
---|
COMMIT_ON_ACCEPT_CHANGES |
ÀÎÅÍÆäÀ̽º java.sql. ResultSet ·ÎºÎÅÍ »ó¼ÓµÈ Çʵå |
---|
CLOSE_CURSORS_AT_COMMIT,
CONCUR_READ_ONLY,
CONCUR_UPDATABLE,
FETCH_FORWARD,
FETCH_REVERSE,
FETCH_UNKNOWN,
HOLD_CURSORS_OVER_COMMIT,
TYPE_FORWARD_ONLY,
TYPE_SCROLL_INSENSITIVE,
TYPE_SCROLL_SENSITIVE |
¸Þ¼µå °³¿ä | |
---|---|
void |
addRowSet (Joinable rowset)
ÁöÁ¤µÈ RowSet °´Ã¼¸¦ ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡ÇÕ´Ï´Ù. |
void |
addRowSet (RowSet [] rowset,
int[] columnIdx)
ÁöÁ¤µÈ RowSet °´Ã¼ÀÇ ¹è¿¿¡ Æ÷ÇԵǴ 1°³
ÀÌ»óÀÇ RowSet °´Ã¼¸¦ ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡ÇØ, °¢ RowSet °´Ã¼ÀÇ ÀÏÄ¡¿ÀÌ ÁöÁ¤µÈ ¿À妽ºÀÇ ¹è¿³»ÀÇ ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. |
void |
addRowSet (RowSet [] rowset,
String [] columnName)
ÁöÁ¤µÈ RowSet °´Ã¼ÀÇ ¹è¿¿¡ Æ÷ÇԵǴ 1°³
ÀÌ»óÀÇ RowSet °´Ã¼¸¦ ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡ÇØ, °¢ RowSet °´Ã¼ÀÇ ÀÏÄ¡¿ÀÌ ÁöÁ¤µÈ ·Ä¸íÀÇ ¹è¿³»ÀÇ ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. |
void |
addRowSet (RowSet rowset,
int columnIdx)
ÁöÁ¤µÈ RowSet °´Ã¼¸¦ ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡ÇØ, ÁöÁ¤µÈ ¿À» RowSet °´Ã¼ÀÇ ÀÏÄ¡¿·Î¼ ¼³Á¤ÇÕ´Ï´Ù. |
void |
addRowSet (RowSet rowset,
String columnName)
rowset¸¦ ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡ÇØ, ÁöÁ¤µÈ ¿À» ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. |
int |
getJoinType ()
ÀÌ JoinRowSet ÀνºÅϽº¸¦ °ü¸®ÇÏ´Â SQL JOIN ÇüÀ» ±â¼úÇÏ´Â int ¸¦ ¸®ÅÏÇÕ´Ï´Ù. |
String [] |
getRowSetNames ()
ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡µÈ RowSet °´Ã¼ÀÇ À̸§À» Æ÷ÇÔÇÑ String ¹è¿À» ¸®ÅÏÇÕ´Ï´Ù. |
Collection <? > |
getRowSets ()
ÀÌ JoinRowSet °´Ã¼¿¡ Ãß°¡µÈ RowSet °´Ã¼¸¦ Æ÷ÇÔÇÑ Collection °´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù. |
String |
getWhereClause ()
JoinRowSet °´Ã¼·Î »ç¿ëµÇ´Â SQL¿¡ ÀÚÁÖ ´àÀº WHERE ÀýÀÇ ±â¼úÀ» ¸®ÅÏÇÕ´Ï´Ù. |
void |
setJoinType (int joinType)
¾îÇø®ÄÉÀ̼ǿ¡ JoinRowSet °´Ã¼ ÀνºÅϽº³»ÀÇ °Ñ(Ç¥)¿¡ Àû¿ëµÇ´Â JOIN
ÇüÅÂÀÇ Á¶Á¤À» Çã¿ëÇÕ´Ï´Ù. |
boolean |
supportsCrossJoin ()
JoinRowSet ±¸ÇöÀÌ CROSS_JOIN¸¦ Áö¿ø ÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³À´Ï´Ù. |
boolean |
supportsFullJoin ()
JoinRowSet ±¸ÇöÀÌ FULL_JOIN¸¦ Áö¿ø ÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³À´Ï´Ù. |
boolean |
supportsInnerJoin ()
JoinRowSet ±¸ÇöÀÌ INNER_JOIN¸¦ Áö¿ø ÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³À´Ï´Ù. |
boolean |
supportsLeftOuterJoin ()
JoinRowSet ±¸ÇöÀÌ LEFT_OUTER_JOIN¸¦ Áö¿ø ÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³À´Ï´Ù. |
boolean |
supportsRightOuterJoin ()
JoinRowSet ±¸ÇöÀÌ RIGHT_OUTER_JOIN¸¦ Áö¿ø ÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³À´Ï´Ù. |
CachedRowSet |
toCachedRowSet ()
ÀÌ JoinRowSet °´Ã¼³»ÀÇ µ¥ÀÌÅ͸¦ Æ÷ÇÔÇÑ »õ·Î¿î CachedRowSet °´Ã¼¸¦ ÀÛ¼ºÇÕ´Ï´Ù. |
ÀÎÅÍÆäÀ̽º javax.sql.rowset. WebRowSet ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼µå |
---|
readXml,
readXml,
writeXml,
writeXml,
writeXml,
writeXml |
ÀÎÅÍÆäÀ̽º javax.sql.rowset. CachedRowSet ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼µå |
---|
acceptChanges,
acceptChanges,
columnUpdated,
columnUpdated,
commit,
createCopy,
createCopyNoConstraints,
createCopySchema,
createShared,
execute,
getKeyColumns,
getOriginal,
getOriginalRow,
getPageSize,
getRowSetWarnings,
getShowDeleted,
getSyncProvider,
getTableName,
nextPage,
populate,
populate,
previousPage,
release,
restoreOriginal,
rollback,
rollback,
rowSetPopulated,
setKeyColumns,
setMetaData,
setOriginalRow,
setPageSize,
setShowDeleted,
setSyncProvider,
setTableName,
size,
toCollection,
toCollection,
toCollection,
undoDelete,
undoInsert,
undoUpdate |
ÀÎÅÍÆäÀ̽º javax.sql.rowset. Joinable ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼µå |
---|
getMatchColumnIndexes,
getMatchColumnNames,
setMatchColumn,
setMatchColumn,
setMatchColumn,
setMatchColumn,
unsetMatchColumn,
unsetMatchColumn,
unsetMatchColumn,
unsetMatchColumn |
ÇʵåÀÇ »ó¼¼ |
---|
static final int CROSS_JOIN
JOIN
ÀÔ´Ï´Ù.
static final int INNER_JOIN
JOIN
ÀÔ´Ï´Ù. °áÇÕÇÑ Ç¥ÀÇ ¾î´À ÂÊÀΰ¡¿¡ ÀÏÄ¡ÇÏÁö ¾Ê´Â ÇàÀÌ ÀÖ´Â °æ¿ì, ÀÌ ÇàÀº »èÁ¦µË´Ï´Ù.
static final int LEFT_OUTER_JOIN
JOIN
ÀÔ´Ï´Ù. SQL ¿¡¼´Â JOIN ¹®ÀÇ ÁÂÃøÀ¸·ÎºÎÅÍ ¸ðµç ·¹Äڵ尡 ¸®ÅϵÈ
À§°ªÀ¸·Î
±â¼úµË´Ï´Ù.
static final int RIGHT_OUTER_JOIN
JOIN
ÀÔ´Ï´Ù. SQL ¿¡¼´Â ÁÂÃøÀÇ °Ñ(Ç¥)¿¡ ÀÏÄ¡ÇÏ´Â ·¹Äڵ尡 ¾ø´Â °æ¿ì¿¡¼µµ, JOIN ¹®ÀÇ ¿ìÃøÀÇ °Ñ(Ç¥)·ÎºÎÅÍ ¸ðµç ·¹Äڵ尡 ¸®ÅϵÈ
À§°ªÀ¸·Î
±â¼úµË´Ï´Ù.
static final int FULL_JOIN
JOIN
ÀÔ´Ï´Ù. ÇÑÆíÀÇ °Ñ(Ç¥)·ÎºÎÅÍ, ÀÌÁ¦(À̹Ì
) ÇÑÆíÀÇ °Ñ(Ç¥)ÀÇ ÀÏÄ¡ ·¹ÄÚµå (¿Í)´Â °ü°è¾ø´Â °ÍÀ¸·Î ¸®ÅϵÈ
¸ðµç ÇàÀ» ÁöÁ¤ÇÕ´Ï´Ù.
¸Þ¼µåÀÇ »ó¼¼ |
---|
void addRowSet(Joinable rowset) throws SQLException
RowSet
°´Ã¼¸¦ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇÕ´Ï´Ù. RowSet
°´Ã¼°¡ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â ÃÖÃÊÀÇ °´Ã¼ÀÎ °æ¿ì, JOIN
°ü°è°¡ È®¸³µÇ´Â ±â¹ÝÀÌ µË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â ÁöÁ¤µÈ RowSet
°´Ã¼°¡ Joinable
setMatchColumn
¸Þ¼µå·Î ¼³Á¤µÈ ÀÏÄ¡¿À» À̹Ì
°¡Áö°í ÀÖ´Â °æ¿ì¿¡°Ô¸¸ »ç¿ëÇÒ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù.
ÁÖ : Joinable
°´Ã¼´Â
Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÏ°í ÀÖ´Â ÀÓÀÇÀÇ RowSet
°´Ã¼ÀÔ´Ï´Ù.
rowset
- ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â RowSet
°´Ã¼. Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇØ, ÀÏÄ¡¿¼¼Æ®¸¦ °¡Áö°í ÀÖÀ» ÇÊ¿ä°¡ ÀÖ´Ù
SQLException
- (1) ÀÌ JoinRowSet
°´Ã¼¿¡ ºñ¾îÀÖ´Â Çà ¼¼Æ®°¡ Ãß°¡µÇ¾úÀ» °æ¿ì, (2) rowset¿¡ ÀÏÄ¡¿ÀÌ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì, (3) rowset°¡ È°¼ºÈµÈ JOIN
¿¡ À§¹ÝÇÏ´Â °æ¿ìJoinable.setMatchColumn(int)
void addRowSet(RowSet rowset, int columnIdx) throws SQLException
RowSet
°´Ã¼¸¦ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇØ, ÁöÁ¤µÈ ¿À» RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿·Î¼ ¼³Á¤ÇÕ´Ï´Ù. RowSet
°´Ã¼°¡ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â ÃÖÃÊÀÇ °´Ã¼ÀÎ °æ¿ì, JOIN
°ü°è°¡ È®¸³µÇ´Â ±â¹ÝÀÌ µË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â RowSet°¡ ¾ÆÁ÷ ÀÏÄ¡¿¼¼Æ®¸¦ °¡ÁöÁö ¾Ê´Â °æ¿ì¿¡ »ç¿ëµË´Ï´Ù.
rowset
- ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â RowSet
°´Ã¼. Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÒ ¼ö ÀÖ´ÂcolumnIdx
- ÀÏÄ¡¿ÀÌ µÇ´Â ¿À» ³ªÅ¸³»´Â int
SQLException
- (1) rowset°¡ ºñ¾îÀÖ´Â Çà ¼¼Æ®ÀÇ °æ¿ì, (2) rowset°¡ È°¼ºÈµÈ JOIN
¿¡ À§¹ÝÇÏ´Â °æ¿ìJoinable.unsetMatchColumn(int)
void addRowSet(RowSet rowset, String columnName) throws SQLException
JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇØ, ÁöÁ¤µÈ ¿À» ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. rowset°¡ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â ÃÖÃÊÀÇ °´Ã¼ÀÎ °æ¿ì, JOIN
°ü°è°¡ È®¸³µÇ´Â ±â¹ÝÀÌ µË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â ÁöÁ¤µÈ RowSet
°´Ã¼°¡ ¾ÆÁ÷ ÀÏÄ¡¿À» °¡ÁöÁö ¾Ê´Â °æ¿ì¿¡ »ç¿ëµË´Ï´Ù.
rowset
- ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â RowSet
°´Ã¼. Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÒ ¼ö ÀÖ´ÂcolumnName
- ÀÏÄ¡¿·Î¼ ¼³Á¤µÇ´Â ¿ÀÇ À̸§À» ÁöÁ¤ÇÏ´Â String
°´Ã¼
SQLException
- (1) rowset°¡ ºñ¾îÀÖ´Â Çà ¼¼Æ®ÀÇ °æ¿ì, (2) rowset
ÀÏÄ¡¿ÀÌ JOIN
Á¶°ÇÀ» ä¿ìÁö ¾ÊÀº °æ¿ìvoid addRowSet(RowSet [] rowset, int[] columnIdx) throws SQLException
RowSet
°´Ã¼ÀÇ ¹è¿¿¡ Æ÷ÇԵǴ 1°³
ÀÌ»óÀÇ RowSet
°´Ã¼¸¦ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇØ, °¢ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿ÀÌ ÁöÁ¤µÈ ¿À妽ºÀÇ ¹è¿³»ÀÇ ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. columnIdx
ÃÖÃÊÀÇ ¿ä¼Ò´Â rowset ³»ÀÇ ÃÖÃÊÀÇ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿, columnIdx
2¹ø°ÀÇ ¿ä¼Ò´Â rowset ³»ÀÇ 2¹ø°ÀÇ ¿ä¼ÒÀÇ ÀÏÄ¡¿ (ÀÌÇÏ °°ÀÌ)·Î ¼³Á¤µË´Ï´Ù.
ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â ÃÖÃÊÀÇ RowSet
°´Ã¼°¡JOIN
°ü°èÀÇ ±â¹ÝÀ¸·Î µË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â ÁöÁ¤µÈ RowSet
°´Ã¼°¡ ¾ÆÁ÷ ÀÏÄ¡¿À» °¡ÁöÁö ¾Ê´Â °æ¿ì¿¡ »ç¿ëµË´Ï´Ù.
rowset
- JOIN
¿¡ Ãß°¡µÇ´Â 1°³
ÀÌ»óÀÇ RowSet
°´Ã¼ÀÇ ¹è¿. Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÒ ¼ö ÀÖ´ÂcolumnIdx
- ¿ÀÇ À妽º¸¦ rowset ³»ÀÇ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿·Î¼ ¼³Á¤Çϵµ·Ï ÁöÁ¤ÇÏ´Â int
°ªÀÇ ¹è¿
SQLException
- (1) ÀÌ JoinRowSet
°´Ã¼¿¡ ºñ¾îÀÖ´Â Çà ¼¼Æ®°¡ Ãß°¡µÇ¾úÀ» °æ¿ì, (2) rowset ³»ÀÇ RowSet
°´Ã¼¿¡ ÀÏÄ¡¿ÀÌ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì, (3) Ãß°¡µÇ´Â RowSet
°´Ã¼°¡ È°¼ºÈµÈ JOIN
¿¡ À§¹ÝÇÏ´Â °æ¿ìvoid addRowSet(RowSet [] rowset, String [] columnName) throws SQLException
RowSet
°´Ã¼ÀÇ ¹è¿¿¡ Æ÷ÇԵǴ 1°³
ÀÌ»óÀÇ RowSet
°´Ã¼¸¦ ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡ÇØ, °¢ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿ÀÌ ÁöÁ¤µÈ ·Ä¸íÀÇ ¹è¿³»ÀÇ ÀÏÄ¡¿·Î ¼³Á¤ÇÕ´Ï´Ù. columnName
ÃÖÃÊÀÇ ¿ä¼Ò´Â rowset ³»ÀÇ ÃÖÃÊÀÇ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿, columnName
2¹ø°ÀÇ ¿ä¼Ò´Â rowset ³»ÀÇ 2¹ø°ÀÇ ¿ä¼ÒÀÇ ÀÏÄ¡¿ (ÀÌÇÏ °°ÀÌ)·Î ¼³Á¤µË´Ï´Ù.
ÀÌ JoinRowSet
°´Ã¼¿¡ Ãß°¡µÇ´Â ÃÖÃÊÀÇ RowSet
°´Ã¼°¡JOIN
°ü°èÀÇ ±â¹ÝÀ¸·Î µË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â ÁöÁ¤µÈ RowSet
°´Ã¼ (º¹¼ö°¡´É)°¡ ¾ÆÁ÷ ÀÏÄ¡¿À» °¡ÁöÁö ¾Ê´Â °æ¿ì¿¡ »ç¿ëµË´Ï´Ù.
rowset
- JOIN
¿¡ Ãß°¡µÇ´Â 1°³
ÀÌ»óÀÇ RowSet
°´Ã¼ÀÇ ¹è¿. Joinable
ÀÎÅÍÆäÀ̽º¸¦ ±¸ÇöÇÒ ¼ö ÀÖ´ÂcolumnName
- ¿ÀÇ À̸§À» rowset ³»ÀÇ RowSet
°´Ã¼ÀÇ ÀÏÄ¡¿·Î¼ ¼³Á¤Çϵµ·Ï ÁöÁ¤ÇÏ´Â String
°ªÀÇ ¹è¿
SQLException
- (1) ÀÌ JoinRowSet
°´Ã¼¿¡ ºñ¾îÀÖ´Â Çà ¼¼Æ®°¡ Ãß°¡µÇ¾úÀ» °æ¿ì, (2) rowset ³»ÀÇ RowSet
°´Ã¼¿¡ ÀÏÄ¡¿ÀÌ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì, (3) Ãß°¡µÇ´Â RowSet
°´Ã¼°¡ È°¼ºÈµÈ JOIN
¿¡ À§¹ÝÇÏ´Â °æ¿ìCollection <? > getRowSets() throws SQLException
JoinRowSet
°´Ã¼¿¡ Ãß°¡µÈ RowSet
°´Ã¼¸¦ Æ÷ÇÔÇÑ Collection
°´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù. JOIN
³»ÀÇ RowSet ¼ö n¸¦ µ¹·ÁÁÖ°í, ÀÌ °ø¿ë ü³»¿¡¼ ¹ß»ýÇÑ ¸ðµç °»½ÅÀ» º¸°ü À¯ÁöÇÕ´Ï´Ù.
JoinRowSet
°´Ã¼¿¡ Ãß°¡µÈ RowSet
°´Ã¼·Î ±¸¼ºµÇ´Â Collection
°´Ã¼
SQLException
- ¸®ÅϵÈ
Collection
°´Ã¼ÀÇ »ý¼º½Ã¿¡ ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìString [] getRowSetNames() throws SQLException
JoinRowSet
°´Ã¼¿¡ Ãß°¡µÈ RowSet
°´Ã¼ÀÇ À̸§À» Æ÷ÇÔÇÑ String
¹è¿À» ¸®ÅÏÇÕ´Ï´Ù.
JoinRowSet
°´Ã¼³»ÀÇ RowSet
°´Ã¼ÀÇ À̸§À» Æ÷ÇÔÇÑ String
¹è¿
SQLException
- RowSet
°´Ã¼ÀÇ À̸§ÀÇ Ãëµæ½Ã¿¡ ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìCachedRowSet.setTableName(java.lang.String)
CachedRowSet toCachedRowSet() throws SQLException
JoinRowSet
°´Ã¼³»ÀÇ µ¥ÀÌÅ͸¦ Æ÷ÇÔÇÑ »õ·Î¿î CachedRowSet
°´Ã¼¸¦ ÀÛ¼ºÇÕ´Ï´Ù. ÀÌ°ÍÀº, CachedRowSet
°´Ã¼ÀÇ SyncProvider
°´Ã¼¸¦ »ç¿ëÇØ, µ¥ÀÌÅÍ ¼Ò½º¿¡ º¸Á¸ÇÒ ¼ö ÀÖ½À´Ï´Ù
.
JoinRowSet¿¡ °»½Å ¶Ç´Â º¯°æÀ» Àû¿ëÇßÀ» °æ¿ì, ¸Þ¼µå¿¡ ÀÇÇØ ¸®ÅϵÈ
CachedRowSet´Â
±× º¯°æÀ» µ¥ÀÌÅÍ ¼Ò½º³»ÀÇ ¿øÀÇ Çà°ú Ç¥³»¿¡ Áö¼Ó½Ãų ¼ö°¡ ¾ø½À´Ï´Ù. ¸®ÅϵÈ
CachedRowSet ÀνºÅϽº¿¡´Â º¯°æ µ¥ÀÌÅÍ´Â Æ÷ÇÔµÇÁö ¾Ê½À´Ï´Ù. ¶Ç, ¿øÀÇ SQL ¹®ÀÇ ¸ðµç ÇÁ·ÎÆÛƼ°¡ ¼Ò°ÅµË´Ï´Ù. ¾îÇø®ÄÉÀ̼ÇÀº, RowSet.setCommand
¸Þ¼µå¸¦ »ç¿ëÇØ, ÀÌ SQL ¹®À» ¸®¼Â ÇÒ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù.
º¯°æÀ» ¿øÀÇ °Ñ(Ç¥)ÀÇ µ¥ÀÌÅÍ ¼Ò½º¿¡ Áö¼Ó½ÃÅ°±â À§Çؼ´Â acceptChanges
¸Þ¼µå¸¦ JoinRowSet °´Ã¼ ÀνºÅϽº»ó¿¡ È£ÃâÇÕ´Ï´Ù. ±¸Çö¿¡¼´Â ±¸Çö³»ÀÇ ³»ºÎ µ¥ÀÌÅÍ¿Í °»½Å ÃßÀû ±â´ÉÀ» ÀÌ¿ëÇØ, SyncProvider ¶ó°í ´ëÈÇØ, º¯°æÀ» Áö¼Ó ´çÇÕ´Ï´Ù.
SQLException
- CachedRowSet °´Ã¼ÀÇ ¾î¼Àºí(assemble)½Ã¿¡ ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìRowSet
,
CachedRowSet
,
SyncProvider
boolean supportsCrossJoin()
boolean supportsInnerJoin()
boolean supportsLeftOuterJoin()
boolean supportsRightOuterJoin()
boolean supportsFullJoin()
void setJoinType(int joinType) throws SQLException
JOIN
ÇüÅÂÀÇ Á¶Á¤À» Çã¿ëÇÕ´Ï´Ù. ±¸ÇöÀº ÁöÁ¤µÈ JOIN
ÇüÀ» Áö¿ø
ÇÏÁö ¾Ê´Â °æ¿ì, SQLExceptionÀ»
Throw ÇÕ´Ï´Ù.
joinType
- JoinRowSet ÀνºÅϽº¸¦ Áï½Ã º¹±¸¼º ÇÏ´Â SQL JOIN
Ç¥ÁØ JoinRowSet.XXX static Çʵå Á¤ÀÇ SQLException
- Áö¿ø
µÇ¾î ÀÖÁö ¾ÊÀº JOIN
ÇüÀÌ ¼³Á¤µÇ¾úÀ» °æ¿ìgetJoinType()
String getWhereClause() throws SQLException
JOIN
SQL ij¸¯ÅÍ ¶óÀÎ ±â¼úÀ» Á¦°øÇÏ´Â °ÍÀ¸·Î½á, SQL JOIN
WHERE ÀýÀ» ±â¼úÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶Ç´Â JoinRowSet
¸¦ »ç¿ëÇØ, ¾îÇø®ÄÉÀ̼ÇÀ» º¸Á¶ÇÏ´Â ÅؽºÆ® ±â¼úÀ» Á¦°øÇÒ ¼ö ÀÖ½À´Ï´Ù.
SQLException
- WHERE ÀýÀÇ Ç¥ÇöÀÇ »ý¼º½Ã¿¡ ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìint getJoinType() throws SQLException
JOIN
ÇüÀ» ±â¼úÇÏ´Â int
¸¦ ¸®ÅÏÇÕ´Ï´Ù. ¸®ÅϵÈ
ÇüÅ´ ǥÁØ JoinRowSet Çü (CROSS_JOIN
, INNER_JOIN
, LEFT_OUTER_JOIN
, RIGHT_OUTER_JOIN
, ¶Ç´Â FULL_JOIN
)ÀÇ ¾î´À ÂÊÀΰ¡¿¡ µË´Ï´Ù.
JOIN
Ç¥ÁØ JoinRowSet static Çʵå Á¤ÀÇÀÇ ¸î°³ÀÇ joinType. ¸í½ÃÀûÀ¸·Î ÇüÅ°¡ ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì´Â µðÆúÆ®ÀÇ JOIN
ÇüÀ¸·Î¼ JoinRowSet.INNER_JOIN
°¡ ¸®ÅϵȴÙ
SQLException
- JoinRowSet ÀνºÅϽº¿¡ ÀÇÇØ Áö¿ø
µÇ´Â SQL JOIN
ÇüÀÇ ÆǴܽÿ¡ ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetJoinType(int)
|
JavaTM 2 Platform Standard Ed. 5.0 |
|||||||||
ÀÌÀü Ŭ·¡½º ´ÙÀ½ Ŭ·¡½º | ÇÁ·¹ÀÓÀ¸·Î ÇÁ·¹ÀÓ ¾øÀÌ | |||||||||
°³¿ä: NESTED | Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå | »ó¼¼: Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå |
Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms . Documentation Redistribution Policy µµ ÂüÁ¶ÇϽʽÿÀ.