±Û¾´ÀÌ :³ª°æ±Ç 1998³â 6¿ù 23ÀÏ 23:03:26
In Reply to: jdbc¿¬°á¹æ¹ý ¾Ë·ÁÁÖ¼¼¿ä posted by ÃÖÈ¿Á¤ on 1998³â 6¿ù 23ÀÏ 16:57:23:
String dirverName =
"oracle.jdbc.driver.OravleDriver";
À§ÀÇ ³»¿ëÀ» ¼³¸íÇÏÀÚ¸é ¸ÕÀú OracleDriver¶ó´Â Ŭ·¡½ºÀÔ´Ï´Ù.
Á¤È®È÷º¸¸é, ¿À¶óŬ¿¡¼ Á¦°øÇÏ´Â JDBCµå¶óÀ̹ö´Â µÎ°¡Áö·Î ±¸¼º
µÇ¾î ÀÖ½À´Ï´Ù.
OCIÇÏ°í Thinµå¶óÀ̹öÀÔ´Ï´Ù.
ÀÌ OracleDriverŬ·¡½º´Â ³»ºÎÀûÀ¸·Î À§ ¼Ò½º¿¡¼
Connection dbcon=
DriverManager.getConnection
("jdbc:oracle:thin:@203.248.150.167:1521:orcl"
//¹Ù·Î À̺κÐÀÇ µå¶óÀ̹ö ¸Þ´ÏÁ® Ŭ·¡½º¸¦ È£ÃâÇؼ
thinÀ̶ó´Â ½ºÆ®¸µÀ» »Ì¾Æ³»¼ µå¶óÀ̹öÀÇ Å¸ÀÔ´ë·Î
classForName()À» ÅëÇؼ ¸Þ¸ð¸®¿¡ ·Îµå½ÃÄÑÁÝ´Ï´Ù.
,"scote","tiger");
//ÇÑ°¡Áö ´ëºÎºÐ JDBC API´Â Ãß»óŬ·¡½º¿Í ÀÎÅÍÆäÀ̽º·Î
±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
¼±ÀÇ ¹®¼¸¦ º¸½Ã¸é ¾Ë ¼ö ÀÖ½À´Ï´Ù.
ÀÌ·¯ÇÑ °ÍÀ» µå¶óÀ̹ö °³¹ßÀÚ°¡ Ŭ·¡½º·Î ±¸ÇöÇÑ °ÍÀÔ´Ï´Ù.
´Ù½Ã Çѹø óÀ½ºÎºÐÀ» Á¤¸®ÇÏ¸é ¿À¶óŬ µå¶óÀ̹ö¿¡ º¸¸é
classes111.zipÈÀÏÀÌ ÀÖÀ» °Ì´Ï´Ù.
ÀÌ ÈÀÏÀÇ ¾ÐÃàÀ» Ç®¾îº¸¼¼¿ä.(±ÇÀåÇÏ´Â °ÍÀº ¾Æ´Õ´Ï´Ù.)
±×·¯¸é
String dirverName =
"oracle.jdbc.driver.OravleDriver";
À§ÀÇ ³»¿ëÀÌ ÀÌ·¸°Ô µÇ¾î ÀÖÀ» °Ì´Ï´Ù.
/oracle/
-------/jdbc/
------------/driver/
-------------------/OracleDriver.class
À¹, Àû¾î ³ª°¡´Ùº¸´Ï ±â¾ïÀÌ ³ªÁú ¾Ê³×¿ä. Èæ
(À§ÀÇ µð·ºÅ丮 ±¸Á¶´Â Á¤È®ÇÑ Áö´Â ±â¾ïÀÌ °¡¹°°¡¹°ÇÕ´Ï´Ù.)
ºÎÁ·ÇÏÁö¸¸ µµ¿òÀÌ µÇ½Ã±æ ¹Ù¶ó±¸¿ä.
http://www.iworld.net/~nakk/¸¦ Âü°í Çغ¸¼¼¿ä.
(»ç½Ç º°·Î ³»¿ëÀº ¾ø½À´Ï´Ù. ¾÷ÀÌ ¸¹ÀÌ ¾ÈµÅ¼...)