JavaTM 2 Platform
Standard Ed. 5.0

javax.sql.rowset
ÀÎÅÍÆäÀ̽º JdbcRowSet

¸ðµç ½´ÆÛ ÀÎÅÍÆäÀ̽º:
Joinable, ResultSet, RowSet

public interface JdbcRowSet
extends RowSet, Joinable

JdbcRowSet ¸ðµç Ç¥ÁØ ±¸ÇöÀÌ ±¸ÇöÇØ¾ß Çϴ ǥÁØ ÀÎÅÍÆäÀ̽ºÀÔ´Ï´Ù.

1.0 °³¿ä

°á°ú ¼¼Æ®¸¦ JavaBeansTM ÄÄÆÛ³ÍÆ®·Î¼­ »ç¿ëÇÒ ¼ö ÀÖµµ·Ï ÇÏ´Â ResultSet ¿ÀºêÁ§Æ®ÀÇ ·¡ÆÛÀÔ´Ï´Ù. µû¶ó¼­,JdbcRowSet ¿ÀºêÁ§Æ®´Â ÅøÀÌ ¾îÇø®ÄÉÀ̼ÇÀÇ Á¶¸³¿¡ ÀÌ¿ëÇÒ ¼ö ÀÖ´Â Beans 1 °³°¡ µË´Ï´Ù. JdbcRowSet´Â Á¢¼ÓµÈ Çà ¼¼Æ®À̹ǷΠJDBC Å×Å©³î·¯Áö¸¦ »ç¿ë °¡´ÉÇÑ µå¶óÀ̹ö¸¦ »ç¿ëÇØ µ¥ÀÌŸº£À̽º Á¢¼ÓÀ» °è¼ÓÇØ º¸°ü À¯ÁöÇÕ´Ï´Ù. ¶Ç, µå¶óÀ̹ö¸¦ »ç½Ç»óÀÇ JavaBeans ÄÄÆÛ³ÍÆ®·Î ÇÕ´Ï´Ù.

Ç×»ó µ¥ÀÌŸº£À̽º¿¡ Á¢¼ÓµÇ°í ÀÖÀ¸¹Ç·ÎJdbcRowSet ÀνºÅϽº´Â ÀÌ Á¢¼Ó»ó¿¡¼­ È£ÃâÀ» ½Ç½ÃÇØ, °è¼ÓµÇ¾î À̰͵éÀ» ±× ResultSet ¿ÀºêÁ§Æ®»ó¿¡¼­ È£ÃâÇÕ´Ï´Ù. ±× °á°ú, ¿¹¸¦ µé¾î °á°ú ¼¼Æ®´Â Swing ¾îÇø®ÄÉÀ̼ÇÀÇ ÄÄÆÛ³ÍÆ®°¡ µË´Ï´Ù.

JdbcRowSet ¿ÀºêÁ§Æ®ÀÇ ÀÌÁ¦(¹ú½á) 1 °³ÀÇ ÀÌÁ¡Àº,ResultSet ¿ÀºêÁ§Æ®¿¡ ½ºÅ©·Ñ ±â´É°ú °»½Å ±â´ÉÀ» °®°ÔÇÒ ¼ö°¡ ÀÖ´Â Á¡¿¡ ÀÖ½À´Ï´Ù. ¸ðµç RowSet ¿ÀºêÁ§Æ®´Â µðÆúÆ®·Î ½ºÅ©·Ñ ±â´É°ú °»½Å ±â´ÉÀ» °®Ãß°í ÀÖ½À´Ï´Ù. »ç¿ëÇÏ´Â µå¶óÀ̹ö¿Í µ¥ÀÌŸº£À̽º°¡ °á°ú ¼¼Æ®ÀÇ ½ºÅ©·Ñ ±â´ÉÀ̳ª °»½Å ±â´ÉÀ» ¼­Æ÷Æ®ÇÏÁö ¾Ê´Â °æ¿ì, ¾îÇø®ÄÉÀ̼ÇÀº JdbcRowSet ¿ÀºêÁ§Æ®¿¡ ResultSet ¿ÀºêÁ§Æ®ÀÇ µ¥ÀÌÅ͸¦ À̽ÄÇØ, ¸¶Ä¡ ResultSet ¿ÀºêÁ§Æ®¿Í °°ÀÌ JdbcRowSet ¿ÀºêÁ§Æ®¸¦ Á¶ÀÛÇÒ ¼ö°¡ ÀÖ½À´Ï´Ù.

