½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
happycgi
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > JAVA,JSP > JSP ¼Ò½ºÃ¢°í > °Ô½ÃÆÇ > [oracle] okboard 0.97 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ ¼Ò½º »ó¼¼Á¤º¸
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
javascript
PHP
HTML
ASP
mysql
CSS
Mobile
image
jquery
slide
¸Þ´º
�޴�
2023
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
[oracle] okboard 0.97 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ ¼Ò½º
¼Ò½ºÅë°èÁ¤º¸ ¿À·ù½Å°í ¹× ¹®ÀÇ
ÇØÇÇÆÀ
³×ƼÁð
Æ®À§ÅÍ·Î º¸³»±â ÆäÀ̽ººÏÀ¸·Î º¸³»±â
¼Ò½ººÐ·ù °Ô½ÃÆÇ
´Ù¿î·Îµå Ƚ¼ö 2535 ȸ
°£´Ü¼³¸í ¾÷±×·¹À̵åµÈ okboard 0.97 ´äº¯Çü ÀÚ·á°Ô½ÃÆÇÀÔ´Ï´Ù.
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
ȨÆäÀÌÁö¹Ù·Î°¡±â ¼Ò½º´Ù¿î·Îµå µ¥¸ð ¹Ì¸®º¸±â°¡ ¾ø½À´Ï´Ù ½ºÅ©·¦Çϱâ
/*
[oracle] okboard 0.97 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ ¼Ò½º
ÀÛ¼ºÀÚ : kenu@okjsp.pe.kr
¹èÆ÷ó : http://www.okjsp.pe.kr
ÀÛ¼ºÀÏ : 2002-01-15 4:40¿ÀÀü
Å×½ºÆ® : http://okjsp.pe.kr/ Q&A °Ô½ÃÆÇ
Contact: http://210.122.97.37:8880/okboard/board.jsp?bbs=okboard
skin design by À¯Àº¿µ eyyoo@pharmsnet.com

LICENSE: ±â¾÷ÀÌµç °³ÀÎ »ç¿ëÀÚÀÌµç °Ô½ÃÆÇ ÇÏ´Ü¿¡ http://okjsp.pe.kr ¸µÅ©¸¦ Áö¿ìÁö ¾Ê´Â
Á¶°Ç ÇÏ¿¡ ¹«·á·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÇÇÄ¡¸øÇÒ »çÁ¤À¸·Î ÀúÀÛ±Ç Ç¥½Ã¸¦ Á¦°ÅÇØ¾ß ÇÑ´Ù¸é kenu@okjsp.pe.kr ·Î ¿¬¶ôÇϼż­
¼ÒÁ¤ÀÇ ºñ¿ëÀ» ÁöºÒÇØ¾ß ÇÕ´Ï´Ù.

±¸ÀÔ¹öÁ¯°ú ¹«·á¹èÆ÷º»°úÀÇ Â÷ÀÌ´Â ´ÜÁö ÀúÀÛ±Ç Ç¥½Ã À¯¹«ÀÏ »ÓÀÔ´Ï´Ù.
±×¿ÜÀÇ ¾î¶² ±â¼úÀûÀÎ Áö¿øÀ̳ª ¼³Ä¡µîÀÇ Áö¿øµµ Çص帮Áö ¾ÊÀ¸¸ç,
¼ÕÇØ ¹ß»ý½Ã¿¡µµ Ã¥ÀÓÁöÁö ¾Ê½À´Ï´Ù.

¸ðµç ¼Ò½º´Â º¯°æ°ú ¼öÁ¤ÀÌ °¡´ÉÇÕ´Ï´Ù¸¸ °Ô½ÃÆÇ ÇÏ´ÜÀÇ ÀúÀÛ±Ç Ç¥½Ã´Â ¹Ýµå½Ã Çؾß
ÇÕ´Ï´Ù.

¼Ò½ºÀÇ º¯°æ, ¼öÁ¤, ¼³Ä¡, ¿î¿ë Áß ¹ß»ýÇÏ´Â ¸ðµç ¹®Á¦¿Í ¼ÕÇØ ¹ß»ý½Ã
¼Ò½ºÀÇ ¹èÆ÷ÀÚÀÎ º»ÀÎÀº Ã¥ÀÓÁöÁö ¾Ê½À´Ï´Ù.
*/

