Xây dựng website diễn đàn

Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (836.38 KB, 33 trang )

Ñeà taøi:


 
!"#$%

&'()*++,-./01
234)5)6-&7#87
 4()3,)&,7,#9( :;
 4()04&++#9-,#<=
 2027>+?7,#87@#8;.7(*+,#9
AB/=
4()C27>++()7B%=
4()D,#87@#8+()7B%=
4()E(*+,#9+()7B%=
4()FG#87-9'&,&@#87<6=


234)5)6-&7#87=
4()3,)&,7,#9( :;
H:;-./97( '()*+7,#87@#8+
/*+'>+'#
H()*+I,#JK+7</&6:;
L,B7-+,#M
H( ,8(4N4OO(+&+
-917B%7%@&+=

4()04&++#9-,#<
,7B().-./;,#9++6+()7B%I
/

• P#I5#B;#B:C=3
• :G3=C
• 4)5)6J( -,#9!Q"0RRR=
• 4S@#878,:$4TU$4=


:;11-,+7,?
11-#7?!#B;-#7
:;11-,+7,?
11-#7?!#B;-#7
JDBC Driver
JDBC Driver
ODBC
ODBC
Database driver
Database driver
4)5)6J( -,#9
L++#55?!Q"
!#B;#B?UB+-#?
VM
 :;
 'W+7.

!)'@&,<&7+()7B%-./;,#9++ (
+&+7B'S,4!"+6().,5(6J*;)&,4!"














 !"
#$%&'"()"

( -917B%:;!#B;#B2#5L:!2M
:!2+&/97587>+875
H ".( -917B%P#I1>/&+6=
H 4#9:!2-.+#9:;J(*7B#
#:0'#SXJ(*( 9,J7BP#I
'9("?"?";."=
HG6&/ :;,( +&+7#6'K
J*"=

4)+#8*7'9+6:!2
4)+#8*7'9+67B:!2'()*+/,*(
5
P#I$BY5#B
#+
G#87587
B%J,#Z
JK+:!2
!#B;-#7
7*/

HTTP Service
Trang JSP

4&1&1+)I6+6:!2
[\\]
4&+'*/ -#9:;)6,( 
+W17#67()7(*/97+()7B%
:;77().=
[\^\]
 ()*+J.'#S,#S7K@#87X87
+6/97,&7BKI,#8./.'&=
[\_\]
G,I&/97I,#87.+*+J.
+7.7B:!2=


[\`,+-J#a,-#\]
&/977B=b51
7B=7/-
[\`1#\]
G,I&+&+7(;,#9,/1B7
+6 b;
[b51aBYBJ]
4#S ()& 7B P#I
5'K+c@&+=


2027>+7,#87@#8
;.7(*+,#9AB/
4()C27>++()7B%

Là thiết kế và xây dựng một Forum bao gồm các
chức năng sau :
- (6,I.,-#J,#Z'.=
- #/I.,' (6,7#+&++6'#@&+=
- B6-).,I.,' '()*+(6,=
- %/@,#8//97I.,=
- @&7B)67.7.;,#+6aB/=
- 'S,77,7.;,#=

- #/().,J.=
- &().,J.=
- 49197().,J.
- #/'#/*+J,#Z'.=
- &'#/*+J,#Z'.=
- 49197'#/*+J,#Z'.=
- #/+6'#=
- &+6'#=
- 49197+6'#=

Phân cấp người sử dụng.
a)Người sử dụng bình thường
().,@+'@&+&7#S7/,;.J,#Z
'.;.+&@65
- #/9,J/97I.,=
- %/@,#8//97I.,7#7&+,6?9,J?+6'#
b) Người sử dụng có đăng ký
G,().,5(6J*' '@&7.;,#7%.,0
@67B#7%+&7#S157I.,?16,-*,?7'S,
( 77,+&=

c) Ngöôøi quaûn lyù
8,;)&,().,<6-&.,( @6
7B#+.+&7#S
- #/().,J.=
- &().,J.=
- 49197().,J.
- #/'#/*+J,#Z'.=
- &'#/*+J,#Z'.=
- 49197'#/*+J,#Z'.=
- #/+6'#=
- &+6'#=
- 49197+6'#=

4()D,#87@#8+()7B%

UI
Database
User Interface
B'#7.,.5(*7()7&+'()*+7#S,#9<
@8,(%5

3=d
0=$!
G8,7I5#-.@8,J( -,#9+6AB/=
4&D77,+-(,( 
e CATEGORYFORUM ( löu tröõ ñeà muïc
Forum )
fg'7-(,( 07.1-.
- 47#BAB/L/ +6+7#BaB/M

- 47#B/#L7#+6+7#BaB/M=

FORUM (löu tröõ caùc Forum )
-(7B( +&+7.15
- AB/L/ +6AB/M-./@&+>=
- 47#BAB/L/ +6+7#BaB/M
-./@&*,=
- AB//#L7#+6AB/M
-
#5+B,17,L7B().J,#Z,6,M

POST (lửu trửừ caực baứi gửỷi leõn)
-(,( +&+7.15
H257L/ +&+I.,M-./@&+>
- AB/L/ AB/M@&*,
- 2572B#7L/ I.,+M@&*,=
- d5#B/#L7#7&+,6M
- !Ib#+7L+6'#(6,M
- #55#L9,J(6,M=
- 2577#L.,).(6,M=

MEMBER(löu tröõ danh saùch thaønh vieân)
-(7B( +&+7.15
- d5#B/#L7#().,5(6J*M-./@&
+>=
- 255YBJL/97@SM
- A /#L7#''6M
- /,-L'K+c#/,-M

Q#9+6D77,.'()*+7#S,#9(5

Xaây döïng caùc table
Table1 :CATEGORYFORUM

int 4

CategoryForumID(k)
CategoryName nvarchar 100

Data Type
Length
Null
Column Name

Table2:FORUM

ForumID(k) int 4

CategoryForumID
int 4

ForumName nvarchar 100

Description nvarchar 255 null

Column Name

Data Type Length Null

PostID(k) int

4

ForumID int
4

PostParentID int
4

Username nvarchar
50

Subject nvarchar 200

Message nvarchar 1000

PostDate datetime 8

Column Name
Data Type
Length
Null
Table3: POST

Username(k) nvarchar 50

Password nvarchar 50

Fullname nvarchar 100

Email nvarchar 100

Column
Name
Data
Type
Length
Null
Table4:MEMBER

4()E(*+,#9+()7B%=
4&+<7B%*7'9+6AB/+&D
<7B%
3= hQ7B%X#/;.(6,I.,=
0= hQ7B%7%/@,#8/=
C= hQ7B%'@&;.-,().,J.=
D= hQ7B%*7'9+6().,<6-&=


Xây dựng website diễn đàn

Tài liệu liên quan

Tài liệu bạn tìm kiếm đã sẵn sàng tải về