2.0 JdbcRowSet ¿ÀºêÁ§Æ®ÀÇ ÀÛ¼º

JdbcRowSet ÀÎÅÍÆäÀ̽ºÀÇ ·¹ÆÛ·±½º ±¸Çö,JdbcRowSetImpl´Â µðÆúÆ® »ý¼ºÀÚ ±¸ÇöÀ» Á¦°øÇÕ´Ï´Ù. »õ·Î¿î ÀνºÅϽº´Â µðÆúƮġ·Î ÃʱâÈ­µË´Ï´Ù. ±× ÈÄ, Çʿ信 µû¶ó¼­ »õ·Î¿î °ªÀ» ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. »õ·Î¿î ÀνºÅϽº´Â execute ¸Þ¼­µå°¡ ºÒ·Á °¥ ¶§±îÁö, ½ÇÁ¦·Î´Â ±â´ÉÇÏÁö ¾Ê½À´Ï´Ù. º¸Åë , ÀÌ ¸Þ¼­µå´Â ´ÙÀ½ÀÇ Ã³¸®¸¦ ½Ç½ÃÇÕ´Ï´Ù. execute ¸Þ¼­µå´Â ¼º°øÇßÀ» °æ¿ì, ÀûÀýÇÑ private JdbcRowSet Çʵ忡 ´ÙÀ½ÀÇ Ç׸ñÀ» ¼³Á¤ÇÕ´Ï´Ù. ÀÌ·¯ÇÑ Çʵ尡 ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì´Â execute ¸Þ¼­µå°¡ Á¤»óÀûÀ¸·Î ½ÇÇàµÇÁö ¾Ê¾Ò´ø °ÍÀÌ µË´Ï´Ù. Çà ¼¼Æ®»ó¿¡¼­´Â execute ¿Í close ÀÌ¿ÜÀÇ ¸Þ¼­µå´Â È£ÃâÇÒ ¼ö ¾ø½À´Ï´Ù. µû¶ó¼­, ±× ¿ÜÀÇ public ¸Þ¼­µå´Â ¸ðµÎ ¿¹¿Ü¸¦ Throw ÇÕ´Ï´Ù.

±×·¯³ª,execute ¸Þ¼­µåÀÇ È£ÃâÀü¿¡ Á¢¼ÓÀÇ È®¸³¿¡ ÇÊ¿äÇÑ Ä¿¸àµå¿Í ÇÁ·ÎÆÛƼ¸¦ ¼³Á¤ÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù. ´ÙÀ½ÀÇ Äڵ忡¼­´Â JdbcRowSetImpl ¿ÀºêÁ§Æ®¸¦ ÀÛ¼ºÇØ, Ä¿¸àµå ¹× Á¢¼ÓÀÇ ÇÁ·ÎÆÛƼ¸¦ ¼³Á¤ÇØ, Ç÷¹À̽ºÈ¦´õ ÆÄ¶ó¹ÌÅ͸¦ ¼³Á¤ÇØ, ÇÑÃþ ´õexecute ¸Þ¼­µå¸¦ È£ÃâÇÕ´Ï´Ù.

 JdbcRowSetImpl jrs = new JdbcRowSetImpl(); jrs.setCommand("SELECT * FROM TITLES WHERE TYPE = ? "); jrs.setURL("jdbc:myDriver:myAttribute"); jrs.setUsername("cervantes"); jrs.setPassword("sancho"); jrs.setString(1, "BIOGRAPHY"); jrs.execute();
