|
JavaTM 2 Platform Standard Ed. 5.0 |
|||||||||
ÀÌÀü Ŭ·¡½º ´ÙÀ½ Ŭ·¡½º | ÇÁ·¹ÀÓÀ¸·Î ÇÁ·¹ÀÓ ¾øÀÌ | |||||||||
°³¿ä: NESTED | Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå | »ó¼¼: Çʵå | constructor¡¡ ¡¡ | ¸Þ¼µå |
public interface Connection
ƯÁ¤ÀÇ µ¥ÀÌŸº£À̽º¿ÍÀÇ Á¢¼Ó (¼¼¼Ç)À» Ç¥ÇöÇÕ´Ï´Ù. Á¢¼ÓÀÇ ÄÁÅؽºÆ® ³»¿¡¼ SQL ¹®ÀÌ ½ÇÇàµÇ°í °á°ú°¡ ¸®Åϵ˴ϴ٠.
Connection
°´Ã¼ÁßÀÇ µ¥ÀÌŸº£À̽º´Â Å×À̺í, Áö¿ø
ÇÏ°í ÀÖ´Â SQL ¹®¹ý, ½ºÅä¾îµå ÇÁ·Î½ÃÀú
¹× ÀÌ Á¢¼ÓÀÇ ´É·Â µî¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù. ÀÌ Á¤º¸´Â getMetaData
¸Þ¼µå·Î ÃëµæÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÁÖ: °¢ ¹®À» ½ÇÇà ÈÄ, µðÆúÆ®¿¡¼´Â Connection
°´Ã¼´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ µÇ¾î, ÀÚµ¿ÀûÀ¸·Î º¯°æÀ» À§Å¹ÇÕ´Ï´Ù. ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿·Î µÇ°í ÀÖ´Â °æ¿ì, º¯°æÀ» À§Å¹ÇÏ·Á¸é ¸Þ¼µå commit
¸¦ ¸í½ÃÀûÀ¸·Î È£ÃâÇÒ ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. ±×·¸°Ô ÇÏÁö ¾ÊÀ¸¸é µ¥ÀÌŸº£À̽ºÀÇ º¯°æÀº º¸Á¸µÇÁö ¾Ê½À´Ï´Ù.
JDBC 2.1 ÄÚ¾î API¸¦ »ç¿ëÇØ »ý¼ºµÈ »õ·Î¿î Connection
°´Ã¼¿¡´Â ÀÌ °´Ã¼¿¡ °ü·ÃÇÏ´Â Ãʱ⠻óÅ°¡ ºñ¾îÀÖ´Â ÇüÅ ¸ÊÀÌ ÀÖ½À´Ï´Ù. »ç¿ëÀÚ´Â ÀÌ ÇüÅ ¸ÊÀÇ UDT¿¡ Ä¿½ºÅÒ ¸ÅÇÎÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸Þ¼µå ResultSet.getObject
¿¡ ÀÇÇØ µ¥ÀÌÅÍ ¼Ò½º·ÎºÎÅÍ UDT°¡ ÃëµæµÇ¸é, getObject
¸Þ¼µå´Â Á¢¼ÓÀÇ ÇüÅ ¸ÊÀ» üũÇØ, ±× UDT¿¡ ¿£Æ®¸®°¡ ÀÖÀ»Áö ¾î¶³Áö¸¦ Á¶»çÇÕ´Ï´Ù. ¿£Æ®¸®°¡ ÀÖ´Â °æ¿ì, getObject
¸Þ¼µå´Â Áö½Ã¹ÞÀº Ŭ·¡½º¿¡ UDT¸¦ ¸ÅÇÎ ÇÕ´Ï´Ù. ¿£Æ®¸®°¡ ¾ø´Â °æ¿ì, UDT´Â Ç¥ÁØ ¸ÅÇÎÀ» »ç¿ëÇØ ¸ÅÇÎ µË´Ï´Ù.
»ç¿ëÀÚ´Â java.util.Map
°´Ã¼°¡ µÇ´Â »õ·Î¿î ÇüÅ ¸ÊÀ» ÀÛ¼ºÇØ, °Å±â¿¡ ¿£Æ®¸®¸¦ ÀÛ¼ºÇØ, Ä¿½ºÅÒ ¸ÅÇÎÀ» ½ÇÇàÇÒ ¼ö ÀÖ´Â java.sql
¸Þ¼µå¿¡ ±× ¿£Æ®¸®¸¦ °Ç³×ÁÙ ¼ö°¡ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì
¸Þ¼µå´Â Á¢¼Ó¿¡ °ü·ÃÇÑ ÇüÅ ¸ÊÀº ¾Æ´Ï°í ÁöÁ¤µÈ ÇüÅ ¸ÊÀ» »ç¿ëÇÕ´Ï´Ù.
¿¹¸¦ µé¾î
´ÙÀ½ÀÇ ÄÚµå fragment´Â SQL Çü ATHLETES
°¡ Java ÇÁ·Î±×·¥ ¾ð¾îÀÇ Å¬·¡½º Athletes
¿¡ ¸ÅÇÎ µÇ´Â °ÍÀ» ÁöÁ¤ÇÕ´Ï´Ù. ÄÚµå fragment´Â Connection
°´Ã¼ con
ÇüÅ ¸ÊÀ» ÃëµæÇØ, °Å±â¿¡ ¿£Æ®¸®¸¦ »ðÀÔÇØ, ±× »õ·Î¿î ¿£Æ®¸®·Î ±× ÇüÅ ¸ÊÀ» Á¢¼ÓÀÇ ÇüÅ ¸ÊÀ¸·Î¼ ¼³Á¤ÇÕ´Ï´Ù.
java.util.Map map = con.getTypeMap(); map.put("mySchemaName.ATHLETES", Class.forName("Athletes")); con.setTypeMap(map);
DriverManager.getConnection(java.lang.String, java.util.Properties)
,
Statement
,
ResultSet
,
DatabaseMetaData
ÇÊµå °³¿ä | |
---|---|
static int |
TRANSACTION_NONE
Æ®·£Àè¼Ç(transaction)°¡ Áö¿ø µÇ¾î ÀÖÁö ¾ÊÀº °ÍÀ» ³ªÅ¸³»´Â Á¤¼öÀÔ´Ï´Ù. |
static int |
TRANSACTION_READ_COMMITTED
´õƼ read´Â ¾ïÁ¦µÇ¾î ¹Ýº¹ ºÒ°¡ÀÇ read ¹× ÆÒÅÒ read°¡ ÀϾ´Â °ÍÀ» ³ªÅ¸³»´Â Á¤¼öÀÔ´Ï´Ù. |
static int |
TRANSACTION_READ_UNCOMMITTED
´õƼ Àбâ, ¹Ýº¹ ºÒ°¡ÀÇ ÀÐ±â ¹× ÆÒÅÒ read°¡ ÀϾ´Â °ÍÀ» ³ªÅ¸³»´Â Á¤¼öÀÔ´Ï´Ù. |
static int |
TRANSACTION_REPEATABLE_READ
´õƼ read ¹× ¹Ýº¹ÇØ ºÒ°¡ÀÇ read´Â ¾ïÁ¦µÇ¾î ÆÒÅÒ read°¡ ÀϾ´Â °ÍÀ» ³ªÅ¸³»´Â Á¤¼öÀÔ´Ï´Ù. |
static int |
TRANSACTION_SERIALIZABLE
´õƼ Àбâ, ¹Ýº¹ ºÒ°¡ÀÇ ÀÐ±â ¹× ÆÒÅÒ read°¡ ¾ïÁ¦µÇ´Â °ÍÀ» ³ªÅ¸³»´Â Á¤¼öÀÔ´Ï´Ù. |
¸Þ¼µå °³¿ä | |
---|---|
void |
clearWarnings ()
ÀÌ Connection °´Ã¼¿¡ °üÇؼ ÅëÁöµÈ ¸ðµç °æ°í¸¦ Ŭ¸®¾î ÇÕ´Ï´Ù. |
void |
close ()
ÀÚµ¿ÀûÀÎ ÇØÁ¦¸¦ ±â´Ù¸®Áö ¾Ê°í, Áï½Ã ÀÌ Connection °´Ã¼ÀÇ µ¥ÀÌŸº£À̽º¿Í JDBC ÀÚ¿øÀ» ÇØÁ¦ÇÕ´Ï´Ù. |
void |
commit ()
Á÷ÀüÀÇ À§Å¹/·Ñ¹é(rollback) ÀÌÈÄ¿¡ ÇàÇØÁø º¯°æÀ» ¸ðµÎ À¯È¿·Î ÇØ, ÀÌ Connection °´Ã¼°¡ ÇöÀç º¸°ü À¯ÁöÇÏ´Â µ¥ÀÌŸº£À̽º ¶ôÀ» ¸ðµÎ ÇØÁ¦ÇÕ´Ï´Ù. |
Statement |
createStatement ()
SQL ¹®À» µ¥ÀÌŸº£À̽º¿¡ º¸³»±â À§ÇÑ Statement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
Statement |
createStatement (int resultSetType,
int resultSetConcurrency)
ÁöÁ¤µÈ ÇüÅÂ¿Í concurrent processing·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â Statement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
Statement |
createStatement (int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
ÁöÁ¤µÈ ÇüÅÂ, concurrent processing ¹× holdability ·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â Statement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
boolean |
getAutoCommit ()
ÀÌ Connection °´Ã¼ÀÇ ÇöÀçÀÇ ÀÚµ¿ À§Å¹ ¸ðµå¸¦ ÃëµæÇÕ´Ï´Ù. |
String |
getCatalog ()
ÀÌ Connection °´Ã¼ÀÇ ÇöÀçÀÇ Ä«Å»·Î±×¸íÀ» ÃëµæÇÕ´Ï´Ù. |
int |
getHoldability ()
ÀÌ Connection °´Ã¼¸¦ »ç¿ëÇØ »ý¼ºµÈ ResultSet °´Ã¼ÀÇ ÇöÀçÀÇ º¸°ü À¯Áö ±â´ÉÀ» ÃëµæÇÕ´Ï´Ù. |
DatabaseMetaData |
getMetaData ()
ÀÌ Connection °´Ã¼°¡ Á¢¼ÓÀ» ³ªÅ¸³»´Â µ¥ÀÌŸº£À̽º¿¡ °üÇÑ ¸ÞŸµ¥ÀÌŸ¸¦ Æ÷ÇÔÇÏ´Â DatabaseMetaData °´Ã¼¸¦ ÃëµæÇÕ´Ï´Ù. |
int |
getTransactionIsolation ()
ÀÌ Connection °´Ã¼ÀÇ ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction) Â÷´Ü ·¹º§À» ÃëµæÇÕ´Ï´Ù. |
Map <String,
Class <? >> |
getTypeMap ()
ÀÌ Connection ¿¡ °ü·ÃÇÑ Map °´Ã¼¸¦ ÃëµæÇÕ´Ï´Ù. |
SQLWarning |
getWarnings ()
ÀÌ Connection °´Ã¼¿¡ °üÇÑ È£Ãâ¿¡ ÀÇÇØ º¸°íµÇ´Â ÃÖÃÊÀÇ °æ°í¸¦ ÃëµæÇÕ´Ï´Ù. |
boolean |
isClosed ()
ÀÌ Connection °´Ã¼°¡ Ŭ·Î¿ìÁî µÇ°í ÀÖ´ÂÁö¸¦ ÃëµæÇÕ´Ï´Ù. |
boolean |
isReadOnly ()
ÀÌ Connection °´Ã¼°¡ Àбâ Àü¿ë
¸ðµåÀΰ¡ ¾î¶²°¡¸¦ ÃëµæÇÕ´Ï´Ù. |
String |
nativeSQL (String sql)
ÁöÁ¤µÈ SQL ¹®À» ½Ã½ºÅÛÀÇ º»·¡ÀÇ SQL ¹®¹ýÀ¸·Î º¯È¯ÇÕ´Ï´Ù. |
CallableStatement |
prepareCall (String sql)
µ¥ÀÌŸº£À̽ºÀÇ ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ È£ÃâÇϱâ À§ÇÑ CallableStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
CallableStatement |
prepareCall (String sql,
int resultSetType,
int resultSetConcurrency)
ÁöÁ¤µÈ ÇüÅÂ¿Í concurrent processing·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â CallableStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
CallableStatement |
prepareCall (String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
ÁöÁ¤µÈ ÇüÅÂ¿Í concurrent processing·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â CallableStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql)
ÆĶó¹ÌÅÍ Ã·ºÎ SQL ¹®À» µ¥ÀÌŸº£À̽º¿¡ º¸³»±â À§ÇÑ PreparedStatement °´Ã¼¸¦ ÀÛ¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql,
int autoGeneratedKeys)
ÀÚµ¿ »ý¼º Å°¸¦ ¾ò´Â ±â´ÉÀ» °¡Áö´Â µðÆúÆ®ÀÇ PreparedStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql,
int[] columnIndexes)
ÁöÁ¤µÈ ¹è¿¿¡ ÀÇÇØ ÁöÁ¤µÈ ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÖ´Â ±â´ÉÀ» °¡Áö´Â µðÆúÆ®ÀÇ PreparedStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql,
int resultSetType,
int resultSetConcurrency)
ÁöÁ¤µÈ ÇüÅÂ¿Í concurrent processing·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â PreparedStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
ÁöÁ¤µÈ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ¸·Î ResultSet °´Ã¼¸¦ »ý¼ºÇÏ´Â PreparedStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
PreparedStatement |
prepareStatement (String sql,
String [] columnNames)
ÁöÁ¤µÈ ¹è¿¿¡ ÀÇÇØ ÁöÁ¤µÈ ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÖ´Â ±â´ÉÀ» °¡Áö´Â µðÆúÆ®ÀÇ PreparedStatement °´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. |
void |
releaseSavepoint (Savepoint savepoint)
ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·ÎºÎÅÍ ÁöÁ¤µÈ Savepoint °´Ã¼¸¦ »èÁ¦ÇÕ´Ï´Ù. |
void |
rollback ()
ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·Î ÇàÇØÁø º¯°æÀ» ¸ðµÎ ¹ÙÅÁÀ¸·Î µÇµ¹·Á, ÀÌ Connection °´Ã¼°¡ ÇöÀç º¸°ü À¯ÁöÇÏ´Â µ¥ÀÌŸº£À̽º ¶ôÀ» ¸ðµÎ ÇØÁ¦ÇÕ´Ï´Ù. |
void |
rollback (Savepoint savepoint)
ÁöÁ¤µÈ Savepoint °´Ã¼°¡ ¼³Á¤µÈ µÚ¿¡ ÇàÇØÁø ¸ðµç º¯°æÀ» ¹ÙÅÁÀ¸·Î µÇµ¹¸³´Ï´Ù. |
void |
setAutoCommit (boolean autoCommit)
ÀÌ Á¢¼ÓÀÇ ÀÚµ¿ À§Å¹ ¸ðµå°¡ ÁöÁ¤µÈ »óÅ·Π¼³Á¤ÇÕ´Ï´Ù. |
void |
setCatalog (String catalog)
ÀÌ Connection °´Ã¼ÀÇ µ¥ÀÌŸº£À̽º¿¡ ÀÛ¾÷À» À§ÇÑ ¼ºê ½ºÆäÀ̽º¸¦ ¼±ÅÃÇϱâ À§Çؼ
Ä«Å»·Î±×¸íÀ» ¼³Á¤ÇÕ´Ï´Ù. |
void |
setHoldability (int holdability)
ÀÌ Connection °´Ã¼¸¦ »ç¿ëÇØ »ý¼ºµÈ ResultSet °´Ã¼ÀÇ º¸°ü À¯Áö ±â´ÉÀÌ ÁöÁ¤µÈ º¸°ü À¯Áö ±â´É¿¡ º¯°æÇÕ´Ï´Ù. |
void |
setReadOnly (boolean readOnly)
ÀÌ Connection¸¦ Àбâ Àü¿ë ¸ðµå·Î ¼³Á¤ÇØ, µ¥ÀÌŸº£À̽º ÃÖÀûȸ¦ ½ÇÇàÇÏ´Â µå¶óÀ̹öÀÇ ÈùÆ®·Î ÇÕ´Ï´Ù. |
Savepoint |
setSavepoint ()
ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·Î À̸§ÀÌ ¾ø´Â ¼¼À̺ê Æ÷ÀÎÆ®¸¦ ÀÛ¼ºÇØ, ±×°ÍÀ» ³ªÅ¸³»´Â »õ·Î¿î Savepoint °´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù. |
Savepoint |
setSavepoint (String name)
ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·Î ÁöÁ¤µÈ À̸§ÀÇ ¼¼À̺ê Æ÷ÀÎÆ®¸¦ ÀÛ¼ºÇØ, ±×°ÍÀ» ³ªÅ¸³»´Â »õ·Î¿î Savepoint °´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù. |
void |
setTransactionIsolation (int level)
ÀÌ Connection
Æ®·£Àè¼Ç(transaction) Â÷´Ü ·¹º§ÀÌ ÁöÁ¤µÈ °ÍÀ¸·Î º¯°æÇÏ´Â °ÍÀ» ½ÃµµÇÕ´Ï´Ù. |
void |
setTypeMap (Map <String,
Class <? >> map)
ÀÌ Connection °´Ã¼ÀÇ ÇüÅ ¸ÊÀ¸·Î¼ ÁöÁ¤µÈ TypeMap °´Ã¼¸¦ ÀνºÅç ÇÕ´Ï´Ù. |
ÇʵåÀÇ »ó¼¼ |
---|
static final int TRANSACTION_NONE
static final int TRANSACTION_READ_UNCOMMITTED
static final int TRANSACTION_READ_COMMITTED
static final int TRANSACTION_REPEATABLE_READ
static final int TRANSACTION_SERIALIZABLE
TRANSACTION_REPEATABLE_READ
¿¡
¼ÀÇ ±ÝÁö¿¡ ´õÇØ1°³ÀÇ Æ®·£Àè¼Ç(transaction)°¡ WHERE
Á¶°ÇÀ» ä¿ì´Â ¸ðµç ÇàÀ» Àо, 2¹ø°ÀÇ Æ®·£Àè¼Ç(transaction)°¡ WHERE
Á¶°ÇÀ» ä¿ì´Â ÇàÀ» »ðÀÔÇÑ µÚ¿¡
ÃÖÃÊÀÇ Æ®·£Àè¼Ç(transaction)°¡ µ¿ÀÏÇÑ Á¶°ÇÀ¸·Î Àбâ
´Ù½Ã ÇßÀ» °æ¿ì¿¡
2¹ø°ÀÇ read¿¡¼´Â Ãß°¡µÈ ¡¸ÆÒÅÒ¡¹ÇàÀ» ²¨³½´Ù°í ÇÏ´Â »óȲÀÌ ±ÝÁöµË´Ï´Ù.
¸Þ¼µåÀÇ »ó¼¼ |
---|
Statement createStatement() throws SQLException
Statement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÆĶó¹ÌÅÍ ¾øÀ½ÀÇ SQL ¹®Àº º¸Åë, Statement
°´Ã¼¸¦ »ç¿ëÇØ ½ÇÇàµË´Ï´Ù. °°Àº SQL ¹®ÀÌ ¿©·¯¹ø ½ÇÇàµÇ´Â °æ¿ì´Â PreparedStatement
°´Ã¼¸¦ »ç¿ëÇÏ´Â (ºÐ)ÆíÀÌ È¿À²ÀûÀÔ´Ï´Ù.
¸®ÅϵÈ
Statement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
Statement
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìPreparedStatement prepareStatement(String sql) throws SQLException
PreparedStatement
°´Ã¼¸¦ ÀÛ¼ºÇÕ´Ï´Ù.
IN ÆĶó¹ÌÅÍ ºÙ¾î ¶Ç´Â IN ÆĶó¹ÌÅÍ ¾øÀ½ÀÇ SQL ¹®Àº ÇÁ¸®ÄÄÆÄÀÏ ÇØ, PreparedStatement
°´Ã¼¿¡ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼, ÀÌ °´Ã¼´Â ÀÌ ¹®ÀåÀ» ¿©·¯ Â÷·Ê, È¿À²ÀûÀ¸·Î ½ÇÇàÇϴµ¥ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÁÖ: ÀÌ ¸Þ¼µå´Â ÇÁ¸®ÄÄÆÄÀÏÀÌ È¿°ú°¡ ÀÖ´Â ÆĶó¹ÌÅÍ Ã·ºÎ SQL ¹®À» ó¸®Çϱâ À§Çؼ ÃÖÀûȵǰí ÀÖ½À´Ï´Ù. µå¶óÀ̹ö°¡ ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖ´Â °æ¿ì, prepareStatement
¸Þ¼µå´Â ±× ¹®ÀåÀ» ÇÁ¸®ÄÄÆÄÀÏ¿ëÀ¸·Î¼ µ¥ÀÌŸº£À̽º¿¡ º¸³À´Ï´Ù. µå¶óÀ̹ö¿¡ µû¶ó¼´Â ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖÁö ¾Ê´Â °ÍÀÌ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì
PreparedStatement
ÀÌ ½ÇÇàµÉ ¶§±îÁö, ¹®ÀåÀº µ¥ÀÌŸº£À̽º¿¡ º¸³»ÁöÁö ¾Ê½À´Ï´Ù. ÀÌ°ÍÀº »ç¿ëÀÚ¿¡ °Ô Á÷Á¢ÀûÀÎ ¿µÇâÀº ¾ø½À´Ï´Ù¸¸, ¾î´À ¸Þ¼µå°¡ ¾î´À SQLException
°´Ã¼¸¦ Throw Çß´ÂÁö¸¦ °ü°èÇØ ¿µÇâÀÌ ÀÖ½À´Ï´Ù.
¸®ÅϵÈ
PreparedStatement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
sql
- 1°³
ÀÌ»óÀÇ '? ' IN ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®
PreparedStatement
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìCallableStatement prepareCall(String sql) throws SQLException
CallableStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. CallableStatement
°´Ã¼´Â
±× IN¿Í
OUT ÆĶó¹ÌÅ͸¦ ¼³Á¤ÇÏ´Â ¸Þ¼µå¿Í ½ºÅä¾îµå ÇÁ·Î½ÃÀú
ÀÇ È£ÃâÀ» ½ÇÇàÇÏ´Â ¸Þ¼µå¸¦ Á¦°øÇÕ´Ï´Ù.
ÁÖ: ÀÌ ¸Þ¼µå´Â ½ºÅä¾îµå ÇÁ·Î½ÃÀú
È£Ãâ¹®À» ó¸®Çϱâ À§Çؼ ÃÖÀûȵǰí ÀÖ½À´Ï´Ù. µå¶óÀ̹ö¿¡ µû¶ó¼´Â prepareCall
¸Þ¼µå°¡ ½ÇÇàµÉ ¶§ µ¥ÀÌŸº£À̽º¿¡ È£ÃâÇØ ¹®ÀåÀ» º¸³»´Â °ÍÀÌ ÀÖ½À´Ï´Ù. ±× ¿ÜÀÇ µå¶óÀ̹ö´Â CallableStatement
°´Ã¼°¡ ½ÇÇàµÉ ¶§±îÁö ±â´Ù¸³´Ï´Ù. ÀÌ°ÍÀº »ç¿ëÀÚ¿¡ °Ô Á÷Á¢ÀûÀÎ ¿µÇâÀº ¾ø½À´Ï´Ù¸¸, ¾î´À ¸Þ¼µå°¡ ¾î´À SQLExceptionÀ»
Throw Çß´ÂÁö¸¦ °ü°èÇØ ¿µÇâÀÌ ÀÖ½À´Ï´Ù.
¸®ÅϵÈ
CallableStatement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
sql
- 1°³
ÀÌ»óÀÇ '? 'ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®. º¸Åë
ÀÌ ¹®ÀåÀº JBDC ÇÔ¼ö È£ÃâÀÇ À̽ºÄÉÀÌÇÁ ij¸¯ÅÍ ¶óÀÎÀÌ´Ù
CallableStatement
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìString nativeSQL(String sql) throws SQLException
sql
- 1°³
ÀÌ»óÀÇ '? 'ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìvoid setAutoCommit(boolean autoCommit) throws SQLException
commit
¸Þ¼µå ¶Ç´Â rollback
¸Þ¼µå¿¡ÀÇ È£Ãâ¿¡ ÀÇÇØ Á¾·áµÇ´Â Æ®·£Àè¼Ç(transaction)¿¡ ±×·ìÈ µË´Ï´Ù. µðÆúÆ®¿¡¼´Â »õ·Î¿î Á¢¼ÓÀº ÀÚµ¿ À§Å¹ ¸ðµåÀÔ´Ï´Ù.
À§Å¹Àº ¹®ÀåÀÇ ¿Ï·á ¶Ç´Â ´ÙÀ½ÀÇ ½ÇÇàÀÇ ¹ß¿ø½Ã¾î´À ÂÊÀÌ ¸ÕÀú ÀϾµµ ¹ß»ýÇÕ´Ï´Ù. ¹®ÀåÀÌ, ResultSet
°´Ã¼¸¦ µ¹·ÁÁÖ´Â °æ¿ì¿¡´Â ResultSet
°´Ã¼ÀÇ ¸¶Áö¸· ÇàÀÌ ²¨³»Áú±î Ŭ·Î¿ìÁî µÇ¾úÀ» ¶§¿¡ ¹®ÀåÀº ¿Ï·áÇÕ´Ï´Ù. ÁøÇàµÈ ¿ë¹ý¿¡¼´Â ´ÜÀÏÀÇ ¹®ÀåÀÌ Ãâ·Â ÆĶó¹ÌÅÍ¿Í °°°Ô, º¹¼öÀÇ °á°ú¸¦ µ¹·ÁÁÖ´Â Àϵµ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì´Â ¸ðµç °á°ú¿Í Ãâ·Â ÆĶó¹ÌÅÍ°ªÀÌ ²¨³»Á³À» ¶§¿¡ À§Å¹ÀÌ ¹ß»ýÇÕ´Ï´Ù.
ÁÖ: Æ®·£Àè¼Ç(transaction)ÀÇ µµÁß¿¡ ÀÌ ¸Þ¼µå°¡ ºÒ·Á°¡ ¸é, ±× Æ®·£Àè¼Ç(transaction)´Â À§Å¹µË´Ï´Ù.
autoCommit
- ÀÚµ¿ À§Å¹ ¸ðµå¸¦ À¯È¿ÇÏ°Ô ÇÏ´Â °æ¿ì´Â true
, ¹«È¿·Î ÇÏ´Â °æ¿ì´Â false
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìgetAutoCommit()
boolean getAutoCommit() throws SQLException
Connection
°´Ã¼ÀÇ ÇöÀçÀÇ ÀÚµ¿ À§Å¹ ¸ðµå¸¦ ÃëµæÇÕ´Ï´Ù.
Connection
°´Ã¼ÀÇ ÇöÀçÀÇ ÀÚµ¿ À§Å¹ ¸ðµå »óÅÂ
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetAutoCommit(boolean)
void commit() throws SQLException
Connection
°´Ã¼°¡ ÇöÀç º¸°ü À¯ÁöÇÏ´Â µ¥ÀÌŸº£À̽º ¶ôÀ» ¸ðµÎ ÇØÁ¦ÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿·Î µÇ°í ÀÖÀ» ¶§ ¸¶¼Å »ç¿ëÇÕ´Ï´Ù.
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ Connection
°´Ã¼°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ìsetAutoCommit(boolean)
void rollback() throws SQLException
Connection
°´Ã¼°¡ ÇöÀç º¸°ü À¯ÁöÇÏ´Â µ¥ÀÌŸº£À̽º ¶ôÀ» ¸ðµÎ ÇØÁ¦ÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â ÀÚµ¿ À§Å¹ ¸ðµå°¡ ¹«È¿·Î µÇ°í ÀÖÀ» ¶§ ¸¶¼Å »ç¿ëÇÕ´Ï´Ù.
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ Connection
°´Ã¼°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ìsetAutoCommit(boolean)
void close() throws SQLException
Connection
°´Ã¼ÀÇ µ¥ÀÌŸº£À̽º¿Í JDBC ÀÚ¿øÀ» ÇØÁ¦ÇÕ´Ï´Ù.
À̹Ì
Ŭ·Î¿ìÁî µÈ Connection
°´Ã¼·Î close
¸Þ¼µå¸¦ È£ÃâÇϸé, Á¶ÀÛÀº ÇàÇØÁöÁö ¾Ê½À´Ï´Ù.
ÁÖ: Connection
°´Ã¼´Â
°¡ºñÁö Ä÷ºÆ®µÉ ¶§ ÀÚµ¿ÀûÀ¸·Î Ŭ·Î¿ìÁî µË´Ï´Ù. ƯÁ¤ÀÇ Ä¡¸íÀû ¿¡·¯ÀÇ °æ¿ìµµ, Connection
°´Ã¼´Â Ŭ·Î¿ìÁî µË´Ï´Ù.
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìboolean isClosed() throws SQLException
Connection
°´Ã¼°¡ Ŭ·Î¿ìÁî µÇ°í ÀÖ´ÂÁö¸¦ ÃëµæÇÕ´Ï´Ù. Á¢¼ÓÀº, close
¸Þ¼µå°¡ È£ÃâµÇ´ÂÁö, ƯÁ¤ÀÇ Ä¡¸íÀû ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì¿¡ Ŭ·Î¿ìÁî µË´Ï´Ù. ÀÌ ¸Þ¼µå´Â Connection.close
¸Þ¼µå°¡ ºÒ·Á °£ µÚ¿¡ ºÒ·Á °¬À» °æ¿ì¿¡¸¸ true
¸¦ µ¹·ÁÁÖ´Â °ÍÀÌ º¸ÁõµÇ°í ÀÖ½À´Ï´Ù.
ÀÌ ¸Þ¼µå´Â º¸Åë, µ¥ÀÌŸº£À̽º¿¡ÀÇ Á¢¼ÓÀÌ À¯È¿ÇÑ°¡ ¹«È¿ÀÎÁö¸¦ ÆÇÁ¤Çϱâ À§Çؼ È£ÃâÇÒ ¼ö ¾ø½À´Ï´Ù. ÀϹÝÀÇ Å¬¶óÀ̾ðÆ®¿¡¼´Â Á¶ÀÛÀ» ½ÇÇàÇßÀ» ¶§¿¡ ¹ß»ýµÇ´Â ¿¹¿Ü¸¦ ijġ ÇÏ´Â °ÍÀ¸·Î½á, Á¢¼ÓÀÌ ¹«È¿À̶ó°í ÆÇÁ¤ÇÕ´Ï´Ù.
Connection
°´Ã¼°¡ Ŭ·Î¿ìÁî µÇ°í ÀÖ´Â °æ¿ì´Â true
, ¾ÆÁ÷ ¿ÀÇ »óÅÂÀÇ °æ¿ì´Â false
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìDatabaseMetaData getMetaData() throws SQLException
Connection
°´Ã¼°¡ Á¢¼ÓÀ» ³ªÅ¸³»´Â µ¥ÀÌŸº£À̽º¿¡ °üÇÑ ¸ÞŸµ¥ÀÌŸ¸¦ Æ÷ÇÔÇÏ´Â DatabaseMetaData
°´Ã¼¸¦ ÃëµæÇÕ´Ï´Ù. ¸ÞŸµ¥ÀÌŸ´Â µ¥ÀÌŸº£À̽ºÀÇ Å×À̺í, Áö¿ø
ÇÏ°í ÀÖ´Â SQL ¹®¹ý, ½ºÅä¾îµå ÇÁ·Î½ÃÀú
¹× ÀÌ Á¢¼ÓÀÇ ´É·Â µî¿¡ ´ëÇÑ Á¤º¸¸¦ Æ÷ÇÔÇÏ°í ÀÖ½À´Ï´Ù.
Connection
°´Ã¼¿¡ ´ëÇÑ DatabaseMetaData
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìvoid setReadOnly(boolean readOnly) throws SQLException
ÁÖ: Æ®·£Àè¼Ç(transaction)ÀÇ µµÁß¿¡´Â ÀÌ ¸Þ¼µå¸¦ È£ÃâÇÒ ¼ö ¾ø½À´Ï´Ù.
readOnly
- true
ÀÎ °æ¿ì´Â Àбâ Àü¿ë
¸ðµå¸¦ »ç¿ë °¡´ÉÇÏ°Ô ÇØ, false
ÀÎ °æ¿ì´Â »ç¿ë ºÒ°¡·Î ÇÑ´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ ¸Þ¼µå°¡ Æ®·£Àè¼Ç(transaction)ÀÇ µµÁß¿¡ ºÒ·Á °¬À» °æ¿ìboolean isReadOnly() throws SQLException
Connection
°´Ã¼°¡ Àбâ Àü¿ë
¸ðµåÀΰ¡ ¾î¶²°¡¸¦ ÃëµæÇÕ´Ï´Ù.
Connection
°´Ã¼°¡ Àбâ Àü¿ë
¸ðµåÀÇ °æ¿ì´Â true
, ±×·¸Áö ¾ÊÀº °æ¿ì´Â false
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìvoid setCatalog(String catalog) throws SQLException
Connection
°´Ã¼ÀÇ µ¥ÀÌŸº£À̽º¿¡ ÀÛ¾÷À» À§ÇÑ ¼ºê ½ºÆäÀ̽º¸¦ ¼±ÅÃÇϱâ À§Çؼ
Ä«Å»·Î±×¸íÀ» ¼³Á¤ÇÕ´Ï´Ù.
µå¶óÀ̹ö°¡ Ä«Å»·Î±×¸¦ Áö¿ø ÇÏ°í ÀÖÁö ¾Ê´Â °æ¿ì´Â ÀÌ ¿ä±¸¸¦ ¹«½ÃÇÕ´Ï´Ù.
catalog
- ÀÛ¾÷À» À§ÇÑ Ä«Å»·Î±×¸í. Ä«Å»·Î±×´Â ÀÌ Connection
°´Ã¼ÀÇ µ¥ÀÌŸº£À̽ºÀÇ ¼ºê ½ºÆäÀ̽º
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìgetCatalog()
String getCatalog() throws SQLException
Connection
°´Ã¼ÀÇ ÇöÀçÀÇ Ä«Å»·Î±×¸íÀ» ÃëµæÇÕ´Ï´Ù.
null
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetCatalog(java.lang.String)
void setTransactionIsolation(int level) throws SQLException
Connection
Æ®·£Àè¼Ç(transaction) Â÷´Ü ·¹º§ÀÌ ÁöÁ¤µÈ °ÍÀ¸·Î º¯°æÇÏ´Â °ÍÀ» ½ÃµµÇÕ´Ï´Ù. ÁöÁ¤ÇÒ ¼ö ÀÖ´Â Æ®·£Àè¼Ç(transaction) Â÷´Ü ·¹º§ÀÇ Á¤¼ö´Â Connection
ÀÎÅÍÆäÀ̽º·Î Á¤Àǵǰí ÀÖ½À´Ï´Ù.
ÁÖ: Æ®·£Àè¼Ç(transaction)ÀÇ µµÁß¿¡ ÀÌ ¸Þ¼µå°¡ ºÒ·Á°¡ ¸é, ±× °á°ú´Â ±¸ÇöÀ¸·Î Á¤ÀÇµÈ °ÍÀÌ µË´Ï´Ù.
level
- ´ÙÀ½ÀÇ Connection
Á¤¼öÁß 1°³. Connection.TRANSACTION_READ_UNCOMMITTED
, Connection.TRANSACTION_READ_COMMITTED
, Connection.TRANSACTION_REPEATABLE_READ
, ¶Ç´Â Connection.TRANSACTION_SERIALIZABLE
. (Connection.TRANSACTION_NONE
´Â Æ®·£Àè¼Ç(transaction)°¡ Áö¿ø
µÇ¾î ÀÖÁö ¾ÊÀº °ÍÀ» ÁöÁ¤ÇϹǷΠ»ç¿ëÇÒ ¼ö ¾ø´Ù)
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ Connection
Á¤¼öÀÇ ¾î¶² °Íµµ ¾Æ´Ñ °æ¿ìDatabaseMetaData.supportsTransactionIsolationLevel(int)
,
getTransactionIsolation()
int getTransactionIsolation() throws SQLException
Connection
°´Ã¼ÀÇ ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction) Â÷´Ü ·¹º§À» ÃëµæÇÕ´Ï´Ù.
Connection.TRANSACTION_READ_UNCOMMITTED
, Connection.TRANSACTION_READ_COMMITTED
, Connection.TRANSACTION_REPEATABLE_READ
, Connection.TRANSACTION_SERIALIZABLE
, ¶Ç´Â Connection.TRANSACTION_NONE
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetTransactionIsolation(int)
SQLWarning getWarnings() throws SQLException
Connection
°´Ã¼¿¡ °üÇÑ È£Ãâ¿¡ ÀÇÇØ º¸°íµÇ´Â ÃÖÃÊÀÇ °æ°í¸¦ ÃëµæÇÕ´Ï´Ù. 2°³
ÀÌ»óÀÇ °æ°í°¡ ÀÖ´Â °æ¿ì, ÈļÓÀÇ °æ°í´Â ÃÖÃÊÀÇ °æ°í¿¡ üÀÎ µÇ¾î Á÷Àü¿¡ ÃëµæµÈ °æ°íÀÇ SQLWarning.getNextWarning
¸Þ¼µå¸¦ È£ÃâÇÏ´Â °Í¿¡ ÀÇÇØ ÃëµæµË´Ï´Ù.
ÀÌ ¸Þ¼µå´Â Ŭ·Î¿ìÁî µÈ Á¢¼ÓÀÇ È£Ãâ¿¡´Â »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù. »ç¿ëÇϸéSQLException
°¡ ¹ß»ý µË´Ï´Ù.
ÁÖ: °è¼ÓÇÏ´Â °æ°í´Â ÀÌ SQLWarning¿¡ üÀÎ µË´Ï´Ù.
SQLWarning
°´Ã¼. ¾ø´Â °æ¿ì´Â null
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÀÌ ¸Þ¼µå°¡ Ŭ·Î¿ìÁî µÈ Á¢¼Ó¿¡ ´ëÇØ ºÒ·Á °¬À» °æ¿ìSQLWarning
void clearWarnings() throws SQLException
Connection
°´Ã¼¿¡ °üÇؼ ÅëÁöµÈ ¸ðµç °æ°í¸¦ Ŭ¸®¾î ÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå¸¦ È£ÃâÇÑµÚ ÀÌ Connection
°´Ã¼¿¡ ´ëÇÑ »õ·Î¿î °æ°í°¡ ÅëÁöµÉ ¶§±îÁö, getWarnings
´Â null
À»
¸®ÅÏÇÕ´Ï´Ù.
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìStatement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â Statement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â »ó±âÀÇ createStatement
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅ ¹× concurrent processing¸¦ ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
resultSetType
- °á°ú ¼¼Æ®ÀÇ ÇüÅÂ. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- concurrent processingÀÇ Á¾·ù. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â »õ·Î¿î Statement
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅ ¹× concurrent processing¸¦ ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìPreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â PreparedStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â »ó±âÀÇ prepareStatement
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅ ¹× concurrent processing¸¦ ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
sql
- SQL ¹®ÀÌ µ¥ÀÌŸº£À̽º¿¡ º¸³»Áö´Â String
°´Ã¼. 1°³
ÀÌ»óÀÇ ? IN ÆĶó¹ÌÅ͸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â resultSetType
- °á°ú ¼¼Æ®ÀÇ ÇüÅÂ. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- concurrent processingÀÇ Á¾·ù. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
PreparedStatement
°´Ã¼. ÁöÁ¤µÈ ÇüÅ ¹× concurrent processing·Î ResultSet
°´Ã¼¸¦ »ý¼ºÇÑ´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅ ¹× concurrent processing¸¦ ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìCallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â CallableStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â »ó±âÀÇ prepareCall
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅ ¹× concurrent processing¸¦ ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
sql
- SQL ¹®ÀÌ µ¥ÀÌŸº£À̽º¿¡ º¸³»Áö´Â String
°´Ã¼. 1°³
ÀÌ»óÀÇ ? ÆĶó¹ÌÅ͸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â resultSetType
- °á°ú ¼¼Æ®ÀÇ ÇüÅÂ. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- concurrent processingÀÇ Á¾·ù. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
CallableStatement
°´Ã¼. ÁöÁ¤µÈ ÇüÅ ¹× concurrent processing·Î ResultSet
°´Ã¼¸¦ »ý¼ºÇÑ´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅ ¹× concurrent processing¸¦ ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìMap <String, Class <? >> getTypeMap() throws SQLException
Connection
¿¡ °ü·ÃÇÑ Map
°´Ã¼¸¦ ÃëµæÇÕ´Ï´Ù. ¾îÇø®ÄÉÀ̼ÇÀÌ ¿£Æ®¸®¸¦ Ãß°¡ÇÏ°í ÀÖÁö ¾Ê´Â ÇÑ, ºñ¾îÀÖ´Â ¸ÊÀÌ ¸®Åϵ˴ϴÙ
.
Connection
°´Ã¼¿¡ °ü·ÃÇÑ java.util.Map
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetTypeMap(java.util.Map>)
void setTypeMap(Map <String, Class <? >> map) throws SQLException
Connection
°´Ã¼ÀÇ ÇüÅ ¸ÊÀ¸·Î¼ ÁöÁ¤µÈ TypeMap
°´Ã¼¸¦ ÀνºÅç ÇÕ´Ï´Ù. ÇüÅ ¸ÊÀº SQL ±¸Á¶ÈÇü ¹× °³º°ÀÇ ÇüÅÂÀÇ Ä¿½ºÅÒ ¸ÅÇο¡ »ç¿ëµË´Ï´Ù.
map
- ÀÌ Connection
°´Ã¼ÀÇ µðÆúÆ®ÀÇ ÇüÅ ¸ÊÀÇ ´ë½ÅÀ¸·Î¼ ÀνºÅç ÇÏ´Â java.util.Map
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ java.util.Map
°¡ ¾Æ´Ñ °æ¿ìgetTypeMap()
void setHoldability(int holdability) throws SQLException
Connection
°´Ã¼¸¦ »ç¿ëÇØ »ý¼ºµÈ ResultSet
°´Ã¼ÀÇ º¸°ü À¯Áö ±â´ÉÀÌ ÁöÁ¤µÈ º¸°ü À¯Áö ±â´É¿¡ º¯°æÇÕ´Ï´Ù.
holdability
- ResultSet
º¸°ü À¯Áö ±â´É Á¤¼ö. ResultSet.HOLD_CURSORS_OVER_COMMIT
¶Ç´Â ResultSet.CLOSE_CURSORS_AT_COMMIT
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ º¸°ü À¯Áö ±â´ÉÀ» ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ º¸°ü À¯Áö ±â´ÉÀÌ Áö¿ø
µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ìgetHoldability()
,
ResultSet
int getHoldability() throws SQLException
Connection
°´Ã¼¸¦ »ç¿ëÇØ »ý¼ºµÈ ResultSet
°´Ã¼ÀÇ ÇöÀçÀÇ º¸°ü À¯Áö ±â´ÉÀ» ÃëµæÇÕ´Ï´Ù.
ResultSet.HOLD_CURSORS_OVER_COMMIT
¶Ç´Â ResultSet.CLOSE_CURSORS_AT_COMMIT
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìsetHoldability(int)
,
ResultSet
Savepoint setSavepoint() throws SQLException
Savepoint
°´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Savepoint
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÇöÀç ÀÌ Connection
°´Ã¼°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ìSavepoint
Savepoint setSavepoint(String name) throws SQLException
Savepoint
°´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù.
name
- ¼¼À̺ê Æ÷ÀÎÆ®ÀÇ À̸§À» Æ÷ÇÔÇÏ´Â String
Savepoint
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÇöÀç ÀÌ Connection
°´Ã¼°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ìSavepoint
void rollback(Savepoint savepoint) throws SQLException
Savepoint
°´Ã¼°¡ ¼³Á¤µÈ µÚ¿¡ ÇàÇØÁø ¸ðµç º¯°æÀ» ¹ÙÅÁÀ¸·Î µÇµ¹¸³´Ï´Ù.
ÀÌ ¸Þ¼µå´Â ÀÚµ¿ À§Å¹ÀÌ ¹«È¿ ¶§¿¡¸¸ »ç¿ëÇÕ´Ï´Ù.
savepoint
- ·Ñ¹é(rollback) ÇÏ´Â Savepoint
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, Savepoint
°´Ã¼°¡ À¯È¿ÇÏÁö ¾Ê°Ô µÇ¾úÀ» °æ¿ì, ¶Ç´Â ÇöÀç ÀÌ Connection
°´Ã¼°¡ ÀÚµ¿ À§Å¹ ¸ðµåÀÎ °æ¿ìSavepoint
,
rollback()
void releaseSavepoint(Savepoint savepoint) throws SQLException
Savepoint
°´Ã¼¸¦ »èÁ¦ÇÕ´Ï´Ù. »èÁ¦µÈ ÈÄ¿¡ ¼¼À̺ê Æ÷ÀÎÆ®¸¦ ÂüÁ¶Çϸé SQLException
°¡ ¹ß»ý µË´Ï´Ù.
savepoint
- »èÁ¦µÇ´Â Savepoint
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ Savepoint
°´Ã¼°¡ ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)·Î À¯È¿ÇÑ ¼¼À̺ê Æ÷ÀÎÆ®°¡ ¾Æ´Ñ °æ¿ìStatement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â Statement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â »ó±âÀÇ createStatement
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ» ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
resultSetType
- ResultSet
Á¤¼ö. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- ResultSet
Á¤¼ö. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
resultSetHoldability
- ResultSet
Á¤¼ö. ResultSet.HOLD_CURSORS_OVER_COMMIT
¶Ç´Â ResultSet.CLOSE_CURSORS_AT_COMMIT
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â »õ·Î¿î Statement
°´Ã¼
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ» ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìResultSet
PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â PreparedStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù.
ÀÌ ¸Þ¼µå´Â »ó±âÀÇ prepareStatement
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ» ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
sql
- SQL ¹®ÀÌ µ¥ÀÌŸº£À̽º¿¡ º¸³»Áö´Â String
°´Ã¼. 1°³
ÀÌ»óÀÇ ? IN ÆĶó¹ÌÅ͸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â resultSetType
- ResultSet
Á¤¼ö. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- ResultSet
Á¤¼ö. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
resultSetHoldability
- ResultSet
Á¤¼ö. ResultSet.HOLD_CURSORS_OVER_COMMIT
¶Ç´Â ResultSet.CLOSE_CURSORS_AT_COMMIT
PreparedStatement
°´Ã¼. ÁöÁ¤µÈ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ¸·Î ResultSet
°´Ã¼¸¦ »ý¼ºÇÑ´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ» ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìResultSet
CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
ResultSet
°´Ã¼¸¦ »ý¼ºÇÏ´Â CallableStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¸Þ¼µå´Â »ó±âÀÇ prepareCall
¸Þ¼µå¿Í °°½À´Ï´Ù¸¸, µðÆúÆ®ÀÇ °á°ú ¼¼Æ®ÀÇ ÇüÅÂ, °á°ú ¼¼Æ®ÀÇ concurrent processingÀÇ Á¾·ù ¹× º¸°ü À¯Áö ±â´ÉÀ» ¿À¹ö¶óÀ̵å(override) ÇÒ ¼ö ÀÖ½À´Ï´Ù.
sql
- SQL ¹®ÀÌ µ¥ÀÌŸº£À̽º¿¡ º¸³»Áö´Â String
°´Ã¼. 1°³
ÀÌ»óÀÇ ? ÆĶó¹ÌÅ͸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â resultSetType
- ResultSet
Á¤¼ö. ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ¶Ç´Â ResultSet.TYPE_SCROLL_SENSITIVE
°¡¿îµ¥ 1°³
resultSetConcurrency
- ResultSet
Á¤¼ö. ResultSet.CONCUR_READ_ONLY
¶Ç´Â ResultSet.CONCUR_UPDATABLE
resultSetHoldability
- ResultSet
Á¤¼ö. ResultSet.HOLD_CURSORS_OVER_COMMIT
¶Ç´Â ResultSet.CLOSE_CURSORS_AT_COMMIT
CallableStatement
°´Ã¼. ÁöÁ¤µÈ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ¸·Î ResultSet
°´Ã¼¸¦ »ý¼ºÇÑ´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÇüÅÂ, concurrent processing ¹× º¸°ü À¯Áö ±â´ÉÀ» ³ªÅ¸³»´Â ResultSet
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìResultSet
PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException
PreparedStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÁöÁ¤µÈ Á¤¼ö¿¡ÀÇÇØ µå¶óÀ̹ö°¡ ÀÚµ¿ »ý¼º Å°¸¦ Ãëµæ °¡´ÉÇÏ°Ô ÇÒÁö ¾î¶³Áö°¡ ÁöÁ¤µË´Ï´Ù. SQL ¹®ÀÌ INSERT
¹®ÀÌ ¾Æ´Ñ °æ¿ì, ÀÌ ÆĶó¹ÌÅÍ´Â ¹«½ÃµË´Ï´Ù.
ÁÖ: ÀÌ ¸Þ¼µå´Â ÇÁ¸®ÄÄÆÄÀÏÀÌ È¿°ú°¡ ÀÖ´Â ÆĶó¹ÌÅÍ Ã·ºÎ SQL ¹®À» ó¸®Çϱâ À§Çؼ ÃÖÀûȵǰí ÀÖ½À´Ï´Ù. µå¶óÀ̹ö°¡ ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖ´Â °æ¿ì, prepareStatement
¸Þ¼µå´Â ±× ¹®ÀåÀ» ÇÁ¸®ÄÄÆÄÀÏ¿ëÀ¸·Î¼ µ¥ÀÌŸº£À̽º¿¡ º¸³À´Ï´Ù. µå¶óÀ̹ö¿¡ µû¶ó¼´Â ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖÁö ¾Ê´Â °ÍÀÌ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì
PreparedStatement
ÀÌ ½ÇÇàµÉ ¶§±îÁö, ¹®ÀåÀº µ¥ÀÌŸº£À̽º¿¡ º¸³»ÁöÁö ¾Ê½À´Ï´Ù. ÀÌ°ÍÀº »ç¿ëÀÚ¿¡ °Ô Á÷Á¢ÀûÀÎ ¿µÇâÀº ¾ø½À´Ï´Ù¸¸, ¾î´À ¸Þ¼µå°¡ ¾î´À SQLExceptionÀ»
Throw Çß´ÂÁö¸¦ °ü°èÇØ ¿µÇâÀÌ ÀÖ½À´Ï´Ù.
¸®ÅϵÈ
PreparedStatement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
sql
- 1°³
ÀÌ»óÀÇ '? ' IN ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®autoGeneratedKeys
- ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÙÁö ¾î¶³Áö¸¦ ³ªÅ¸³»´Â Ç÷¡±×. Statement.RETURN_GENERATED_KEYS
¶Ç´Â Statement.NO_GENERATED_KEYS
PreparedStatement
°´Ã¼. ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÖ´Â ±â´ÉÀ» °¡Áø´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì, ¶Ç´Â ÁöÁ¤µÈ ÆĶó¹ÌÅÍ°¡ ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÙÁö ¾î¶³Áö¸¦ ³ªÅ¸³»´Â Statement
Á¤¼ö°¡ ¾Æ´Ñ °æ¿ìPreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException
PreparedStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¹è¿Àº »ç¿ë °¡´ÉÇÏ°Ô µÇ´Â ÀÚµ¿ »ý¼º Å°¸¦ Æ÷ÇÔÇÑ Å¸°Ù Å×À̺íÀÇ ¿ÀÇ À妽º¸¦ Æ÷ÇÔÇÕ´Ï´Ù. SQL ¹®ÀÌ INSERT
¹®ÀÌ ¾Æ´Ñ °æ¿ì, ÀÌ ¹è¿Àº ¹«½ÃµË´Ï´Ù.
IN ÆĶó¹ÌÅÍ ºÙ¾î ¶Ç´Â IN ÆĶó¹ÌÅÍ ¾øÀ½ÀÇ SQL ¹®Àº ÇÁ¸®ÄÄÆÄÀÏ ÇØ, PreparedStatement
°´Ã¼¿¡ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼, ÀÌ °´Ã¼´Â ÀÌ ¹®ÀåÀ» ¿©·¯ Â÷·Ê, È¿À²ÀûÀ¸·Î ½ÇÇàÇϴµ¥ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÁÖ: ÀÌ ¸Þ¼µå´Â ÇÁ¸®ÄÄÆÄÀÏÀÌ È¿°ú°¡ ÀÖ´Â ÆĶó¹ÌÅÍ Ã·ºÎ SQL ¹®À» ó¸®Çϱâ À§Çؼ ÃÖÀûȵǰí ÀÖ½À´Ï´Ù. µå¶óÀ̹ö°¡ ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖ´Â °æ¿ì, prepareStatement
¸Þ¼µå´Â ±× ¹®ÀåÀ» ÇÁ¸®ÄÄÆÄÀÏ¿ëÀ¸·Î¼ µ¥ÀÌŸº£À̽º¿¡ º¸³À´Ï´Ù. µå¶óÀ̹ö¿¡ µû¶ó¼´Â ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖÁö ¾Ê´Â °ÍÀÌ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì
PreparedStatement
ÀÌ ½ÇÇàµÉ ¶§±îÁö, ¹®ÀåÀº µ¥ÀÌŸº£À̽º¿¡ º¸³»ÁöÁö ¾Ê½À´Ï´Ù. ÀÌ°ÍÀº »ç¿ëÀÚ¿¡ °Ô Á÷Á¢ÀûÀÎ ¿µÇâÀº ¾ø½À´Ï´Ù¸¸, ¾î´À ¸Þ¼µå°¡ ¾î´À SQLExceptionÀ»
Throw Çß´ÂÁö¸¦ °ü°èÇØ ¿µÇâÀÌ ÀÖ½À´Ï´Ù.
¸®ÅϵÈ
PreparedStatement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
sql
- 1°³
ÀÌ»óÀÇ '? ' IN ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®columnIndexes
- »ðÀÔµÈ ÇàÀ¸·ÎºÎÅÍ ¸®ÅϵÈ
¿À» ³ªÅ¸³»´Â ¿À妽ºÀÇ ¹è¿
PreparedStatement
°´Ã¼. ÁöÁ¤µÈ ¿À妽ºÀÇ ¹è¿¿¡ ÀÇÇØ ÁöÁ¤µÇ´Â ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÖ´Â ±â´ÉÀ» °¡Áø´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ìPreparedStatement prepareStatement(String sql, String [] columnNames) throws SQLException
PreparedStatement
°´Ã¼¸¦ »ý¼ºÇÕ´Ï´Ù. ÀÌ ¹è¿Àº ¸®ÅϵÈ
ÀÚµ¿ »ý¼º Å°¸¦ Æ÷ÇÔÇÑ Å¸°Ù Å×À̺íÀÇ ¿ÀÇ À̸§À» Æ÷ÇÔÇÕ´Ï´Ù. SQL ¹®ÀÌ INSERT
¹®ÀÌ ¾Æ´Ñ °æ¿ì, ÀÌ ¹è¿Àº ¹«½ÃµË´Ï´Ù.
IN ÆĶó¹ÌÅÍ ºÙ¾î ¶Ç´Â IN ÆĶó¹ÌÅÍ ¾øÀ½ÀÇ SQL ¹®Àº ÇÁ¸®ÄÄÆÄÀÏ ÇØ, PreparedStatement
°´Ã¼¿¡ Æ÷ÇÔÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼, ÀÌ °´Ã¼´Â ÀÌ ¹®ÀåÀ» ¿©·¯ Â÷·Ê, È¿À²ÀûÀ¸·Î ½ÇÇàÇϴµ¥ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÁÖ: ÀÌ ¸Þ¼µå´Â ÇÁ¸®ÄÄÆÄÀÏÀÌ È¿°ú°¡ ÀÖ´Â ÆĶó¹ÌÅÍ Ã·ºÎ SQL ¹®À» ó¸®Çϱâ À§Çؼ ÃÖÀûȵǰí ÀÖ½À´Ï´Ù. µå¶óÀ̹ö°¡ ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖ´Â °æ¿ì, prepareStatement
¸Þ¼µå´Â ±× ¹®ÀåÀ» ÇÁ¸®ÄÄÆÄÀÏ¿ëÀ¸·Î¼ µ¥ÀÌŸº£À̽º¿¡ º¸³À´Ï´Ù. µå¶óÀ̹ö¿¡ µû¶ó¼´Â ÇÁ¸®ÄÄÆÄÀÏÀ» Áö¿ø
ÇÏ°í ÀÖÁö ¾Ê´Â °ÍÀÌ ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì
PreparedStatement
ÀÌ ½ÇÇàµÉ ¶§±îÁö, ¹®ÀåÀº µ¥ÀÌŸº£À̽º¿¡ º¸³»ÁöÁö ¾Ê½À´Ï´Ù. ÀÌ°ÍÀº »ç¿ëÀÚ¿¡ °Ô Á÷Á¢ÀûÀÎ ¿µÇâÀº ¾ø½À´Ï´Ù¸¸, ¾î´À ¸Þ¼µå°¡ ¾î´À SQLExceptionÀ»
Throw Çß´ÂÁö¸¦ °ü°èÇØ ¿µÇâÀÌ ÀÖ½À´Ï´Ù.
¸®ÅϵÈ
PreparedStatement
°´Ã¼¸¦ »ç¿ëÇØ ÀÛ¼ºµÈ °á°ú ¼¼Æ®´Â µðÆúÆ®¿¡¼´Â TYPE_FORWARD_ONLY
ÇüÅ·ÎCONCUR_READ_ONLY
concurrent processing ·¹º§À» °¡Áý´Ï´Ù.
sql
- 1°³
ÀÌ»óÀÇ '? ' IN ÆĶó¹ÌÅÍ Ç÷¹À̽ºÈ¦´õ-¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖ´Â SQL ¹®columnNames
- »ðÀÔµÈ ÇàÀ¸·ÎºÎÅÍ ¸®ÅϵÈ
¿À» ³ªÅ¸³»´Â ·Ä¸íÀÇ ¹è¿
PreparedStatement
°´Ã¼. ÁöÁ¤µÈ ·Ä¸íÀÇ ¹è¿¿¡ ÀÇÇØ ÁöÁ¤µÇ´Â ÀÚµ¿ »ý¼º Å°¸¦ µ¹·ÁÁÖ´Â ±â´ÉÀ» °¡Áø´Ù
SQLException
- µ¥ÀÌŸº£À̽º ¾×¼¼½º ¿¡·¯°¡ ¹ß»ýÇßÀ» °æ¿ì
|
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 µµ ÂüÁ¶ÇϽʽÿÀ.