¡á¡á°³¿ä:
Oracle8i, O``reilly MultiPartRequest, DBConnectionManager ¸¦ ÀÌ¿ëÇÑ ´äº¯Çü ÀÚ·á°Ô½ÃÆÇÀÔ´Ï´Ù.

¡á¡á¼³Ä¡¹ý
Tomcat, resin ÀÇ °æ¿ì
okbbs.war ¸¦ webapps µð·ºÅ丮¿¡ À§Ä¡ÇÑ ´ÙÀ½ JSP ÄÁÅ×À̳ʸ¦ Àç½Ãµ¿ÇÏ¸é ¾ÐÃàÀÌ Ç®¸³´Ï´Ù.
±âŸ¼­¹öÀÇ °æ¿ì
jar xvf okbbs.war ·Î ¾ÐÃàÀ» Ç®¾î¼­ ÄÁÅؽºÆ® ROOT ¾Æ·¡ /okboard , /WEB-INF , /upload Æú´õ¸¦ º¹»çÇÕ´Ï´Ù.
okbbs.zip À¸·Î À̸§À» ¹Ù²ã¼­ winzip À¸·Î ¾ÐÃàÀ» Ç® ¼ö ÀÖ½À´Ï´Ù.

3°³ÀÇ ÆÄÀÏ°ú bean ÀÇ °ªÀ» º¯°æÇÏ°í ÀçÄÄÆÄÀÏÇÑ ÈÄ¿¡ ¼­¹ö¸¦ Àç½Ãµ¿ÇÕ´Ï´Ù.
WEB-INF/web.xml ; table ¸í°ú dbÀÇ JDBC¿¬°áÀ̸§, °ü¸®ÀÚ Æнº¿öµå
okboard/boardcfg.jsp ; ºÎ¼Ó table ¸í°ú skin ÀÇ Á¾·ù
WEB-INF/classes/db.properties ; jdbc Connection Pool ¿¬°áÁ¤º¸
Bean º¯°æ
NewArticles.java ¿Í BoardManager.java ÀÇ table¸í°ú JDBC¿¬°áÀ̸§À» º¯°æÇÕ´Ï´Ù.

Bean ÀÇ ÄÄÆÄÀÏ ¹æ¹ý
TomcatÀÇ lib (¶Ç´Â common/lib) ¿¡ ÀÖ´Â servlet.jar ÆÄÀÏÀ» jdk/jre/lib/ext ¿¡ º¹»çÇÕ´Ï´Ù.
ResinÀÇ °æ¿ì lib¿¡ ÀÖ´Â jsdk22.jar(¶Ç´Â jsdk23.jar) ÆÄÀÏÀ» À§ÀÇ À§Ä¡¿¡ º¹»çÇÕ´Ï´Ù.
WEB-INF/classes µð·ºÅ丮¿¡¼­