º¯¼ö jrs´Â °Ñ(Ç¥) TITLES (¼­ÀûÀÇ Á¾·ù´Â Àü±â ¹®ÇÐ) ³»ÀÇ ¸ðµç ÇàÀ» Æ÷ÇÔÇÑ ResultSet ¿ÀºêÁ§Æ®ÀÇ thin ·¡ÆÛ,JdbcRowSetImpl ÀνºÅϽº¸¦ Ç¥ÇöÇÏ°Ô µË´Ï´Ù. ÀÌ ½ÃÁ¡¿¡¼­,jrs »ó¿¡¼­ ºÒ·Á °¡´Â Á¶ÀÛÀº, °á°ú ¼¼Æ®³»ÀÇ Çà (»ç½Ç»óÀÇ JavaBeans ÄÄÆÛ³ÍÆ®)¿¡ ¿µÇâÀ» ¹ÌĨ´Ï´Ù.

JdbcRowSet ·¹ÆÛ·±½º ±¸ÇöÀÇ RowSet ¸Þ¼­µå execute ±¸ÇöÀº,CachedRowSetTM ·¹ÆÛ·±½º ±¸Çö³»ÀÇ ±¸Çö°ú´Â ´Ù¸¨´Ï´Ù. À̰ÍÀº,RowSet ¿ÀºêÁ§Æ®°¡ Á¢¼ÓµÇ°í ÀÖ´ÂÁö ¾î¶²Áö¿¡ ÇØ ¿ä°ÇÀÌ ´Ù¸¥ °ÍÀ» °í·ÁÇÑ °á°úÀÔ´Ï´Ù.


ÇÊµå °³¿ä
 
ÀÎÅÍÆäÀ̽º 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 commit ()
          JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ.
 boolean getAutoCommit ()
          JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ.
 RowSetWarning getRowSetWarnings ()
          ÀÌ JdbcRowSet ¿ÀºêÁ§Æ®»óÀÇ È£Ãâ¿¡ ÇØ º¸°íµÈ ÃÖÃÊÀÇ °æ°í¸¦ ÃëµæÇÕ´Ï´Ù.
 boolean getShowDeleted ()
          ÇöÀçÀÇ Çà ¼¼Æ®³»ÀÇ »èÁ¦ÇàÀÇ ¸¶Å©¸¦ Ç¥½ÃÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³»´Â boolean¸¦ ÃëµæÇÕ´Ï´Ù.
 void rollback ()
          JdbcRowSet ¿¡´Â ¿øÀÇ ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, °Å±â¿¡ °Ç³×¹Þ´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ.
 void rollback (Savepoint  s)
          JdbcRowSet ¿¡´Â ¿øÀÇ ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, °Å±â¿¡ °Ç³×¹Þ´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ.
 void setAutoCommit (boolean autoCommit)
          JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ.
 void setShowDeleted (boolean b)
          showDeleted ÇÁ·ÎÆÛƼ¿¡ ÁöÁ¤µÈ boolean Ä¡¸¦ ¼³Á¤ÇÕ´Ï´Ù.
 
ÀÎÅÍÆäÀ̽º javax.sql. RowSet ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼­µå
addRowSetListener, clearParameters, execute, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setCommand, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername
 
ÀÎÅÍÆäÀ̽º java.sql. ResultSet ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼­µå
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getMetaData, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
 
ÀÎÅÍÆäÀ̽º javax.sql.rowset. Joinable ·ÎºÎÅÍ »ó¼ÓµÈ ¸Þ¼­µå
getMatchColumnIndexes, getMatchColumnNames, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn
 

¸Þ¼­µåÀÇ »ó¼¼

getShowDeleted

boolean getShowDeleted()
                       throws SQLException 
