|











|
|
|
 |
0 |
|
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ÀÌ ±¸¹öÀüÀ¸·Î µÇ¾î ÀÖ½À´Ï´Ù.
- ¾Æ·¡ MySQL Connector/J ´Ù¿î·Îµå ÆäÀÌÁö¿¡ Á¢¼ÓÇÕ´Ï´Ù.
MySQL Connector/J ´Ù¿î·Îµå ÆäÀÌÁö ¹Ù·Î °¡±â
- Downloads, Licensing, and Support¶ó´Â Á¦¸ñ ¾Æ·¡¿¡ º¸¸é Connector/JÀÇ ¸î °¡Áö ¹öÀüÀÌ Ç¥½ÃµÇ¾î ÀÖ½À´Ï´Ù.
ÀÌ Áß¿¡¼ MySQL Connector/J 3.0 ¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
- Source and Binaries (zip)ÀÇ Download¸¦ Ŭ¸¯ÇÏ¿© ÆÄÀÏÀ» ´Ù¿î·ÎµåÇÕ´Ï´Ù.
- JDBC µå¶óÀ̹ö ¼³Á¤
- ¾ÐÃà ÆÄÀÏÀ» Àû´çÇÑ À§Ä¡¿¡ DZ´Ï´Ù.(¿¹¸¦ µé¾î c:\jdbc)
- Áß¿ä
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 ÆÄÀÏÀ» µî·ÏÇØµÎ¾ú½À´Ï´Ù. ÀÌ ÆÄÀÏ Çϳª¸¸ À־ µË´Ï´Ù~
- ÅèĹ Àç ½ÇÇà
- ÅèĹÀ» Àç ½ÇÇàÇÕ´Ï´Ù.
ÅèĹÀÌ ½ÇÇàµÇ¸é¼ À§¿¡¼ º¹»çÇÑ Connector/J ÆÄÀÏÀ» Æ÷ÇÔÇÏ¿© ½ÇÇàÇÏ°Ô µË´Ï´Ù.
- ¾ÆÆÄÄ¡¿Í MySQLÀ» ½ÇÇàÇÏÁö ¾Ê¾Ò´Ù¸é, À̰͵µ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.
¾ÕÀ¸·ÎÀÇ ½Ç½ÀÀº, ¾ÆÆÄÄ¡-MySQL-ÅèĹÀ» ¸ðµÎ ½ÇÇàÇØ ³õ°í ½Ç½ÀÇØ¾ß ÇÕ´Ï´Ù.
APM_SetupÀ» ½ÇÇàÇϰí ÅèĹÀ» ½ÇÇàÇÏ¸é µÇ°ÚÁÒ.
ÀÌ·¸°Ô Çϸé JSP »Ó¸¸ ¾Æ´Ï¶ó PHPµµ ¸ðµÎ ±¸µ¿ÇÒ ¼ö Àִ ȯ°æÀÌ µË´Ï´Ù.
Á¤¸» ½Ç½À Çѹø Çϱâ ÈûµéÁÒ?
´ÙÀ½ ½Ã°£ºÎÅÍ´Â ÁøÂ¥·ç~ ½Ç½ÀÀ» ÇÕ´Ï´Ù. DB ¿¬µ¿ ºÎºÐÀ» ÄÚµùÇÑ´Ù´Â ¸»ÀÔ´Ï´Ù.^^
´ÙÀ½ ½Ã°£¿¡´Â insert.jsp ÆÄÀÏÀ» ¸¸µì´Ï´Ù. ±×·²·Á¸é ¾Æ·¡¿Í °°Àº Áغñ°¡ ¹Ì¸® µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
[´ÙÀ½ ½Ã°£ ½Ç½À Àü Áغñ »çÇ×]
- MySQLÀ» ÀÌ¿ëÇØ DB¿Í Å×À̺íÀ» »ý¼ºÇÑ °ÍÀ¸·Î °¡Á¤ÇÕ´Ï´Ù.(Áö³ ½Ã°£ °Á¿¡¼ ¼³¸íµå·ÈÁÒ?)
»ç¿ëÀÚ¸í : phpbbs / ÆÐ½º¿öµå : phpbbs / DB¸í : itmembers / Å×À̺í : bbs
(°ú°Å PHP °Ô½ÃÆÇÀ» ±×´ë·Î »ç¿ëÇÒ ¼ö ÀÖ°Ô Çϱâ À§ÇØ PHP °Ô½ÃÆÇÀ» À§ÇØ ¸¸µé¾ú´ø °Í°ú ¿ÏÀüÈ÷ µ¿ÀÏÇÏ°Ô ÇÏ¿´½À´Ï´Ù.)
- ÅèĹ µð·ºÅ丮ÀÇ webapps\ROOT µð·ºÅ丮¿¡ write.html ÆÄÀÏÀ» ¸¸µé¾î µÎ¾ú´Ù°í °¡Á¤ÇÕ´Ï´Ù.
webapps\ROOT\images Æú´õ¿¡´Â ¸î °³ÀÇ À̹ÌÁö ÆÄÀϵµ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
°ü·ÃµÈ ÆÄÀÏÀº ¾ÐÃàÇØ¼ ÀÚ·á½Ç¿¡ ¿Ã·Á µÎ¾ú½À´Ï´Ù.
Áö³ ½Ã°£ °Á¸¦ º¸¸é ´Ù ¼³¸íÇß´ø ³»¿ëÀÔ´Ï´Ù.

³¯ÀÌ »õ¸é ¶Ç ÇÑÁÖ°¡ ½ÃÀ۵˴ϴÙ.
ÇູÇÏ°í ´Ã ¿ôÀ» ¼ö ÀÖ´Â ÇÑÁÖ°¡ µÇ¾úÀ¸¸é ÇÕ´Ï´Ù.
ÀÌ»ó, µ¿Á־ƺü ¼Õº´¸ñÀ̾ú½À´Ï´Ù.
|
|