javac -encoding 8859_1 -classpath ./ -d ./ *.java ok/*.java

À¸·Î ÄÄÆÄÀÏÇÕ´Ï´Ù.

¡á¡á½ÇÇà¹ý
¼³Ä¡ ¿Ï·á ÈÄ tomcatÀ» ±¸µ¿½ÃŲ ÈÄ
ºê¶ó¿ìÀú¿¡¼­ http://localhost:8080/okbbs/okboard/board_create.jsp ¸¦ ¿äûÇÕ´Ï´Ù.
web.xml¿¡¼­ Á¤ÇÑ table°ú °ü·ÃµÈ table°ú index, sequence, trigger, procedure µéÀÌ ¸¸µé¾î Áö¸é µË´Ï´Ù.

¡á¡áº¸¾È
oracleÀÇ µ¥ÀÌÅͺ£À̽ºÀÇ Å×½ºÆ® Á¢±Ù±ÇÇÑÀ¸·Î µÇ¾îÀÖ½À´Ï´Ù. (scott, tiger)
º¯°æÀ» ¿øÇϽøé db.properties ÆÄÀϸ¸ ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
°Ô½ÃÆÇ°ü¸®ÀÚ Æнº¿öµå º¯°æÀº web.xml ÆÄÀÏ¿¡¼­ ÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.

¡á¡áÁÖÀÇ
½Ç¹«º¸´Ù´Â Å×½ºÆ®/ÇнÀ¿ë °Ô½ÃÆÇÀ̹ǷΠ¼Ò½º¿¡ ´ëÇØ Á¤È®È÷ ÀÌÇØÇÏ°í »ç¿ëÇϱ⠹ٶø´Ï´Ù.
Tomcat 4 ¿¡¼­ Å×½ºÆ®µÇ¾ú°í, ´Ù¸¥ ȯ°æ¿¡¼­´Â ¿¡·¯°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.

¡á¡á History
0.97- 2002-01-15 5:05¿ÀÀü
°Ô½ÃÆÇ »ý¼º °ü¸® ÆäÀÌÁö Ãß°¡
- okadm/ boardlist.jsp, boardlist_edit.jsp, boardlist_edit2.jsp, Board.java, BoardManager.java
°Ô½ÃÆÇ À̵¿ Combo box Ãß°¡
- top.jsp
DownloadServlet ¹ö±×·Î ÀÎÇØ download.jsp ·Î ´Ù½Ã ´ëÄ¡


0.96- 2001-12-05 4:01¿ÀÀü
ÀÇ°ß(¸Þ¸ð)´Þ±â ±â´É Ãß°¡
- board_memo.jsp, board_memo2.jsp, oracle ÀÇ trigger »ç¿ë
- °ü¸®ÀÚ¸¸ »èÁ¦ °¡´É
´Ù¿î·Îµå½Ã servlet ÀÌ¿ë
- DownloadServlet.class
servlet mapping »ç¿ë /servlet/DownloadServlet À» /servlet/down À¸·Î »ç¿ë
- web.xml ¿¡¼­ ÁöÁ¤
web.xml ¿¡¼­ table ¸í ÁöÁ¤
- º¯°æ ÈÄ Àç½Ãµ¿ÇØ¾ß Àû¿ëµÊ
DBHandler, DBCollectionManager ¸¦ ºÎºÐÀûÀ¸·Î Àû¿ë.
- Pool »ç¿ëÀ¸·Î °Ô½ÃÆÇ ¼Óµµ Çâ»ó
okboard.js, okboard.css ³»¿ëÃß°¡

0.95- 2001-11-23 3:14¿ÀÈÄ
board_insert.jsp
board_modify.jsp
board_reply.jsp
board_insert2.jsp
board_modify2.jsp
board_reply2.jsp
¸¦
board_write.jsp
board_write2.jsp
·Î ÅëÇÕ
skin Ãß°¡ Áß boardcfg.jsp ¿¡¼­ skin1 °ú skin2 ¼±Åà ÈÄ¿¡ ¼­¹ö Àç½Ãµ¿.
cropByte ¸Þ¼Òµå Ãß°¡ (byte ´ÜÀ§·Î substring ±â´É¼öÇà)

0.94- 2001-11-10 11:14¿ÀÈÄ
½Ã°£¼ø, ´äº¯¼ø ±â´É Ãß°¡.
CREATE INDEX IDX_KBOARD2 ON KBOARD (SEQ)
°Ô½ÃÆÇ À̵¿ ±â´É Ãß°¡ (oracle ÀÇ procedure ÀÌ¿ë)
: °Ô½ÃÆÇ¿¡ °Ô½Ã¹° 2°³ ÀÌ»óÀÏ °æ¿ì À̵¿ °¡´É
´äº¯½Ã ´äÀå ¼Û½Å ±â´É Ãß°¡. (OkMailBean.java, board_reply2.jsp)
admin logout ±â´É Ãß°¡
skin ±â´É Ãß°¡ ÁßÀÔ´Ï´Ù.
³»¿ë°Ë»ö½Ã Á¤¿­ ¾ÈµÇ´Â ¹ö±× ¼öÁ¤
±Û ¾´ ÈÄ ¸ñ·ÏÀÌ refresh ¾È µÇ´Â ¹ö±× ÇØ°á
(fake ÆĶó¸ÞÅ͸¦ ÀÌ¿ëÇØ ÁÖ¼ÒÁÙ¿¡ ½Ã°£ Ãß°¡ ÈÄ
ºê¶ó¿ìÀúÀÇ ¸ÛûÇÑ Á¡ ÀÌ¿ë »õ·Î ÆäÀÌÁö ·ÎµùÇÏ°Ô ÇÔ)


0.93- 2001-10-17 6:59¿ÀÈÄ
main.jsp ¿Í sublist.jsp ¿Í bean À» ÅëÇÑ »õ·Î¿î °Ô½Ã¹° ¸®½ºÆ® Ãß°¡
DBConnectionManager POOL »ç¿ëÇÏ¿© ¼ÓµµÇâ»ó-ÇöÀç bean ¿¡¸¸ »ç¿ë
Admin ·Î±×ÀÎ ÈÄ »èÁ¦°úÁ¤ ´ÜÃà
ȨÆäÀÌÁö Ç¥½Ã.
¹Ì¸®º¸±â â ±æÀÌ Ãà¼Ò.
Áö³­ ¾È³».txt ¼öÁ¤
CREATE INDEX IDX_KBOARD ON KBOARD (REF, STEP DESC)


0.92- 2001-10-04 4:05¿ÀÀü
index »ç¿ëÀ¸·Î Oracle ÇÏÀ§¹öÀü(8i ¹Ì¸¸)ÀÇ inline view ¿¡¼­
order by »ç¿ëÇÏÁö ¾Ê°íµµ ¼ø¼­´ë·Î Äõ¸®°¡´É
Oreilly ÀÇ MultipartRequest ·Î jspSmartUpload ´ëü
(¹®Á¦¹ß»ý windows2k ¿¡¼­´Â ÇѱÛÆÄÀϸí Áö¿øÇÏÁö ¾ÊÀ½, Unix/Linux ¿¡¼­´Â ¾çÈ£)
°Ô½ÃÆÇ ¸ñ·Ï Á¦¾î °¡´É - boardcfg.jsp ÀÇ constraint
¹Ì¸®º¸±â ±â´ÉÃß°¡
Á¦¸ñ±æÀÌ Á¶ÀýÇÏ´Â ¸Þ¼Òµå Ãß°¡ Fn.java ÀÇ crop()
Çʵå Ãß°¡- homepage, html, preview
jdbc µå¶óÀ̹ö À§Ä¡ ³»Àå - WEB-INF/lib µð·ºÅ丮
ºê¶ó¿ìÀú ¹öÀüº° ´Ù¿î·Îµå Çì´õ ±¸ºÐ - download.jsp


0.91- 2001-07-28 1:26¿ÀÀü
reply Á¦¸ñÁÙÀÇ e°¡ »ç¶óÁö´Â ¹ö±× ¼öÁ¤
Æнº¿öµå¾ø´Â ±Û °ü¸®ÀÚ »èÁ¦°¡´ÉÅä·Ï ¼öÁ¤


0.9- 2001-07-26 4:51¿ÀÀü
°ü¸®ÀÚ »èÁ¦ ±â´É Ãß°¡ - ÀÎÁõ¸¸ °ÅÄ¡¸é »èÁ¦½Ã Æнº¿öµå ºÒ¹® (session »ç¿ë)
top.jsp ¿Í bottom.jsp ¸¦ ÅëÇÑ ´ÙÁß°Ô½ÃÆÇ Ä¿½ºÅ͸¶ÀÌ¡ °¡´É
okboard.css ÀÇ ok-1 ½ºÅ¸ÀÏÀ» ÅëÇØ Å¸ÀÌƲ ¹è°æ»ö ÁöÁ¤°¡´É
ÆäÀÌÁö ¸µÅ©¿¡¼­ ÆĶó¸ÞÅÍ ÃÖÀûÈ­
°Ô½ÃÆÇ html ÄÚµå º¸À̱â


0.81- 2001-07-24 2:14¿ÀÀü
³»¿ë °Ë»ö ¹ö±× ¼öÁ¤


0.8- 2001-07-13 6:19¿ÀÀü
DB Schema ¿¡ SEQ (ÀϷùøÈ£) Ãß°¡ ¹× È¿À²È­
ÇÑ±Û °Ë»ö ÆäÀÌÁö ³Ñ¾î°¡¸é ¾ÈµÇ´Â ¹ö±× ¼öÁ¤
list ¿¡¼­ tag Àå³­¹æÁö
´çÀÏ °Ô½Ã¹°Àº ½Ã°£À¸·Î ¸ñ·Ï¿¡ Ç¥½Ã
3ÀÏ À̳» °Ô½Ã¹° ±¸ºÐÇ¥½Ã
ÆäÀÌÁö±×·ì À̵¿ ½Ã ´ÙÀ½ÆäÀÌÁöÀÇ Ã³À½°ú ³¡ °Ô½Ã¹°·Î À̵¿
download ½Ã ½ºÆ®¸² È®½ÇÈ÷ ²÷¾îÁÖ±â
±Û¾²±â, ¼öÁ¤, ´äº¯ ½Ã Ãë¼Ò¹öÆ° Ãß°¡
main.jsp, Article.java, ArticleLists.java - bean test ÆÄÀÏ, bug ¸¹À½


0.7- 2001-05-28 2:28¿ÀÀü
°Ô½Ã¹° º¸±â¿¡¼­ °ü·Ã±Û ¸®½ºÆ® Ãâ·Â
°Ô½Ã¹° º¸±â¿¡¼­ ÀÌÀü, ´ÙÀ½±Û ¸µÅ© Ãß°¡
DB Connection Áß »ç¿ëÇÑ Statement ¶û PreparedStatement ²÷¾îÁÖ±â
°Ô½Ã¹° ¸ñ·Ï¿¡¼­ Á¦¸ñ±æÀÌ 30ÀÚ Á¦ÇÑ
¸®½ºÆ®¿¡¼­ ÇöÀç ÆäÀÌÁö ±½°Ô Ç¥½Ã


0.62 - 2001-05-24 11:26¿ÀÈÄ
°Ë»öÈÄ ¸®½ºÆ® ¹ö±× ¼öÁ¤
ÃÖ±Ù 3ÀÏ °Ô½Ã¹° Ç¥½Ã
Timestamp¿Í SimpleDateFormatÀ» ÀÌ¿ëÇÑ ³¯Â¥Ç¥½Ã


0.61 - 2001-05-23 6:33¿ÀÀü
¸®½ºÆ® ¹ö±× ¼öÁ¤


0.6 - 2001-05-21 1:58¿ÀÀü
°Ô½ÃÆÇ Á¦¸ñ, À̸§, ³»¿ë °Ë»ö Ãß°¡
select Ç׸ñ ÁöÁ¤ÇÏ´Â javascript Ãß°¡


0.5 - 2001-05-20 1:11¿ÀÀü
¼öÁ¤±â´É Ãß°¡
Cookie·Î ÀԷ½Żó ÀúÀå


0.4 - 2001-05-18 10:56¿ÀÀü
´äº¯±â´É Ãß°¡
Fn.java ¹ö±× ¼öÁ¤


0.3 - 2001-05-17 5:57¿ÀÈÄ
¿À¶óŬÀÇ 4000¹ÙÀÌÆ® Á¦ÇÑÀ» Ç®¾ú½À´Ï´Ù.
´Ù¿î·Îµå ¹æ½ÄÀ» ¹Ù²Ù¾ú½À´Ï´Ù.
ÇѱÛÁ¦¸ñÆÄÀÏ, À̹ÌÁö ´Ù¿î·Îµå½Ã ÀÌ»ó¾ø½À´Ï´Ù.
°Ô½Ã¹° ÀÛ¼º ÈÄ refresh µÇµµ·Ï Çß½À´Ï´Ù.
email ¸µÅ©·Î º¯°æÇß½À´Ï´Ù.
doc, xls, ppt, gif, img ¸ðµÎ ´Ù¿î·Îµå â ¶å´Ï´Ù.
jsp ÄÚµå ¿Ã·Áµµ ½ÇÇàµÇÁö ¾Ê½À´Ï´Ù.

Àü½Å
kboard ¸¦ ¿À¶óŬ¿ëÀ¸·Î ÀüȯÇÕ´Ï´Ù.

¡á¡áÇöÀç°³¹ßȯ°æ
tomcat 4.0.1
Oracle 8.1.6, 8.1.7
Solaris 2.7, Windows XP
jdk 1.3.1

¡á¡áÆÄÀÏÀ§Ä¡
/ <-- Context Root
/index.html
/okboard/admin.jsp <-- °Ô½ÃÆÇ °ü¸®ÀÚ ÀÎÁõó¸®
/okboard/top.jsp <-- ÆäÀÌÁö »ó´Ü ó¸®
/okboard/bottom.jsp <-- °Ô½ÃÆÇ ÇÏ´Ü Ã³¸®
/okboard/boardcfg.jsp <-- °Ô½ÃÆÇ Å×À̺í¸í ȯ°æ¼³Á¤/ °ü¸®ÀÚ ºñ¹Ð¹øÈ£
/okboard/board_create.jsp <-- °Ô½ÃÆÇ »ý¼º Çѹø½ÇÇà ÈÄ ÆÄÀÏ¸í ¹Ù²Ù½Ã°Å³ª »èÁ¦Çϼ¼¿ä.
/okboard/board.jsp <-- °Ô½Ã¹°¸®½ºÆ®
/okboard/board_write.jsp <-- ÀÚ·á ÀÔ·Â/¼öÁ¤/´äº¯ Æû
/okboard/board_write2.jsp <-- ÀÚ·á ÀÔ·Â/¼öÁ¤/´äº¯ ó¸®
/okboard/board_memo.jsp <-- ÀÇ°ß/ÀÇ°ß ÀÔ·ÂÄ­ º¸À̱â
/okboard/board_memo2.jsp <-- ÀÇ°ß ÀÔ·Â/»èÁ¦ ó¸®
/okboard/board_move.jsp <-- °Ô½Ã¹° À̵¿ ó¸®
/okboard/passchk.jsp <-- ¼öÁ¤±ÇÇÑ ¾ÏÈ£ ÀÔ·Â
/okboard/go.jsp <-- back ¹æÁö¿ë Áß°èó¸®
/okboard/delete.jsp <-- »èÁ¦±ÇÇÑ ¾ÏÈ£ ÀÔ·Â
/okboard/delete2.jsp <-- »èÁ¦Ã³¸®
/okboard/path.jsp <-- jvmÀÇ classpath, context path È®ÀÎ
/okboard/okboard.css <-- ÆäÀÌÁö CSS
/okboard/okboard.js <-- javascript
/okboard/main.jsp <-- ÃֽŰԽù° ¸®½ºÆ®¾÷ - beta
/okboard/sublist.jsp <-- ÃֽŰԽù° ¸®½ºÆ®¾÷ ÄÄÆ÷³ÍÆ® - beta
/okboard/error.jsp <-- ¿¡·¯Ã³¸®

/okboard/images/ <-- ±×¸²ÆÄÀÏ µð·ºÅ丮
/okboard/images/skin1 <-- skin1 µð·ºÅ丮
/okboard/images/skin2 <-- skin2 µð·ºÅ丮

/okadm/boardlist.jsp <-- »ý¼ºµÈ °Ô½ÃÆÇ ¸ñ·Ï
/okadm/boardlist_edit.jsp <-- °Ô½ÃÆÇ »ý¼º/¼öÁ¤/»èÁ¦ Æû
/okadm/boardlist_edit2.jsp <-- °Ô½ÃÆÇ »ý¼º/¼öÁ¤/»èÁ¦ ó¸®

/WEB-INF/web.xml <-- web application deploy descriptor table¸í, °ü¸®ÀÚ ºñ¹ø...
/WEB-INF/lib/cosi.jar <-- O``reilly servlet ÄÄÆ÷³ÍÆ®
/WEB-INF/lib/classes12_1.jar <-- Oracle jdbc µå¶óÀ̹ö
/WEB-INF/classes/DBConnectionManager.* <-- DBConnection Pool Manager
/WEB-INF/classes/db.properties <-- DBConnection Pool Manager ¿ë jdbc Á¤º¸
/WEB-INF/classes/DBHandler.* <-- DB Çڵ鷯
/WEB-INF/classes/ok/ <-- ÇѱÛó¸®, ¹®ÀÚ¿­´ëÄ¡, ÄíŰó¸® ºó
/WEB-INF/classes/ok/Article.* <-- °Ô½ÃÆÇ ÇÊµå ¿£ÅÍƼ ºó
/WEB-INF/classes/ok/NewArticles.* <-- ÃֽŰԽù° ºó
/WEB-INF/classes/ok/Board.* <-- °Ô½ÃÆÇ ¸ñ·Ï ¿£ÅÍƼ ºó
/WEB-INF/classes/ok/BoardManager.* <-- °Ô½ÃÆÇ ¸ñ·Ï ó¸® ºó
/WEB-INF/classes/ok/OkMailBean.* <-- ¸ÞÀÏ¹ß¼Û ºó
/WEB-INF/classes/ok/DownloadServlet.* <-- ´Ù¿î·Îµå ó¸® ¼­ºí¸´

/upload/ <-- ÆÄÀÏÀÌ ¾÷·ÎµåµÇ´Â µð·ºÅ丮

¡á¡átable ±¸¼º (zkboard, zkboard_cnts, zkboard_memo, zkboard_list)

CREATE TABLE zkboard (
BBSID VARCHAR2 (10) NOT NULL,
SEQ NUMBER NOT NULL,
REF NUMBER NOT NULL,
STEP NUMBER DEFAULT 0 NOT NULL,
LEV NUMBER DEFAULT 0 NOT NULL,
WRITER VARCHAR2 (50) NOT NULL,
SUBJECT VARCHAR2 (500) NOT NULL,
PREVIEW VARCHAR2 (500),
PASSWORD VARCHAR2 (8),
EMAIL VARCHAR2 (50),
READ NUMBER DEFAULT 0 NOT NULL,
FILENAME VARCHAR2 (200),
MASKNAME VARCHAR2 (20),
FILESIZE NUMBER DEFAULT 0,
DOWNLOAD NUMBER DEFAULT 0,
HTML CHAR (1),
HOMEPAGE VARCHAR2 (200),
STS CHAR (1) DEFAULT ``1``,
WHEN DATE,
IP VARCHAR2 (24))

CREATE TABLE zkboard_cnts (
BBSID VARCHAR2 (10) NOT NULL,
SEQ NUMBER NOT NULL,
CONTENT VARCHAR2 (4000),
CID NUMBER DEFAULT 0 NOT NULL) ;

CREATE TABLE zkboard_memo (
MSEQ NUMBER NOT NULL,
BBSID VARCHAR2 (10) NOT NULL,
SEQ NUMBER NOT NULL,
WRITER VARCHAR2 (50),
BCOMMENT VARCHAR2 (2000),
WTIME DATE DEFAULT SYSDATE)

CREATE TABLE ZKBOARD_LIST (
BBSSEQ NUMBER DEFAULT 0 NOT NULL,
BBSID VARCHAR2 (10) NOT NULL,
BBSNAME VARCHAR2 (100),
BBSCOMMENT VARCHAR2 (2000),
BBSAUTH CHAR (3) DEFAULT ``111``,
BBSTYPE CHAR (1) DEFAULT ``0``,
UNIQUE (BBSID),
CONSTRAINT PK_ZKBOARD_LIST
PRIMARY KEY ( BBSID )
USING INDEX )

-- index
CREATE INDEX IDX_zkboard ON zkboard (REF, STEP DESC)
CREATE INDEX IDX_zkboard2 ON zkboard (SEQ)
CREATE INDEX IDX_zkboard_memo ON zkboard_memo(SEQ)

-- sequence
CREATE SEQUENCE SEQ_zkboard_LIST START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 99999999 NOCACHE NOCYCLE NOORDER
CREATE SEQUENCE SEQ_zkboard_MEMO START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999999999 CACHE 20 NOCYCLE NOORDER


-- procedure
CREATE OR REPLACE PROCEDURE PROC_kboard_MOVE
(MSEQ IN NUMBER, TBBS IN VARCHAR2)
IS
NEWREF NUMBER;
BEGIN
SELECT NVL(MAX(REF),0)+1 INTO NEWREF
FROM kboard WHERE BBSID = TBBS;

UPDATE kboard SET BBSID = TBBS, REF = NEWREF
WHERE SEQ = MSEQ;
UPDATE kboard_cnts SET BBSID = TBBS
WHERE SEQ = MSEQ;
END;

-- trigger
CREATE OR REPLACE TRIGGER TRI_kboard_memo_DELETE
AFTER DELETE ON kboard_memo
REFERENCING
NEW AS NEW
OLD AS OLD
FOR EACH ROW
BEGIN
UPDATE kboard
SET MEMO = MEMO - 1
WHERE SEQ = :OLD.SEQ;
End;

CREATE OR REPLACE TRIGGER TRI_kboard_memo_INSERT
AFTER INSERT ON kboard_memo
REFERENCING
NEW AS NEW
OLD AS OLD
FOR EACH ROW
BEGIN
UPDATE kboard
SET MEMO = MEMO + 1
WHERE BBSID = :NEW.BBSID
AND SEQ = :NEW.SEQ;
End;

¡á¡áknown bug:
¹®Á¦¹ß»ý windows2k ¿¡¼­´Â ÇѱÛÆÄÀϸí upload Áö¿øÇÏÁö ¾ÊÀ½, Unix/Linux ¿¡¼­´Â ¾çÈ£

ÇØ°áÇϽŠºÐ ¿¬¶ôÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.

IE 6 ¿¡¼­´Â ºê¶ó¿ìÀú°¡ °©ÀÚ±â Á¾·áÇÒ ¼ö ÀÖ½À´Ï´Ù. CSS ¹®Á¦·Î ÀÎÇÑ °Í °°À¸¸ç,
Â÷ÈÄ¿¡ ÇØ°áÇϵµ·Ï ÇÒ °ÍÀÔ´Ï´Ù.

³×ƼÁð ÀÇ°ß   ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.)
³»¿ë ¾ÆÀ̵ð ÀÇ°ß³²±â±â
µî·ÏµÈ ÀÇ°ßÀÌ ¾ø½À´Ï´Ù.
1
À̸§
³»¿ë
:³×¸Â¾Æ¿ä: :È­³ª´Â±º¿ä: :Àá¿Í: :¿ì¿ïÇØ: :À̰ǾƳÄ: :¿ÕÇÏÇÏ: ¿Õ¿ôÀ½~ ³î·¥~
Æò°¡Çϱâ ÈǸ¢ÇÔ ¸Å¿ìÁÁÀ½ ÁÁÀ½ ±¦ÂúÀ½ º¸Åë º°·Î
µµ¹è¹æÁöÅ°
 43778085 º¸ÀÌ´Â µµ¹è¹æÁöÅ°¸¦ ÀÔ·ÂÇϼ¼¿ä.