ÇöÀçÀÇ Çà ¼¼Æ®³»ÀÇ »èÁ¦ÇàÀÇ ¸¶Å©¸¦ Ç¥½ÃÇÒÁö ¾î¶³Áö¸¦ ³ªÅ¸³»´Â boolean¸¦ ÃëµæÇÕ´Ï´Ù. true °¡ µ¹·ÁÁÖ°íÁ³À» °æ¿ì, »èÁ¦ÇàÀº ÇöÀçÀÇ Çà°ú ÇÔ²² Ç¥½ÃµË´Ï´Ù. false °¡ µ¹·ÁÁÖ°íÁ³À» °æ¿ì, »èÁ¦ÇàÀº ÇöÀçÀÇ Ç༼Ʈ³»¿¡ Ç¥½ÃµÇÁö ¾Ê½À´Ï´Ù. µðÆúƮġ´Â false ÀÔ´Ï´Ù.

Ç¥ÁØÇà ¼¼Æ® ±¸ÇöÀº, º¸¾È»óÀÇ ¹è·Á ¶Ç´Â ƯÁ¤ÀÇ ¹èÄ¡ ½Ã³ª¸®¿À¿¡ ÀûÇÕ½Ã۱⠶§¹®¿¡ ÀÌ µ¿ÀÛÀ» Á¦ÇÑÇÒ ¼ö°¡ ÀÖ½À´Ï´Ù. »èÁ¦µÈ ÇàÀÇ °¡½Ã¼ºÀº ±¸Çö¿¡ ÇØ Á¤ÀǵǾî Ç¥ÁØÀÇ µ¿ÀÛÀ» ³ªÅ¸³»Áö ¾Ê½À´Ï´Ù.

ÁÖ: »èÁ¦µÈ ÇàÀ» Ç¥½ÃÇϸé, ÀϺÎÀÇ Ç¥ÁØ JDBC RowSet ±¸Çö ¸Þ¼­µåÀÇ µ¿ÀÛÀÌ º¹ÀâÇÏ°Ô µË´Ï´Ù. ±×·¯³ª, »èÁ¦µÈ ÇàÀ» Ç¥½ÃÇÏ´Â ±â´ÉÀº, ¸Å¿ì Àü¹®ÀûÀÎ ¾îÇø®ÄÉÀ̼ÇÀ¸·Î ¹Û¿¡ »ç¿ëµÇÁö ¾Ê½À´Ï´Ù. µû¶ó¼­, ´ëºÎºÐÀÇ Çà ¼¼Æ® À¯Àú´Â ÀÌ ¼³Á¤À» ¹«½ÃÇØ ±¦Âú½À´Ï´Ù.

¹Ýȯ°ª:
»èÁ¦µÈ ÇàÀ» Ç¥½ÃÇÏ´Â °æ¿ì´Â true, ±×·¸Áö ¾ÊÀº °æ¿ì´Â false
¿¹¿Ü:
SQLException - Çà ¼¼Æ® ±¸ÇöÀÌ, »èÁ¦ÇàÀÌ Ç¥½ÃµÈ ä·Î ÀÖÀ»Áö ¾î¶³Áö¸¦ ÆÇ´ÜÇÒ ¼ö ¾ø´Â °æ¿ì
°ü·Ã Ç׸ñ:
setShowDeleted(boolean)

setShowDeleted

void setShowDeleted(boolean b)
                    throws SQLException 
showDeleted ÇÁ·ÎÆÛƼ¿¡ ÁöÁ¤µÈ boolean Ä¡¸¦ ¼³Á¤ÇÕ´Ï´Ù. ÀÌ ÇÁ·ÎÆÛƼ¿¡ ÇØ, »èÁ¦ÇàÀ» ÇöÀçÀÇ Çà ¼¼Æ®³»¿¡ °è¼ÓÇØ Ç¥½ÃÇÒÁö ¾î¶³Áö°¡ °áÁ¤µË´Ï´Ù. °ªÀÌ true °æ¿ì, »èÁ¦µÈ ÇàÀÌ ÇöÀçÀÇ Çà ¼¼Æ®¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù. °ªÀÌ false °æ¿ì, »èÁ¦µÈ ÇàÀº ÇöÀçÀÇ Çà ¼¼Æ®³»¿¡ Ç¥½ÃµÇÁö ¾Ê½À´Ï´Ù.

