°¡À̵å¶óÀΠȨÆäÀÌÁö www.guideline.co.kr
°¡À̵å¶óÀÎ, »ç¾÷ÀÚµî·Ï¹øÈ£ 109-03-42915, ¹®ÀÇÇϱâ
TEL 070-4155-6478, Since 2001, °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
¼­ºñ½º ½Åû ¼­ºñ½º ÀÌ¿ë¹ý My Setting ÀÌÇÏ ¸Þ´º´Â ȸ¿øÀ¸·Î ·Î±×ÀÎ ÇÏ¼Å¾ß ÇÕ´Ï´Ù. My µµ¸ÞÀÎ ÀÏ´ëÀÏ °Ô½ÃÆÇ °³ÀÎÁ¤º¸º¯°æ My DB My HDD ³³ºÎ ³»¿ªµî·Ï
¾ÆÀ̵ð
ºñ¹Ð¹øÈ£
¾ÆÀ̵ð/ºñ¹Ð¹øÈ£ ã±â
³×ÀÓ¼­¹ö Á¤º¸
1Â÷ ns.gnameserver.net
211.239.124.250
2Â÷ ns2.gnameserver.net
211.239.124.251
À¥È£½ºÆÃ ¿¬Àå ¾È³»
ÀÔ±Ý °èÁ Á¤º¸
¿ì¸®ÀºÇà ȨÆäÀÌÁö·Î »õâ ¿­±â
ÀºÇà: ¿ì¸®ÀºÇà
°èÁÂ: 810-184634-02-001
¿¹±ÝÁÖ: ÀüÀç¿ì
¼±³³°¡´É(°³¿ù¼ö °ü°è¾øÀ½)
(³³ºÎÀÚ¸í¿¡ ȸ¿ø ID·Î ÀÔ±Ý ÈÄ ³³ºÎ³»¿ªµî·Ï,ÀÏ´ëÀÏ °Ô½ÃÆÇ¿¡ ¾Ë·ÁÁÖ¼¼¿ä.)
Ä«µå°áÁ¦ ¿ä±Ý³³ºÎ
¼¼±Ý°è»ê¼­ ¹ßÇà ½Åû
Redhat Linux, Apache, Ant, Tomcat, Java, MySQL, PHP, Qmail, Python, vsftpd
(guideline QR code)
  Á¦¸ñ : JSP, Servlet ÀÌ¿ë¹ý ±Û ¹øÈ£  
±ÛÀÚ Å©±â : ±ÛÀÚ Å©°Ô ±ÛÀÚ ÀÛ°Ô
<% @ page contentType="text/html;charset=euc-kr" %>

ÇѱÛÀÌ ±ú¾îÁö´Â Çö»ó ó¸® ¹æ¹ý:
<%@ page import="java.sql.*" contentType="text/html;charset=euc-kr"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
DriverManager.getConnection("jdbc:mysql://db1.guideline.co.kr/Database_name?autoReconnect=true&useUnicode=true&characterEncoding=euc-kr"
,"MySQL_id","MySQL_password");
%>

À§ÀÇ ¹®±¸¿¡¼­ characterEncoding=euc-kr ó·³ DB ¿¡¼­ °¡Á®¿Ã ¶§ ÀÎÄÚµùÇÒ charsetÀ» ÁöÁ¤ÇØ ÁÖ¾î¾ß ÇÕ´Ï´Ù.

- class, beans ÆÄÀϵéÀº www/WEB-INF/classes/ ¾Æ·¡¿¡ µÎ½Ã¸é µË´Ï´Ù.
- jar ÆÄÀÏÀÏ °æ¿ì´Â www/WEB-INF/classes ¿¡ jar ¸¦ Ǫ½Å ÈÄ¿¡ »ç¿ëÇÏ½Ã¸é µË´Ï´Ù. jar Ǫ´Â ¹ýÀº
jar xvf jarfile.jar ó·³ ÇÏ½Ã¸é ´Ï?
- ServletÀº www/WEB-INF/classes ¿¡ Servlet class ÆÄÀϵéÀ» µÎ½Ã°í /servlet/class_file_name
À¸·Î È£ÃâÇÏ½Ã¸é µË´Ï´Ù. domain ÀÌ www.guideline.co.kr À̰í Servlet class ÆÄÀÏÀÌ list.class ÀÏ °æ¿ì
http://www.guideline.co.kr/servlet/list ¸¦ Ä¡½Ã¸é servlet ÆÄÀÏÀÌ ½ÇÇàµË´Ï´Ù.

- MySQL JDBC µå¶óÀ̹ö´Â /home/jdk/usr_lib/mm.mysql-2.0.12 ¿¡ ¼³Ä¡µÇ¾î ÀÖ½À´Ï´Ù.
- WEB-INF/web.xml À» »ç¿ë½Ã ¿¡·¯°¡ ³¯ °æ¿ì ºÎµæÀÌÇÏ°Ô ÇØ´ç »ç¿ëÀÚÀÇ ÅèĹ ¼­ºñ½º¸¦
Á¦ÇÑÇÏ°Ô µË´Ï´Ù. ÁÖÀÇ ÇÏ½Ç Á¡Àº DTD Web Application 2.3 À» »ç¿ëÇϽÃÁö ¸¶½Ã°í
DTD Web Application 2.2 ¸¦ »ç¿ëÇϽñ⠹ٶø´Ï´Ù. ·ÎÄÿ¡¼­ ¹Ýµå½Ã Å×½ºÆ® ÈÄ¿¡ ¿Ã·Á
Áֽñ⠹ٶø´Ï´Ù.

