Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
css
mysql
html
jquery
������
image
slide
API
mobile
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í
[oracle8i] okboard 0.95 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ ¼Ò½º
¼Ò½ººÐ·ù
°Ô½ÃÆÇ
´Ù¿î·Îµå Ƚ¼ö
1597 ȸ
°£´Ü¼³¸í
okboard 0.95 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ
/*
[oracle8i] okboard 0.95 ´äº¯ÇüÀÚ·á°Ô½ÃÆÇ ¼Ò½º
ÀÛ¼ºÀÚ : kenu@okjsp.pe.kr
¹èÆ÷ó : http://www.okjsp.pe.kr
ÀÛ¼ºÀÏ : 2001-11-23 3:13¿ÀÈÄ
Å×½ºÆ® : http://okjsp.pe.kr/ Q&A °Ô½ÃÆÇ
*/
Oracle8i, O``reilly MultiPartRequest ¸¦ ÀÌ¿ëÇÑ ´äº¯Çü ÀÚ·á°Ô½ÃÆÇÀÔ´Ï´Ù.
known bug:
¹®Á¦¹ß»ý windows2k ¿¡¼´Â ÇѱÛÆÄÀϸí upload Áö¿øÇÏÁö ¾ÊÀ½, Unix/Linux ¿¡¼´Â ¾çÈ£
ÇØ°áÇϽŠºÐ ¿¬¶ôÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.
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
Oracle 8.1.5,8.1.7
ÆÄÀÏÀ§Ä¡
/ <-- 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/passchk.jsp <-- ¼öÁ¤±ÇÇÑ ¾ÏÈ£ ÀÔ·Â
/okboard/db.jsp <-- jdbc Á¤º¸ÆÄÀÏ
/okboard/go.jsp <-- back ¹æÁö¿ë Áß°èó¸®
/okboard/delete.jsp <-- »èÁ¦±ÇÇÑ ¾ÏÈ£ ÀÔ·Â
/okboard/delete2.jsp <-- »èÁ¦Ã³¸®
/okboard/path.jsp <-- jvmÀÇ classpath È®ÀÎ
/okboard/download.jsp <-- ´Ù¿î·Îµå ó¸®
/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 µð·ºÅ丮
/WEB-INF/lib/cosi.jar <-- O``reilly servlet ÄÄÆ÷³ÍÆ®
/WEB-INF/lib/classes12_1.jar <-- Oracle jdbc µå¶óÀ̹ö
/WEB-INF/classes/ok/ <-- ÇѱÛó¸®, ¹®ÀÚ¿´ëÄ¡, ÄíŰó¸® ºó
/WEB-INF/classes/ok/Article.* <-- °Ô½ÃÆÇ ÇÊµå ¿£ÅÍƼ ºó
/WEB-INF/classes/ok/NewArticles.* <-- ÃֽŰԽù° ºó
/upload/ <-- ÆÄÀÏÀÌ ¾÷·ÎµåµÇ´Â µð·ºÅ丮
¼³Ä¡¹ý
Tomcat, resin ÀÇ °æ¿ì
okbbs.war ¸¦ webapps µð·ºÅ丮¿¡ À§Ä¡ÇÑ ´ÙÀ½ JSP ÄÁÅ×À̳ʸ¦ Àç½Ãµ¿ÇÏ¸é ¾ÐÃàÀÌ Ç®¸³´Ï´Ù.
±âŸ¼¹öÀÇ °æ¿ì
jar xvf okbbs.war ·Î ¾ÐÃàÀ» Ç®¾î¼ ÄÁÅؽºÆ® ROOT ¾Æ·¡ /okboard , /WEB-INF , /upload Æú´õ¸¦ º¹»çÇÕ´Ï´Ù.
okbbs.zip À¸·Î À̸§À» ¹Ù²ã¼ winzip À¸·Î ¾ÐÃàÀ» Ç® ¼ö ÀÖ½À´Ï´Ù.
½ÇÇà¹ý
boardcfg.jsp ¿Í db.jsp ¸¦ ÀûÀýÇÏ°Ô º¯°æ,ÀúÀåÇÕ´Ï´Ù.
¼³Ä¡ ¿Ï·á ÈÄ tomcatÀ» ±¸µ¿½ÃŲ ÈÄ
ºê¶ó¿ìÀú¿¡¼ http://localhost:8080/okbbs/okboard/board_create.jsp ¸¦ ¿äûÇÕ´Ï´Ù.
kboard ¶ó´Â table ÀÌ ¸¸µé¾î Áö¸é µË´Ï´Ù.
º¸¾È
oracleÀÇ µ¥ÀÌÅͺ£À̽ºÀÇ ±âº» Á¢±Ù±ÇÇÑÀ¸·Î µÇ¾îÀÖ½À´Ï´Ù. (scott, tiger)
º¯°æÀ» ¿øÇϽøé db.jsp ÆÄÀϸ¸ ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
°Ô½ÃÆÇ°ü¸®ÀÚ Æнº¿öµå º¯°æÀº boardcfg.jsp ÆÄÀÏ¿¡¼ ÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
ÁÖÀÇ
bean ÄÄÆÄÀÏ ½Ã
C: omcat4webappsokbbsWEB-INFclassesok>javac -classpath ../ -d ../ -encoding 8859_1 *.java
ó·³ ÇØÁÖ½Ã¸é µË´Ï´Ù.
table ±¸¼º (kboard, kboard_cnts)
CREATE TABLE kboard (
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))
-- index
CREATE INDEX IDX_KBOARD ON KBOARD (REF, STEP DESC)
CREATE INDEX IDX_KBOARD2 ON KBOARD (SEQ)
CREATE TABLE KBOARD_CNTS (
BBSID VARCHAR2 (10) NOT NULL,
SEQ NUMBER NOT NULL,
CONTENT VARCHAR2 (4000),
CID NUMBER DEFAULT 0 NOT NULL) ;
-- 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;
Áú¹®Àº http://okjsp.pe.kr »çÀÌÆ®ÀÇ °Ô½ÃÆÇ¿¡ ¿Ã·ÁÁֽñ⠹ٶø´Ï´Ù.
³×ƼÁð ÀÇ°ß ÀÌ¿ëÇϽŠÀÚ·áÀÇ Èı⸦ ÀÚÀ¯·Ó°Ô ÀÛ¼ºÇϼ¼¿ä. (»ó¾÷ÀûÀÎ ±¤°í ¹× µµ¹è¼º ±Û µîÀº »çÀüÅ뺸¾øÀÌ »èÁ¦µÉ ¼ö ÀÖ½À´Ï´Ù.)