Ç¥ÁØÇà ¼¼Æ® ±¸ÇöÀº, º¸¾È»óÀÇ ¹è·Á ¶Ç´Â ƯÁ¤ÀÇ ¹èÄ¡ ½Ã³ª¸®¿À¿¡ ÀûÇÕ½Ã۱⠶§¹®¿¡ ÀÌ µ¿ÀÛÀ» Á¦ÇÑÇÒ ¼ö°¡ ÀÖ½À´Ï´Ù. À̰ÍÀº Á¤ÀÇ ³¡³­ ±¸ÇöÀ¸·Î¼­ ³²°ÜÁ® Ç¥ÁØÀÇ µ¿ÀÛÀ» ³ªÅ¸³»Áö ¾Ê½À´Ï´Ù.

ÆÄ¶ó¹ÌÅÍ:
b - »èÁ¦µÈ ÇàÀ» Ç¥½ÃÇÏ´Â °æ¿ì´Â true, ±×·¸Áö ¾ÊÀº °æ¿ì´Â false
¿¹¿Ü:
SQLException - Çà ¼¼Æ® ±¸ÇöÀÌ, »èÁ¦ÇàÀÇ Ç¥½Ã ¶Ç´Â ºñÇ¥½ÃÀÇ ¼³Á¤À» ¸®¼ÂÆ® ÇÒ ¼ö ¾ø´Â °æ¿ì
°ü·Ã Ç׸ñ:
getShowDeleted()

getRowSetWarnings

RowSetWarning  getRowSetWarnings()
                                throws SQLException 
ÀÌ JdbcRowSet ¿ÀºêÁ§Æ®»óÀÇ È£Ãâ¿¡ ÇØ º¸°íµÈ ÃÖÃÊÀÇ °æ°í¸¦ ÃëµæÇÕ´Ï´Ù. JdbcRowSet ¿ÀºêÁ§Æ®»ó¿¡ 2 ¹øÂ°ÀÇ °æ°í°¡ º¸°íµÇ¾úÀ» °æ¿ì, ÀÌ °æ°í´Â ÃÖÃÊÀÇ °æ°í¿¡ üÀÎ µË´Ï´Ù. µû¶ó¼­, 2 ¹øÂ°ÀÇ °æ°í´Â ÃÖÃÊÀÇ °æ°í¿¡ ´ëÇØ¼­ RowSetWarning.getNextWarning ¸Þ¼­µå¸¦ È£ÃâÇÏ´Â °ÍÀ¸·Î ÃëµæÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ JdbcRowSet ¿ÀºêÁ§Æ®»óÀÇ ÈļÓÀÇ °æ°í´Â RowSetWarning.getNextWarning ¸Þ¼­µå¿¡ ÇØ µ¹·ÁÁÖ°íÁö´Â RowSetWarning ¿ÀºêÁ§Æ®¿¡ üÀÎ µË´Ï´Ù. °æ°í üÀÎÀº, »õ·Î¿î ÇàÀÌ ÀÐÈú ¶§¸¶´Ù ÀÚµ¿ÀûÀ¸·Î Ŭ¸®¾î µË´Ï´Ù. ÀÌ ¸Þ¼­µå´Â Ŭ·Î¿ìÁî µÈ RowSet ¿ÀºêÁ§Æ®ÀÇ È£Ãâ¿¡´Â »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù. »ç¿ëÇϸé SQLException °¡ Throw µË´Ï´Ù.