mysql drive ¿¬°á ¹æ¹ý :
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection DBCon =
DriverManager.getConnection("jdbc:mysql://DB Server¸í/Database¸í?autoReconnect=true&useUnicode=true&characterEncoding=euc-kr","MySQL ¾ÆÀ̵ð","MySQL ÆÐ½º¿öµå");
%>

Database¸í¿¡ autoReconnect=true&useUnicode=true&characterEncoding=euc-kr
¸¦ ºÙ¿©ÁÖ°í characterEncoding ÀÌ ´Ù¸£´Ù¸é ÇØ´ç charset¸¦ ³Ö¾î ÁÖ¸é µÈ´Ù.
±×¶§¿¡ ¹Ýµå½Ã °°Àº charsetÀ¸·Î <% @ page contentType="text/html;charset=[¿ä±â]" %>
¸ÂÃçÁØ´Ù.


mysql drive path°¡ ÀÚµ¿À¸·Î ÁöÁ¤ µÇ¾î ÀÖ¾î ¹Ù·Î »ç¿ëÇÏ½Ã¸é µË´Ï´Ù.

db pool °°Àº °æ¿ì ÇØ´ç connectionÀÇ ¼ö¸¦ À¶Å뼺 ÀÖ°Ô Á¶Àý ÇÏ¿© »ç¿ëÇÏ½Ã±æ ¹Ù¶ø´Ï´Ù.
Tomcat 3.3.1 ÀÏ °æ¿ì¿¡´Â packageÈ­ ½Ãų ÇÊ¿ä¾ø´Âµ¥
Tomcat 4.1.12 À» »ç¿ëÇÒ¶§¿¡´Â WEB-INF/classes/packageÆú´õ¸í
package¸¦ ¸¸µé¾î¼­ import ÇØ ÁÖ½Ã±æ ¹Ù¶ø´Ï´Ù.

*web-app_2_3.dtdÀ» »ç¿ë½Ã tomcat3 ¿£Áø¿¡ ¹®Á¦°¡ ÀÖ¾î
¾Æ·¡¿Í °°ÀÌ »ç¿ëÇØ ÁÖ½Ã±æ ¹Ù¶ø´Ï´Ù.

ÆÄÀϸí : web.xml
--------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN"
"http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
--------------------------------------------------------------------------------------------
µî·ÏÀÏ   2002-01-18
Á¶È¸¼ö   26104
´ÙÀ½±Û : MySQL Á¢¼Ó ¹× ¹é¾÷ º¹±¸´Â ¾î¶»°Ô Çϳª¿ä? (2002-01-21)
¼­¹ö »ç¾ç ¹× ¼­¹ö ÇÁ·Î±×·¥ ¹öÀüÀº? (2002-01-17) : ÀÌÀü±Û

°¡À̵å¶óÀÎ [¼­ºñ½º ÀÌ¿ë¹ý] Á¦¸ñ ³»¿ë  
¹øÈ£ ¼­ºñ½º ÀÌ¿ë¹ý Á¶È¸ µî·ÏÀÏ
18 °èÁ¤ ¿ë·® Ãß°¡´Â ¾î¶»°Ô Çϳª¿ä? 16952 2002-01-31
17 Á¤ÁöµÈ »ç¿ëÀÚÀÇ º¹±¸´Â ¾ðÁ¦ µÇ³ª¿ä? 16438 2002-01-28
16 ¸¸±âÀÏÀ» ¾î¶»°Ô È®ÀÎ Çϳª¿ä? 17431 2002-01-25
15 Mysql Table¸í¿¡ ´ë¼Ò¹®ÀÚ ±¸º°À» ÇÕ´Ï´Ù. 21235 2002-01-24
14 óÀ½ °¡ÀÔÀ» Çߴµ¥ °èÁ¤ ¼¼ÆÃÀº ¾ðÁ¦ Çϳª¿ä? 17896 2002-01-24
13 µµ¸ÞÀÎ µî·Ï ´ëÇà ¼­ºñ½ºµµ °°ÀÌ Çϳª¿ä? 17400 2002-01-23
12 MySQL Á¢¼Ó ¹× ¹é¾÷ º¹±¸´Â ¾î¶»°Ô Çϳª¿ä? 42121 2002-01-21
11 JSP, Servlet ÀÌ¿ë¹ý 26104 2002-01-18
10 ¼­¹ö »ç¾ç ¹× ¼­¹ö ÇÁ·Î±×·¥ ¹öÀüÀº? 20121 2002-01-17
9 Telnet, FTP ÁÖ¼Ò ¾î¶»°Ô µÇ³ª¿ä? 20555 2002-01-16
8 ÇÑ±Û µµ¸ÞÀÎ ¼­ºñ½º ¹æ¹ý 16931 2002-01-16
7 Email, MySQL ÆÐ½º¿öµå º¯°æ 19524 2002-01-16
6 Telnet, FTP ºñ¹Ð¹øÈ£(ÆÐ½º¿öµå) º¯°æ ¹æ¹ý 32985 2002-01-16
5 ÇöÀç °èÁ¤ÀÇ »ç¿ë ¿ë·® È®ÀÎ 19184 2002-01-16
4 ¸ÞÀÏ ¼­¹ö ÀÌ¿ë¹ý (smtp,pop3,imap) 68837 2002-01-16
1 2 3 4 5 6 7 8


 
°¡À̵å¶óÀÎ, »ç¾÷ÀÚµî·Ï¹øÈ£ 109-03-42915, ´ëÇ¥ÀÚ ÀüÀç¿ì   TEL) 070-4155-6478  Åë½ÅÆÇ¸Å¹øÈ£ 2022-¼­¿ï¼ººÏ-0661
¼­¿ï ¼ººÏ±¸ ¿ù°î·Î18±æ 5-11 101È£ °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§, ÀÌ¿ë¾à°ü, ¹®ÀÇÇϱâ