0
 19   2   1
  View Articles

Name  
   ¼Õº´¸ñ  (2003-03-24 01:11:59, Hit : 28434, Vote : 1800)
Homepage  
   http://www.itmembers.net
Subject  
   °Ô½ÃÆÇ ½Ç½À(3) - JDBC µå¶óÀ̹ö Áغñ
µåµð¾î JSP¿Í µ¥ÀÌÅͺ£À̽º°¡ óÀ½ ¸¸³ª´Â ÇÁ·Î±×·¥À» ½Ç½ÀÇÕ´Ï´Ù.

  • JDBC µå¶óÀ̹ö ´Ù¿î·Îµå

    JDBC µå¶óÀ̹ö´Â ÀÚ¹Ù¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ ¿¬µ¿Çϱâ À§ÇÑ µå¶óÀ̹öÀÔ´Ï´Ù.
    MySQL ¿¬µ¿À» À§ÇØ MySQL¿¡¼­ Á¦°øÇÏ´Â JDBC µå¶óÀ̹ö¸¦ ´Ù¿î·ÎµåÇØ¾ß ÇÕ´Ï´Ù.

    MySQL JDBC µå¶óÀ̹ö´Â Connector/J¶ó´Â À̸§À¸·Î Á¦°øµË´Ï´Ù.
    óÀ½ºÎÅÍ MySQL¿¡¼­ JDBC µå¶óÀ̹ö¸¦ Á¦°øÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. ¿¹Àü¿¡´Â ¸î¸î °ø°³µÈ JDBC µå¶óÀ̹ö°¡ ÀÖ¾ú´Âµ¥, ±× Áß °¡Àå À¯¸íÇß´ø °ÍÀÌ Mark Matthews°¡ ¸¸µç MM.MySQL JDBC µå¶óÀ̹ö¿´½À´Ï´Ù. ÇöÀçÀÇ Connector/J´Â ÀÌ MM.MySQL µå¶óÀ̹ö¸¦ MySQL AB»ç¿¡¼­ °ø½ÄÀûÀ¸·Î ¹Þ¾Æµé¿© º¸¿ÏÇÑ °ÍÀÔ´Ï´Ù. µû¶ó¼­ Mark MatthewsÀÇ MM.MySQLÀº ´õÀÌ»ó ¾÷±×·¹À̵åµÇÁö ¾Ê°í MySQL AB»ç¿¡¼­ Connector/J¶ó´Â À̸§À¸·Î ¾÷±×·¹À̵åÇϰí ÀÖ½À´Ï´Ù.
    ÀÌ ±ÛÀ» ¾²°í ÀÖ´Â ÇöÀç ±âÁØÀ¸·Î Connector/J´Â 3.1ÀÌ °³¹ßÁßÀÔ´Ï´Ù. 3.0ÀÌ ¾ÈÁ¤ ¹öÀüÀ̰í, 2.0ÀÌ ±¸¹öÀüÀ¸·Î µÇ¾î ÀÖ½À´Ï´Ù.

    1. ¾Æ·¡ MySQL Connector/J ´Ù¿î·Îµå ÆäÀÌÁö¿¡ Á¢¼ÓÇÕ´Ï´Ù.

      MySQL Connector/J ´Ù¿î·Îµå ÆäÀÌÁö ¹Ù·Î °¡±â

    2. Downloads, Licensing, and Support¶ó´Â Á¦¸ñ ¾Æ·¡¿¡ º¸¸é Connector/JÀÇ ¸î °¡Áö ¹öÀüÀÌ Ç¥½ÃµÇ¾î ÀÖ½À´Ï´Ù.
      ÀÌ Áß¿¡¼­ MySQL Connector/J 3.0 ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.

    3. Source and Binaries (zip)ÀÇ Download¸¦ Ŭ¸¯ÇÏ¿© ÆÄÀÏÀ» ´Ù¿î·ÎµåÇÕ´Ï´Ù.


  • JDBC µå¶óÀ̹ö ¼³Á¤

    1. ¾ÐÃà ÆÄÀÏÀ» Àû´çÇÑ À§Ä¡¿¡ DZ´Ï´Ù.(¿¹¸¦ µé¾î c:\jdbc)

    2. Áß¿ä
      jdbcÀÇ ÇÏÀ§ Æú´õÀÎ mysql-connector-java-3.0.6-stable¿¡¼­ mysql-connector-java-3.0.6-stable-bin.jar ÆÄÀÏÀ»,
      ÀÚ¹Ù°¡ ¼³Ä¡µÈ µð·ºÅ丮(¿¹¸¦ µé¾î, c:\j2sdk1.4.1_02)ÀÇ jre\lib\ext µð·ºÅ丮¿¡ º¹»çÇÕ´Ï´Ù.

      ¿ø·¡´Â, ÀÌ·¸°Ô Á÷Á¢ º¹»çÇÏÁö ¾Ê°í ½Ã½ºÅÛ È¯°æ º¯¼ö·Î CLASSPATH¸¦ ¸¸µé¾î mysql-connector-java-3.0.6-stable-bin.jarÆÄÀÏÀÇ À§Ä¡¸¦ ÁöÁ¤ÇØ ÁÖ¾î¾ß Çϴµ¥, ¹ø°Å·Ó±âµµ Çϰí Windows¿¡¼­ Àß ÀÛµ¿ÇÏÁö ¾Ê´Â °Í °°¾Æ Á÷Á¢ º¹»çÇÏ´Â ¹æ¹ýÀ» »ç¿ëÇÑ °ÍÀÔ´Ï´Ù.
      ±×·¸´Ù°í À̰ÍÀÌ Æí¹ýÀº ¾Æ´Õ´Ï´Ù. Connector/J ¼³Ä¡ ¸Å´º¾ó¿¡ º¸¸é,
      Put mysql-connector-java-3.0.6-stable-bin.jar in your classpath, either by adding the FULL path to it to your CLASSPATH enviornment variable, or putting it in $JAVA_HOME/jre/lib/ext.
      ÀÌ·¸°Ô Á÷Á¢ º¹»çÇØ ³Ö¾îµµ µÈ´Ù°í ¸í½ÃµÇ¾î ÀÖ½À´Ï´Ù.

      ¡Ø ÀÚ·á½Ç¿¡ mysql-connector-java-3.0.6-stable-bin.jar ÆÄÀÏÀ» µî·ÏÇØµÎ¾ú½À´Ï´Ù. ÀÌ ÆÄÀÏ Çϳª¸¸ À־ µË´Ï´Ù~



  • ÅèĹ Àç ½ÇÇà

    1. ÅèĹÀ» Àç ½ÇÇàÇÕ´Ï´Ù.
      ÅèĹÀÌ ½ÇÇàµÇ¸é¼­ À§¿¡¼­ º¹»çÇÑ Connector/J ÆÄÀÏÀ» Æ÷ÇÔÇÏ¿© ½ÇÇàÇÏ°Ô µË´Ï´Ù.

    2. ¾ÆÆÄÄ¡¿Í MySQLÀ» ½ÇÇàÇÏÁö ¾Ê¾Ò´Ù¸é, À̰͵µ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.

      ¾ÕÀ¸·ÎÀÇ ½Ç½ÀÀº, ¾ÆÆÄÄ¡-MySQL-ÅèĹÀ» ¸ðµÎ ½ÇÇàÇØ ³õ°í ½Ç½ÀÇØ¾ß ÇÕ´Ï´Ù.
      APM_SetupÀ» ½ÇÇàÇϰí ÅèĹÀ» ½ÇÇàÇÏ¸é µÇ°ÚÁÒ.
      ÀÌ·¸°Ô Çϸé JSP »Ó¸¸ ¾Æ´Ï¶ó PHPµµ ¸ðµÎ ±¸µ¿ÇÒ ¼ö Àִ ȯ°æÀÌ µË´Ï´Ù.


    Á¤¸» ½Ç½À Çѹø Çϱâ ÈûµéÁÒ?
    ´ÙÀ½ ½Ã°£ºÎÅÍ´Â ÁøÂ¥·ç~ ½Ç½ÀÀ» ÇÕ´Ï´Ù. DB ¿¬µ¿ ºÎºÐÀ» ÄÚµùÇÑ´Ù´Â ¸»ÀÔ´Ï´Ù.^^

    ´ÙÀ½ ½Ã°£¿¡´Â insert.jsp ÆÄÀÏÀ» ¸¸µì´Ï´Ù. ±×·²·Á¸é ¾Æ·¡¿Í °°Àº Áغñ°¡ ¹Ì¸® µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.

    [´ÙÀ½ ½Ã°£ ½Ç½À Àü Áغñ »çÇ×]

    1. MySQLÀ» ÀÌ¿ëÇØ DB¿Í Å×À̺íÀ» »ý¼ºÇÑ °ÍÀ¸·Î °¡Á¤ÇÕ´Ï´Ù.(Áö³­ ½Ã°£ °­Á¿¡¼­ ¼³¸íµå·ÈÁÒ?)
      »ç¿ëÀÚ¸í : phpbbs / ÆÐ½º¿öµå : phpbbs / DB¸í : itmembers / Å×À̺í : bbs
      (°ú°Å PHP °Ô½ÃÆÇÀ» ±×´ë·Î »ç¿ëÇÒ ¼ö ÀÖ°Ô Çϱâ À§ÇØ PHP °Ô½ÃÆÇÀ» À§ÇØ ¸¸µé¾ú´ø °Í°ú ¿ÏÀüÈ÷ µ¿ÀÏÇÏ°Ô ÇÏ¿´½À´Ï´Ù.)

    2. ÅèĹ µð·ºÅ丮ÀÇ webapps\ROOT µð·ºÅ丮¿¡ write.html ÆÄÀÏÀ» ¸¸µé¾î µÎ¾ú´Ù°í °¡Á¤ÇÕ´Ï´Ù.
      webapps\ROOT\images Æú´õ¿¡´Â ¸î °³ÀÇ À̹ÌÁö ÆÄÀϵµ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
      °ü·ÃµÈ ÆÄÀÏÀº ¾ÐÃàÇØ¼­ ÀÚ·á½Ç¿¡ ¿Ã·Á µÎ¾ú½À´Ï´Ù.

      Áö³­ ½Ã°£ °­Á¸¦ º¸¸é ´Ù ¼³¸íÇß´ø ³»¿ëÀÔ´Ï´Ù.



³¯ÀÌ »õ¸é ¶Ç ÇÑÁÖ°¡ ½ÃÀ۵˴ϴÙ.
ÇູÇÏ°í ´Ã ¿ôÀ» ¼ö ÀÖ´Â ÇÑÁÖ°¡ µÇ¾úÀ¸¸é ÇÕ´Ï´Ù.

ÀÌ»ó, µ¿Á־ƺü ¼Õº´¸ñÀ̾ú½À´Ï´Ù.

Prev
   °Ô½ÃÆÇ ½Ç½À(4) - ÀÔ·Â ±Û ÀúÀåÇϱâ(1) insert.jsp ¼Ò½º

¼Õº´¸ñ
Next
   °Ô½ÃÆÇ ½Ç½À(2) - µ¥ÀÌÅͺ£À̽º¿Í ÀÔ·Â Æû ¸¸µé±â

¼Õº´¸ñ


Copyright 1999-2025 Zeroboard / skin by Zetyx