JdbcRowSet ¿ÀºêÁ§Æ®´Â Ç×»ó µ¥ÀÌÅÍ ¼Ò½º¿¡ Á¢¼ÓµÇ°í ÀÖÀ¸¹Ç·Î ¾×ƼºêÇÑ Statement,Connection ¹× ResultSet ÀνºÅϽºÀÇ Á¸Àç¿¡ Á¸ÇÒ ¼ö°¡ ÀÖ½À´Ï´Ù. Áï, ¾îÇø®ÄÉÀ̼ÇÀº, À̰͵éÀÌ Á¦°øÇÏ´Â getNextWarning ¸Þ¼­µå¸¦ ºÒ·¯³»´Â °ÍÀ¸·Î Ãß°¡ÀÇ SQLWarning ÅëÁö¸¦ ÃëµæÇÒ ¼ö ÀÖ°Ô µË´Ï´Ù. CachedRowSet ¿ÀºêÁ§Æ® µî, ¹ÌÁ¢¼ÓÀÇ Rowset ¿ÀºêÁ§Æ®´Â ÀÌ·¯ÇÑ getNextWarning ¸Þ¼­µå¿¡ ¾×¼¼½º ÇÒ ¼ö ¾ø½À´Ï´Ù.

¹Ýȯ°ª:
ÀÌ JdbcRowSet ¿ÀºêÁ§Æ®»ó¿¡¼­ º¸°íµÈ ÃÖÃÊÀÇ RowSetWarning ¿ÀºêÁ§Æ®. ¾ø´Â °æ¿ì´Â null
¿¹¿Ü:
SQLException - ÀÌ ¸Þ¼­µå°¡, ´ÝÇôÁø JdbcRowSet ¿ÀºêÁ§Æ®»ó¿¡¼­ ºÒ·Á °¬À» °æ¿ì
°ü·Ã Ç׸ñ:
RowSetWarning

commit

void commit()
            throws SQLException 
JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ ¸Þ¼­µå´Â Connection À§Å¹ ¸Þ¼­µå¸¦ ·¦ ÇØ, À¯¿¬ÇÑ ÀÚµ¿ À§Å¹ ¶Ç´Â ºñÀÚµ¿ À§Å¹ÀÇ Æ®·£Àè¼Ç(transaction) Á¦¾î ¼­Æ÷Æ®¸¦ Á¦°øÇÕ´Ï´Ù.

Á÷ÀüÀÇ À§Å¹/·Ñ¹é(rollback) ÀÌÈÄ¿¡ ÇàÇØÁø º¯°æÀ» ¸ðµÎ À¯È¿·Î ÇØ, ÀÌ Connection ¿ÀºêÁ§Æ®°¡ ÇöÀç º¸°ü À¯ÁöÇÏ´Â µ¥ÀÌŸº£À̽º ¶ôÀ» ¸ðµÎ ÇØÁ¦ÇÕ´Ï´Ù. ÀÌ ¸Þ¼­µå´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿·Î µÇ°í ÀÖÀ» ¶§ ¸¶¼Å »ç¿ëÇÕ´Ï´Ù.

¿¹¿Ü:
SQLException - µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ JdbcRowSet ³»ÀÇ Connection ¿ÀºêÁ§Æ®°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ì
°ü·Ã Ç׸ñ:
Connection.setAutoCommit(boolean)

getAutoCommit

boolean getAutoCommit()
                      throws SQLException 
JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ ¸Þ¼­µå´Â Connection getAutoCommit ¸Þ¼­µå¸¦ ·¦ ÇØ, ¾îÇø®ÄÉÀ̼ÇÀÌ JdbcRowSet Æ®·£Àè¼Ç(transaction)ÀÇ µ¿ÀÛÀ» È®ÀÎÇÒ ¼ö ÀÖµµ·Ï ÇÕ´Ï´Ù.

ÀÌ Á¢¼ÓÀÇ ÀÚµ¿ À§Å¹ ¸ðµå°¡ ÁöÁ¤µÈ »óÅ·Π¼³Á¤ÇÕ´Ï´Ù. Á¢¼ÓÀÌ ÀÚµ¿ À§Å¹ ¸ðµåÀÇ °æ¿ì, ±× ¸ðµç SQL ¹®Àº ½ÇÇàµÇ¾î °³º°ÀÇ Æ®·£Àè¼Ç(transaction)·Î¼­ À§Å¹µË´Ï´Ù. ±×·¸Áö ¾ÊÀº °æ¿ì, ±× SQL ¹®Àº, commit ¸Þ¼­µå ¶Ç´Â rollback ¸Þ¼­µå¿¡ÀÇ È£Ãâ¿¡ ÇØ Á¾·áµÇ´Â Æ®·£Àè¼Ç(transaction)¿¡ ±×·ìÈ­ µË´Ï´Ù. µðÆúÆ®¿¡¼­´Â »õ·Î¿î Á¢¼ÓÀº ÀÚµ¿ À§Å¹ ¸ðµåÀÔ´Ï´Ù.

