½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
happycgi
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > JAVA,JSP > JSP ¼Ò½ºÃ¢°í > °Ô½ÃÆÇ > kimhoboard ver1.0 JSP °Ô½ÃÆÇ ¼Ò½º »ó¼¼Á¤º¸
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
ASP
CSS
html
mysql
jquery
image
API
Mobile
¸Þ´º
slide
°Ô½ÃÆÇ
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
kimhoboard ver1.0 JSP °Ô½ÃÆÇ ¼Ò½º
¼Ò½ºÅë°èÁ¤º¸ ¿À·ù½Å°í ¹× ¹®ÀÇ
ÇØÇÇÆÀ
³×ƼÁð
Æ®À§ÅÍ·Î º¸³»±â ÆäÀ̽ººÏÀ¸·Î º¸³»±â
¼Ò½ººÐ·ù °Ô½ÃÆÇ
´Ù¿î·Îµå Ƚ¼ö 2765 ȸ
°£´Ü¼³¸í kimhoboard ver 1.0¹öÀüÀÔ´Ï´Ù.
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
ȨÆäÀÌÁö¹Ù·Î°¡±â ¼Ò½º´Ù¿î·Îµå µ¥¸ð ¹Ì¸®º¸±â°¡ ¾ø½À´Ï´Ù ½ºÅ©·¦Çϱâ
ÀÌ °Ô½ÃÆÇÀº ´©±¸³ª »ç¿ëÇÏ½Ç ¼ö ÀÖ´Â °ø°³¿ë JSP °Ô½ÃÆÇÀÔ´Ï´Ù.
´Ü, »ó¾÷Àû ¸ñÀûÀ¸·Î´Â »ç¿ëÇÏ½Ç ¼ö ¾ø½À´Ï´Ù.
ÀÌ °Ô½ÃÆÇÀº ÅèÄÏ 4.0, ¾ÆÆÄÄ¡ 1.3.22 ¹öÀü¿¡¼­ Å×½ºÆ®µÇ¾ú½À´Ï´Ù.
kimhoboard ver 1.0ÀÇ Æ¯Â¡Àû ±â´ÉÀº ´ÙÀ½°ú °°½À´Ï´Ù.

- JSP Model 1 architecture ¿¡ ÀÇÇÑ ¼³°è (JSP + ºóÁî)

- ´äº¯ ±â´ÉÀ» Æ÷ÇÔÇÑ ±âº»ÀûÀÎ °Ô½ÃÆÇ ±â´É

- TEXT / HTML ¸ðµå ¼±Åà ±Û ÀúÀå

- °¡»ó ±Û¹øÈ£¿¡ ÀÇÇÑ ¸®½ºÆ® Ãâ·Â

- º°µµÀÇ Paging ¸ðµâ °ü¸®

- °ü¸®ÀÚ ±ÇÇÑ ¼öÁ¤,»èÁ¦ ±â´É

- ÆÄÀÏ ¾÷·Îµå ±â´É

- ÆÄÀÏ ¾÷·Îµå½Ã Áߺ¹ ÆÄÀÏ Ã¼Å© ±â´É

- ÆÄÀÏ ¾÷·Îµå½Ã ¿ë·® üũ ±â´É (2M)



##¼³Ä¡ ¸Å´º¾ó

1. ¸ÕÀú °¢ DB ¹öÀü¿¡ ¸Â´Â JDBC µå¶óÀ̹ö¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
JDBC µå¶óÀ̹ö ¼³Ä¡ ¹æ¹ýÀº Á¦ »çÀÌÆ® °­ÁµîÀ» Âü°íÇϼ¼¿ä.


2. ÅèÄÏÀÇ webapps µð·ºÅ丮 ¹Ø¿¡ ´Ù¿î·Îµå ¹ÞÀº °Ô½ÃÆÇ ¼Ò½º ÆÄÀÏÀÇ ¾ÐÃàÀ» DZ´Ï´Ù.
±×·¯¸é kimhoboard¶ó´Â µð·ºÅ丮°¡ »ý±é´Ï´Ù.

3. kimhoboard¶ó´Â µð·ºÅ丮 ¾Æ·¡¿¡ÀÖ´Â jdbctest.jsp ÆÄÀÏÀ» ½ÇÇàÇÏ¿© JDBC ¼³Á¤ÀÌ
Á¦´ë·Î µÇ¾îÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù.
¸¸¾à ¿¡·¯°¡ ¹ß»ýÇϸé JDBC ¼³Á¤À» ´Ù½ÃÇѹø È®ÀÎÇÕ´Ï´Ù.

3. kimhoboard µð·ºÅ丮 ¹Ø¿¡ WEB-INF µð·ºÅ丮 ¹Ø¿¡ classes ¶ó´Â µð·ºÅ丮·Î À̵¿Çϼż­
´ÙÀ½°ú °°Àº ¼ø¼­·Î ÄÄÆÄÀÏÀ» ½Ç½ÃÇÕ´Ï´Ù.

# javac DBConnectionManager.java
# javac -d . DBConn.java
# javac -d . SQLResult.java
# javac -d . Admin.java
# javac -d . deleteAct.java
# javac -d . Edit.java
# javac -d . Paging.java
# javac -d . View.java
# javac -d . writeAct.java
# javac -d . Reply.java
# javac MultipartRequest.java


4. db.properties ÆÄÀÏÀ» ´ÙÀ½°ú °°ÀÌ ÀÚ½ÅÀÇ È¯°æ¿¡ ¸Â°Ô ¼öÁ¤ÇÕ´Ï´Ù.
drivers=org.gjt.mm.mysql.Driver
logfile=DBConnectionManager_log.txt
mycon.url=jdbc:mysql://localhost/mydb
mycon.maxconn=0
mycon.user=kimho
mycon.password=1234