¿¹¿Ü:
SQLException - µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì
°ü·Ã Ç׸ñ:
Connection.getAutoCommit()

setAutoCommit

void setAutoCommit(boolean autoCommit)
                   throws SQLException 
JdbcRowSet ¿¡´Â ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, »ý¼ºÀÚ¿¡°Ô °Ç³×Áö´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ. ÀÌ ¸Þ¼­µå´Â Connection getAutoCommit ¸Þ¼­µå¸¦ ·¦ ÇØ, ¾îÇø®ÄÉÀ̼ÇÀÌ JdbcRowSet Æ®·£Àè¼Ç(transaction)ÀÇ µ¿ÀÛÀ» ¼³Á¤ÇÒ ¼ö ÀÖµµ·Ï ÇÕ´Ï´Ù.

ÀÌ Connection ¿ÀºêÁ§Æ®ÀÇ ÇöÀçÀÇ ÀÚµ¿ À§Å¹ ¸ðµå¸¦ ¼³Á¤ÇÕ´Ï´Ù.

¿¹¿Ü:
SQLException - µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì
°ü·Ã Ç׸ñ:
Connection.setAutoCommit(boolean)

rollback

void rollback()
              throws SQLException 
JdbcRowSet ¿¡´Â ¿øÀÇ ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, °Å±â¿¡ °Ç³×¹Þ´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ. ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)¿¡ À־ÀÇ ¸ðµç º¯°æÀ» Ãë¼ÒÇØ, ÇöÀç ÀÌ Connection ¿ÀºêÁ§Æ®°¡ º¸°ü À¯ÁöÇϰí ÀÖ´Â ¸ðµç µ¥ÀÌŸº£À̽º ¶ôÀ» ÇØÁ¦ÇÕ´Ï´Ù. ÀÌ ¸Þ¼­µå´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿°¡ µÇ¾î ÀÖÀ» ¶§ ¹Û¿¡ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.

¿¹¿Ü:
SQLException - µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ JdbcRowSet ³»ÀÇ Connection ¿ÀºêÁ§Æ®°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ì
°ü·Ã Ç׸ñ:
rollback(Savepoint)

rollback

void rollback(Savepoint  s)
              throws SQLException 
JdbcRowSet ¿¡´Â ¿øÀÇ ResultSet Connection ¿ÀºêÁ§Æ®Àΰ¡, °Å±â¿¡ °Ç³×¹Þ´Â JDBC ÇÁ·ÎÆÛƼ°¡ Æ÷ÇԵ˴ϴÙ. ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·ÎºÎÅÍ ¸¶Áö¸· setSavepoint ±îÁöÀÇ ¸ðµç º¯°æÀ» Ãë¼ÒÇØ, ÇöÀç ÀÌ Connection ¿ÀºêÁ§Æ®°¡ º¸°ü À¯ÁöÇϰí ÀÖ´Â ¸ðµç µ¥ÀÌŸº£À̽º ¶ôÀ» ÇØÁ¦ÇÕ´Ï´Ù. ÀÌ ¸Þ¼­µå´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿°¡ µÇ¾î ÀÖÀ» ¶§ ¹Û¿¡ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.

¿¹¿Ü:
SQLException - µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ JdbcRowSet ³»ÀÇ Connection ¿ÀºêÁ§Æ®°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ì
°ü·Ã Ç׸ñ:
rollback()

JavaTM 2 Platform
Standard Ed. 5.0

Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms . Documentation Redistribution Policy µµ ÂüÁ¶ÇϽʽÿÀ.