-> JDBCµå¶óÀ̹ö¸í
-> ·Î±×ÆÄÀϸí
-> JDBC URL
-> ÃÖ´ë Ä¿³Ø¼Ç ¼ö
-> DB Á¢¼Ó ¾ÆÀ̵ð
-> DB Á¢¼Ó Æнº¿öµå




6. kimhoboard µð·ºÅ丮 ¾Æ·¡¿¡ ÀÖ´Â table.sql ÆÄÀÏÀ» ÆíÁý±â·Î ¿­¾î¼­
SQL¹®Àå´ë·Î Å×À̺íÀ» ¸¸µì´Ï´Ù.

5. ºê¶ó¿ìÀú¿¡¼­ http://ÀÚ½ÅÀÇ URL/kimhoboard/write.jsp ·Î Á¢¼ÓÇÕ´Ï´Ù.



--------------------------------------------------------------------------------


##. ȯ°æ ¼³Á¤

1. °ü¸®ÀÚ Æнº¿öµå¸¦ º¯°æÇÏ°íÀÚ ÇÒ ¶§ :
Admin.java ÆÄÀÏ¿¡¼­ ´ÙÀ½ ºÎºÐÀ» ¼öÁ¤ÇÑ ÈÄ ´Ù½Ã Admin.java¸¦ ÄÄÆÄÀÏÇÕ´Ï´Ù.

private String adminpwd="adminpwd"; // ¿øÇÏ´Â Æнº¿öµå·Î º¯°æ


2. ÆÄÀÏÀÌ ¾÷·Îµå µÉ °æ·Î¸¦ ¼öÁ¤ÇÏ°íÀÚ ÇÒ ¶§ :
DBConn.java ÆÄÀÏ¿¡¼­ ´ÙÀ½ ºÎºÐÀ» ¼öÁ¤ÇÑ ÈÄ ´Ù½Ã DBConn.java¸¦ ÄÄÆÄÀÏÇÕ´Ï´Ù.

protected String filepath="C:\jakarta-tomcat\webapps\kimhoboard\upload"; ->°æ·Î¼öÁ¤

upload.jsp¿¡¼­ ´ÙÀ½ ºÎºÐÀ» ¼öÁ¤ÇÕ´Ï´Ù.

MultipartRequest parser
= new MultipartRequest(request.getContentType(),
request.getContentLength(),request.getInputStream(),
"C:\jakarta-tomcat\webapps\kimhoboard\upload"); -> °æ·Î¼öÁ¤

ÀÌ ¶§ ÇØ´ç °æ·Î¿¡ upload¶ó´Â µð·ºÅ丮°¡ Á¸ÀçÇØ¾ß ÇÕ´Ï´Ù.


3. ÇÑ È­¸é¿¡ ¸î ÆäÀÌÁö¾¿ ¸µÅ©¸¦ Ãâ·ÂÇÒ °ÍÀÎÁö ¼³Á¤ÇÏ°íÀÚ ÇÒ ¶§ :
list_head.jsp¿¡¼­ ´ÙÀ½ ºÎºÐÀ» ã¾Æ ³¡ÀÇ ¼ýÀÚ¸¦ ¿øÇÏ´Â ¸¸Å­À¸·Î ¼öÁ¤ÇÕ´Ï´Ù.
Paging paging
= new Paging(request.getParameter("mypage")==null?"1":request.getParameter("mypage"),5);
-> ¼ýÀÚ ¼öÁ¤




³×ƼÁð ÀÇ°ß   ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.)
³»¿ë ¾ÆÀ̵ð ÀÇ°ß³²±â±â
¿¡·¯°¡ ³ª¸é ±èÈ£´Ô »çÀÌÆ®¸¦ Á÷Á¢ ¹æ¹®Çؼ­ ÇØ°áÇغ¸¼¼¿ä.
2002-03-02 00:00:00
óº¸
Âù¼º 76
¹Ý´ë 71
´ÙÀ½°ú °°Àº ¿¡·¯°¡ ÀÚ²Ù ¶ß´Â±º¿ä....
¼³Ä¡ ¹æ¹ý°ú ȯ°æ¼³Á¤À» ´ÙÇÏ°í ½ÇÇàÇÏ´Ï±î ½ÇÇàÀÌ µÇÁú ¾Ê½À´Ï´Ù...

Error: 500
Location: /home/userboard/write.jsp
Internal Servlet Error:

org.apache.jasper.compiler.CompileException: C:jakarta-tomcatwebappsROOThomeuserboardwrite.jsp(13,8) Bad file argument to include
at org.apache.jasper.compiler.JspParseEventListener.handleDirective(JspParseEventListener.java:728)
at org.apache.jasper.compiler.DelegatingListener.handleDirective(DelegatingListener.java:116)
at org.apache.jasper.compiler.Parser$Directive.accept(Parser.java:215)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1077)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1042)
at org.apache.jasper.compiler.Parser.parse(Parser.java:1038)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:209)
at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:612)
at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:258)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:268)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:806)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)

2002-02-26 00:00:00
ÇãÁ¢Ãʺ¸
Âù¼º 77
¹Ý´ë 74
1
À̸§
³»¿ë
:³×¸Â¾Æ¿ä: :È­³ª´Â±º¿ä: :Àá¿Í: :¿ì¿ïÇØ: :À̰ǾƳÄ: :¿ÕÇÏÇÏ: ¿Õ¿ôÀ½~ ³î·¥~
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
µµ¹è¹æÁöÅ°
 20642754 º¸ÀÌ´Â µµ¹è¹æÁöÅ°¸¦ ÀÔ·ÂÇϼ¼¿ä.