,+&ơ11*

751*
,
H&63+0
KHOA TIN +&
-----[\ [\-----

/8191771*+

7ơ,
+7+1*3+ặ13+,+ơ1*+ẽ$

CHUYấN NGNH: &1+ặ1&é1*1*+7+é1

*LQJYLrQKQJGQ
3*676.+7UQ4XF&
6LQKYLrQWKFKLQ
3KP9Q7~
/S
10CNTT1

j1QJ


/Ӡ,&Ҧ0Ѫ1

ĈӇWKӵFKLӋQOXұQ
YăQ
Qj\HPÿmQKұQÿѭӧFVӵJL~
NKRD 7LQ +ӑF WUѭӡQJ ĈҥL

Yj
+ӑF
ÿӝL
FiQ
6ѭ
QJNJ
công
Eӝ
3KҥP
ty
Ĉj
FPT Software.

ĈҫXWLrQHP[LQJӣLOӡLFҧPѫQFKkQ
WUѭӡQJĈҥLKӑF6ѭ3KҥPĈj1ҹQJÿmWұQ
WuQKJLҧQJGҥ\WUX\ӅQ
NLQKQJKLӋPTXêEiXYjÿmNKtFKOӋKӛ
QăPÿҥLKӑFFKXҭQEӏ
1JRjLUDHPFKkQWKj
KjQKWUDQJYjRÿӡ
GүQ WұQ WuQK FӫD DQK
re FKӏ
JL~S
ErQ
HPF{QJ
WLӃSW\
FұQ
)
F{QJQJKӋKLӋQQD\


ĈһFELӋWHP[LQFKkQWKjQKFҧPѫQ
3*6767UҫQ4XӕF&KLӃ
ÿmFyQKӳQ
ÿӅQJKӏKѭӟQJGүQHPWURQJVXӕ
WWKӡLJLDQGjLWKӵFKLӋQ
WӯSKkQWtFK
GӳOLӋXFKRÿӃQKӳQJQJKLӋSYөFKѭѫQJW

Em xin FҧPѫQWҩWFҧEҥQEqÿmYjÿDQJO
WURQJVXӕWWKӡLJLDQKӑFWұSFNJQJQKѭW

&XӕLFQJFRQNtQKJӱLOӡLFҧPѫQVk
&KD0ҽÿmNKyQKӑFVLQKWKjQKYjJLiR
ҧPѫQWҩWFҧPӑL
WѭӣQJNKtFKOӋÿӝQJYLrQYjWҥR PӑL
WKӡLJLDQÿӇFK~QJFRQFyÿѭӧFWKjQKTX

0һF G ÿm Qӛ OӵF UҩW QKLӅX QKѭQJ Yu
QJKLӋPP{Q
FKX\rQ
FNJQJ QKѭ NLQK QJKLӋS WKӵF W
WUiQK NKӓL QKӳQJ WKLӃX
RQJ
VyW
QKұQ
QJRjL
ÿѭӧF
ê PXӕ
Vӵ
FӫDT

XêWKҫ\F{YjPRQJQKұQÿѭӧFVӵÿyQJ

0ӝWOҫQQӳDHP[LQWUkQWUӑQJFҧPѫQ
!

Ĉj1ҹQJ
QJj\WKiQJ

6LQKYLrQWKӵFK

3KҥP9ăQ7~


'$1+0Ө&&È&%Ҧ1*6ѪĈӖ+Ỵ1
%Ҧ1*
4.1. 0{WҧQJѭӡLGQJ
............................................................................ 31
%Ҧ1*
4.2. 0{Wҧ8VHFDVH
................................................................................ 31
%Ҧ1*
5.1. %ҧQJ³WjLNKRҧQ´
........................................................................... 51
%Ҧ1*
5.2. %ҧQJ³QKkQYLrQ´
.......................................................................... 51
%Ҧ1*
5.3. %ҧQJ³ORҥLKjQJ´
........................................................................... 51
%Ҧ1*

5.3. %ҧQJ³O{KjQJ´
.............................................................................. 51
%Ҧ1*
5.5. %ҧQJ³VҧQSKҭP´
........................................................................... 52
%Ҧ1*
5.6. %ҧQJ³QKjFXQJFҩS´
..................................................................... 52
%Ҧ1*
5.7. %ҧQJ³SKҧQKӗL´
............................................................................ 52
%Ҧ1*
5.8. %ҧQJ³WuQKWUҥQJO{
KjQJ´
............................................................. 53
%Ҧ1*
5.9. %ҧQJ³[XҩWKjQJ´
.......................................................................... 53
%Ҧ1*
5.10. %ҧQJ³JLӓKjQJ´
............................................................................ 53
%Ҧ1*
5.11. %ҧQJ³FKLWLӃW[XҩWKjQJ´
.............................................................. 53
%Ҧ1*
5.12. %ҧQJ³FKLWLӃWJLӓKjQJ´
................................................................ 53
%Ҧ1*
5.13. %ҧQJ³WLQWӭF´
................................................................................ 54

%Ҧ1*
5.14. %ҧQJ³NKX\ӃQPmL´
....................................................................... 54
HÌNH 2.1.
HÌNH 2.2.1.1.
HÌNH 2.2.1.2.
HÌNH 2.2.2.1.
HÌNH 2.4.
HÌNH 3.3.1.
HÌNH 3.3.2.
HÌNH 3.3.3.
HÌNH 3.3.4.
HÌNH 3.3.5.
HÌNH 3.3.6.
HÌNH 3.3.7.
HÌNH 3.3.8.
HÌNH 3.3.9.
HÌNH 3.3.10.
HÌNH 3.3.11.
HÌNH 3.3.12.
HÌNH 3.3.13.
HÌNH 3.3.14.
HÌNH 3.3.15.

6ѫÿӗӭQJGөQJ&OLHQW6HUYHU
........................................................ 5
0{KuQK[ӱOt5HTXHVWFӫD6HUYOHW
. ................................................. 8
9zQJÿӡL6HUYOHW
. ............................................................................ 9

9zQJÿӡLPӝWWUDQJ-63
................................................................ 11
Mơ hình MVC ............................................................................... 14
6ѫÿӗKRҥWÿӝQJÿăQJQKұS
........................................................... 20
6ѫÿӗKRҥWÿӝQJÿăQJ[XҩW
............................................................ 20
6ѫÿӗKRҥWÿӝQJÿăQJNê
............................................................... 21
6ѫÿӗKRҥWÿӝQJTXҧQOêWjLNKRҧQ
.................................. 21
6ѫÿӗKRҥWÿӝQJTXҧQOêWLQWӭF
.................................................... 22
6ѫÿӗKRҥWÿӝQJTXҧQOêNKX\ӃQP
............................................ 22
6ѫÿӗKRҥWÿӝQJTXҧQOêQJѭӡLGQ
............................................ 23
6ѫÿӗKRҥWÿӝQJTXҧQOêVҧQSKҭP
............................................... 23
6ѫÿӗKRҥWÿӝQJTXҧQOêORҥLKjQJ
................................................ 24
6ѫÿӗKRҥWÿӝQJTXҧQOêO{KjQJ
................................................... 24
6ѫÿӗKRҥWÿӝQJTXҧQOêÿѫQÿһW
.......................................... 25
6ѫÿӗKRҥWÿӝQJTXҧQOê[XҩWKjQJ
............................................... 25
6ѫÿӗKRҥWÿӝQJTXҧQOêWuQKWUҥQ
................................ 26
6ѫÿӗKRҥWÿӝQJWKӕQJNr

.............................................................. 26
6ѫÿӗKRҥWÿӝQJTXҧQOêSKҧQKӗL
................................................. 27


HÌNH 3.3.16.
HÌNH 3.3.17.
HÌNH 3.3.18.
HÌNH 3.4.1
HÌNH 3.4.2
HÌNH 3.4.3
HÌNH 3.4.4
HÌNH 3.5.1
HÌNH 3.6.1
HÌNH 3.6.2
HÌNH 3.6.3
HÌNH 3.6.4
HÌNH 3.6.5
HÌNH 3.6.6
HÌNH 3.6.7
HÌNH 3.6.8
HÌNH 3.6.9
HÌNH 3.6.10
HÌNH 3.6.11
HÌNH 3.6.12
HÌNH 3.6.13
HÌNH 3.6.14
HÌNH 3.6.15
HÌNH 3.7.1
HÌNH 3.7.2

HÌNH 3.7.3
HÌNH 3.7.4
HÌNH 3.7.5
HÌNH 3.7.6
HÌNH 3.7.7
HÌNH 3.7.8
HÌNH 3.7.9
HÌNH 3.7.10
HÌNH 3.7.11
HÌNH 3.7.12
HÌNH 3.7.13
HÌNH 3.7.14
HÌNH 3.7.15
HÌNH 3.7.16

6ѫÿӗKRҥWÿӝQJKLӇQWKӏWLQWӭF
.................................................... 27
6ѫÿӗKRҥWÿӝQJKLӇQWKӏVҧQSKҭ
............................................... 28
6ѫÿӗKRҥWÿӝQJKLӇQWKӏOӏFKVӱ
.................................... 28
6ѫÿӗXVHFDVH$GPLQ
................................................................... 29
6ѫÿӗXVHFDVHQJѭӡLGQJ
............................................................ 29
6ѫÿӗXVHFDVHQKkQYLrQ
............................................................... 30
6ѫÿӗXVHFDVHNKiFKKjQJ
............................................................ 30
/ѭӧFÿӗGӳOLӋXTXDQKӋ

............................................................... 50
4XiWUuQKÿăQJQKұS
..................................................................... 54
4XiWUuQKÿăQJ[XҩW
....................................................................... 55
4XiWUuQKKLӇQWKӏWLQWӭF
............................................................... 55
4XiWUuQKTXҧQOêWLQWӭF
............................................................. 56
4XiWUuQKKLӇQWKӏVҧQSKҭP
......................................................... 56
4XiWUuQKKLӇQWKӏFKLWLӃWVҧQS
.............................................. 57
4XiWUuQKTXҧQOêVҧQSKҭP
......................................................... 57
4XiWUuQKTXҧQOêQKkQYLrQ
.......................................................... 58
4XiWUuQKTXҧQOêNKiFKKjQJ
...................................................... 59
4XiWUuQKTXҧQOêQKjFXQJFҩS
.................................................... 60
4XiWUuQKKLӇQWKӏGDQKViFKO{
............................................ 61
4XiWUuQKTXҧQOêÿѫQKjQJ
.......................................................... 61
4XiWUuQKQKұSKjQJ
...................................................................... 62
4XiWUuQKKLӇQWKӏJLӓKjQJ
........................................................... 62
4XiWUuQKÿһWKjQJ

........................................................................ 62
*LDRGLӋQWUDQJFKӫ
...................................................................... 63
*LDRGLӋQPHQXFӫDNKiFKYmQJOD
............................................. 63
*LDRGLӋQPHQXFӫDQJѭӡLGQJ
.................................................. 64
*LDRGLӋQWUDQJWLQWӭF
.................................................................. 65
*LDRGLӋQFKLWLӃWWLQWӭF
............................................................... 66
*LDRGLӋQWUDQJVҧQSKҭP
.............................................................. 67
*LDRGLӋQFKLWLӃWVҧQSKҭP
.......................................................... 68
*LDRGLӋQJLӟLWKLӋX
...................................................................... 69
*LDRGLӋQOLrQKӋ
.......................................................................... 70
*LDRGLӋQÿăQJQKұS
..................................................................... 71
*LDRGLӋQÿăQJNê
........................................................................ 72
*LDRGLӋQSKөFKӗLPұWNKҭX
........................................................ 73
*LDRGLӋQWUDQJFKӫDGPLQYjQKk
....................................... 74
*LDRGLӋQTXҧQOêWLQWӭF
.............................................................. 75
*LDRGLӋQWKDRWiFWLQWӭF

.............................................................. 76
*LDRGLӋQTXҧQOêNKX\ӃQPmL
..................................................... 77


HÌNH 3.7.17
HÌNH 3.7.18
HÌNH 3.7.19
HÌNH 3.7.20
HÌNH 3.7.21
HÌNH 3.7.22
HÌNH 3.7.23
HÌNH 3.7.24
HÌNH 3.7.25
HÌNH 3.7.26
HÌNH 3.7.27
HÌNH 3.7.28
HÌNH 3.7.29
HÌNH 3.7.30
HÌNH 3.7.31
HÌNH 3.7.32
HÌNH 3.7.33
HÌNH 3.7.34
HÌNH 3.7.35
HÌNH 3.7.36
HÌNH 3.7.37
HÌNH 3.7.38
HÌNH 3.7.39

*LDRGLӋQWKDRWiFNKX\ӃQPmL

...................................................... 77
*LDRGLӋQTXҧQOêQKkQYLrQ
.......................................................... 78
*LDRGLӋQTXҧQOêNKiFKKjQJ
....................................................... 78
*LDRGLӋQTXҧQOêQKjFXQJFҩS
.................................................... 79
*LDRGLӋQWKDRWiFWK{QJWLQ
.......................................................... 79
*LDRGLӋQTXҧQOêVҧQSKҭP
.......................................................... 80
*LDRGLӋQTXҧQOêORҥLKjQJ
.......................................................... 80
*LDRGLӋQTXҧQ
lý lô hàng ............................................................. 81
*LDRGLӋQTXҧQOêÿѫQKjQJ
.......................................................... 81
*LDRGLӋQTXҧQOêKѭKҥL
............................................................... 82
*LDRGLӋQWKDRWiFQKұSKjQJ
........................................................ 82
*LDRGLӋQTXҧQOê[XҩWKjQJ
.......................................................... 83
*LDRGLӋQTXҧQOêSKҧQKӗL
........................................................... 83
*LDRGLӋQWKӕQJNrQKұS[XҩW
........................................................ 84
*LDRGLӋQWKӕQJNrGRDQKWKX
....................................................... 85
*LDRGLӋQWKӕQJNrKjQJKyD

......................................................... 85
*LDRGLӋQTXҧQOêWjLNKRҧQ
.......................................................... 86
*LDRGLӋQWKD\
ÿәLPұWNKҭX
......................................................... 87
*LDRGLӋQWKLӃWOұSEҧRPұW
........................................................... 88
*LDRGLӋQWUDQJNKiFKKjQJ
........................................................... 88
*LDRGLӋQOӏFKVӱJLDRGӏFK
............................................................ 89
*LDRGLӋQFKLWLӃWJLDRGӏFK
........................................................... 90
*LDRGLӋQJLӓKjQJ
........................................................................ 91


.é+,ӊ8&È&&Ө07Ӯ9,ӂ77Ҳ7

No.
1
2
3
4
5
6
7
8


&KӳYLӃWWҳW
0{Wҧ
Application Programming Interface
API
*LDRGLӋQOұSWUuQKӭQJ
MVC
Model-View-Controller (MVC)
JSP
JavaServer Pages
JSF
JavaServer Faces
RDBMS
relational database management system
CSDL
&ѫVӣGӳOLӋX
CSDLQH
&ѫVӣGӳOLӋXTXDQKӋ
SQL
Structured Query Language


0Ө&/Ө&

/Ӡ,&Ҧ0Ѫ1
DANH 0Ө&&È&%Ҧ1*6ѪĈӖ+Ỵ1+
.é+,ӊ8&È&&Ө07Ӯ9,ӂ77Ҳ7
0Ө&/Ө&
*,Ӟ,7+,ӊ8
............................................................................................................. 1
1.1.

7әQJTXDQ
..................................................................................................... 1
1.2.
9ҩQÿӅÿһWUD
................................................................................................ 1
1.3.
0өFWLrXFӫDOXұQYăQ
.................................................................................. 2
1.4.
ĈӕLWѭӧQJYjSKҥPYLQJKLrQFӭX
................................................................ 2
1.5.
3KѭѫQJSKiSQJKLrQFӭX
.............................................................................. 3
1.6.
%ӕFөFFӫDOXұQYăQ
..................................................................................... 3
&Ѫ6Ӣ/é7+8<ӂ7
............................................................................................... 5
2.1.
+ӋTXҧQWUӏFѫVӣGӳOLӋX64/6HUYH
.......................................................... 5
2.1.1. *LӟLWKLӋX64/6HUYHU
............................................................................. 5
2.1.2. &iFWKjQKSKҫQFӫDPӝW&6'/7URQJ
................................. 6
2.2.
&{QJQJKӋ-636HUYOHW
............................................................................. 7
2.2.1. Servlet ...................................................................................................... 7

2.2.2. JSP .......................................................................................................... 10
2.2.3. So sánh JSP & Servlet ............................................................................ 13
2.3.
JavaScript ................................................................................................... 13
2.4.
Mơ hình MVC ............................................................................................ 14
PHÂN TÍCH 7+,ӂ7.ӂ
.................................................................................. 17
3.1.
................................................................................ 17
3.1.1. ....................................................................................... 17
3.1.2. .................................................................................. 18
3.2.
............................................................................... 19
3.2.1. 7tQKWLӃQKyD
.......................................................................................... 19
3.2.2. *LDRGLӋQWKkQWKLӋQGӉVӱGөQJ
.................................................... 19
3.2.3. Tính an toàn............................................................................................ 19
3.3.3. 7tQKWѭѫQJWKtFK
..................................................................................... 19
3.3.
6ѫÿӗKRҥWÿӝQJ
.......................................................................................... 20
3.4.
ĈһFWҧFKӭFQăQJSKҫQPӅP8VH&DVH

.................................................... 29
3.4.1. 6ѫÿӗ8VH&DVHV
..................................................................................... 29
3.4.2. 0{WҧQJѭӡLGQJ
................................................................................... 31
3.4.3. 0{Wҧ8VHFDVH
....................................................................................... 31
3.5.
7KLӃWNӃGӳOLӋX
........................................................................................... 50
3.6.
%LӅXÿӗWUuQKWӵ
........................................................................................... 54
3.7.
7KLӃWNӃJLDRGLӋQ
....................................................................................... 63
.ӂ7
/8Ұ1
............................................................................................................. 92
4.1.
.ӃWOXұQ
...................................................................................................... 92
4.2.
+ѭӟQJSKiWWULӇQ
......................................................................................... 92
7¬,/,ӊ87+$0.+Ҧ2
..................................................................................... 93


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ

VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

*,Ӟ,7+,ӊ8
1.1. 7͝QJTXDQ

+LӋQ QD\ QѭӟFWD ÿDQJ QJj\ FjQJ
YăQ
SKi

KyD[mKӝL7UuQK
ÿӝGkQWUtQJj\FjQJÿѭӧFFK~
WUӑQJQkQJFDR+ӝ

FNJQJ WUӣ WKjQK QKX FҫX
, PXD
WҩW
EiQ
\ӃX
KjQJ
1KX
KyD
Fҫ

Q{QJQJKLӋS
FjQJWăQJOrQJҩSEӝLYjUӝQJNKҳ

QD\NK{QJFKӍ
SKRQJSK~YӅFKӫQJORҥLPjFKҩW

YӵF
9uYұ\FK~QJWDFҫQFK~WUӑQJQ
ҳPEҳWQJXӗQWjLQJX\rQ
WӃQ{QJQJKLӋSQѭӟFWD
FyWѭѫQJODL
WѭѫLViQJKѫQ

ĈӅÿiSӭQJQKѭFҫXPXDEiQYjFKҩWO
ng. Các công ty

ÿҫX PӕL ÿXD QKDX KuQK WKjQK Yj SKiW W

NK{QJÿiSӭQJÿӫÿѭӧFQKXFҫXPXDEiQK
SKiWWULӇQUDNKXYӵF9uQKLӅXOtGR
-

%ӏÿӝQJ
QJXӗQKjQJ

-

7K{QJWLQÿӃQQJѭӡLWLrXG
QJFKұPWUӉ

-

+ҥQFKӃEyEXӝFYӅYӏWUtÿӏDOêJ
KRһFF{QJW\YӯDYjQKӓ

-

&KLSKtTXҧQJEiWKѭѫQJKLӋXYjVҧQ

%rQFҥQKÿyÿkXOjQJX\rQQKkQGүQ

WUӋ"1JѭӡLPXDQKұQ[pWJuYuFiF
KÿiSӭQJ
WK{QJWLQWӟLKӑ"1Jѭ

YӅÿҫXUDVҧQSKҭPQ{QJVҧQ
FӫDKӑ
"/jPWKӃQjRÿӇQkQJFD

KjQJKyDQ{QJVҧQFӫDGRDQKQJKLӋSWKӡL
1.2. 9̭Qÿ͉ÿ̿WUD

7URQJ QKӳQJ QăP JҫQ ÿk\ Vӵ SKiW
W

&RPPHUFH
 ÿm ÿHP OҥL QKLӅX OӡL tFK WR

WKѭѫQJPҥLÿLӋQWӱQKLӅXORҥLKuQKNL

PXDEiQKjQJWUrQPҥQJYӟLKuQK
WKӭFPӟLQj\QJѭӡLWLrX
3KҥP9ăQ7~
±10CNTT1

Trang 1

+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

KjQJKyDPӝWFiFKGӉGjQJYjQKDQKFKy

EiQWUX\ӅQWKӕQJ
1KѭQJYұ\YҩQÿӅFҩSWKLӃWO~F

EiQ Yj TXҧQ Oê WUX\ӅQ
QWKӕQJ
Wӱ &ө
VDQJ
WKӇWKѭѫQ
SKiW

TXҧQOêKӋWKӕQJSKkQSKӕLKjQJKyDQ{Q

0ӝWKӋWKӕQJFyWKӇKӛWUӧ
GRDQKQJKLӋS
WӯYLӋFPXDEiQKjQ

ÿӃQYLӋFTXҧQJEiWLQWӭFVҧQSKҭPÿӃQ

FiQKkQJLDRGӏFK
WKӕQJNrEiRFiR1JRjLUDKӋ

Yj WKҫQ WKLӋQ YӟL QJѭӡLGQJ 4XD ÿy Q

Q{QJVҧQFӫDGRDQKQJKLӋS
1.3. 0ͭFWLrXFͯDOX̵QYăQ

1{QJ
Oj
VҧQ
PӝW WURQJ QKӳQJ WKӃ PҥQK
nay.
FӫD

1KѭQJ WKӵF WӃ WKu KjQJ KyD Q{QJ VҧQ Oҥ

1KҵPÿiSӭQJQKXFҫXWuPÿҫXUDFKRKjQ

NrQK WUXQJ JLDQ QKҵP ÿѭD KjQJ KyD Q{QJ

GXQJ7ҥRUDJL
ҧLSKiSX\WtQWLQFұ\ÿӇSKkQ
TXҧQKҩW
-

7uPKLӇX
QJKLӋSYөFӫDGRDQKQJKLӋSSKkQ

-

7uPKLӇXYӅ
F{QJQJKrPӟL-636HUYOHWWK

-

7uPKLӇXYLӋFWtFKKӧSFiF$3,FӫD

1.4. Ĉ͙LW˱ͫQJ
YjSK̩PYL
QJKLrQFͱX
-

ĈӕLWѭӧQJ

+ 4XҧQOêQJKLӋSYөFKѭѫQJWUuQKKӋW
+ 1J{QQJӳ-DYD
+ &ӣVӣGӳOLӋX
SQL Server 2008.

+ &{QJFөKӛWUӧYLӋFOұSWUuQKQKѭ
plus.

3KҥP9ăQ7~
±10CNTT1

Trang 2


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

-

3KҥPYL
+ 9ӅFѫVӣGӳOLӋX
7URQJSKҥPYLFӫDÿӅWjL

GӳOLӋX
64/6HUYHUÿӇTXҧQOêWK{QJ
.
+ 9ӅPһWWKXұWWRiQ
7ұSWUXQJFiFWKXұWWRiQ

FiFÿѫQKjQJWKHRFiF\rXFҫXFӫDQ

 3KҥPYLNӃWQӕLJLӳDF
iFKӋWKӕQJ
.ӃWQӕLWK{QJTXDLQ
.
1.5. 3K˱˯QJSKiSQJKLrQFͱX
-

7KXWKұSYjQJKLrQFӭXFiFWjLOLӋX

-

1JKLrQFӭXFiFWKѭYLӋQFӫD*RRJOH

-

7uPKLӇXYӅQJ{QQJӳOұSWUuQK
Java ÿӇOұSWUuQKFKRSKҫ

-

7uPKLӇXYӅFѫVӣGӳOLӋX
SQL Server 2008.

-

7uPKLӇXFiFKP{KuQK09&FKR-63

-

3KkQWtFKFiF\rXFҫXFKӭFQăQJFӫ

-

7KLӃWNӃYjFjLÿһWNLӇPWKӱKӋWK

1.6. %͙FͭFFͯDOX̵QYăQ

%ӕFөFFӫDOXұQYăQÿѭӧFWәFKӭFWKjQ

&KѭѫQJ*LӟLWKLӋX
: 7UuQKEҫ\WәQJTXiWYӅKӋW
SKkQ SKӕL KjQ
Q{QJVҧQYjPөFWLrXFӫDOXұQYăQ

&KѭѫQJ
. &ѫVӣOêWKX\ӃW
: 7UuQKEҫ\WәQJTXiWYӅF
GөQJWURQJOXұQYăQ

&KѭѫQJ
. Phântích: *LӟL WKLӋX WәQJ TXDQ YӅ KӋ

nhiӋPYөPjKӋWKӕQJVӁWKӵFKLӋQYjFi

YӅF{QJFөYjP{LWUѭӡQJSKiWWULӇQӭQ

WK{QJTXDNKҧRViWKLӋQWUҥQJWKӵFWӃÿ

WKӭFKRҥWÿӝ
QJFӫDKӋWKӕQJ&KѭѫQJQj\EDRJ

WUuQKSKkQWtFKKӋWKӕQJQKѭSKkQWtFK

3KҥP9ăQ7~
±10CNTT1

Trang 3


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

&KѭѫQJ
7KLӃWNӃ
%DRJӗPFiFWjLOLӋXOLrQT

WKӕQJQKѭWKLӃWNӃGӳOLӋX

WKLӃWNӃNLӃQWU~FWKLӃWNӃ

&Kѭ
ѫQJ
. &jLÿһWYjWULӇQNKDL
7UuQKEj\FiFYҩQÿӅO

YjWULӇQNKDLKӋWKӕQJQKѭOӵDFKӑQP{
GөQJFiFEѭӟFFjLÿһWFKtQKYjYLӋF
WULӇQNKDLKӋWKӕQJ

&KѭѫQJ
. 7әQJNӃW
7UuQKEj\WyPWҳWFiF±NӃWT

NKX\ӃW ÿLӇP FӫD KӋ WKӕQJ Yj ÿӅ [XҩW Fi
WULӇQWURQJWѭѫQJODL

3KҥP9ăQ7~
±10CNTT1

Trang 4


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

&Ѫ6Ӣ/é7+8<ӂ7
2.1. +͏TX̫QWU͓F˯VͧGͷOL͏X

SQL Server
2.1.1. *LͣL
WKL͏X64/6HUYHU

64/OjPӝWKӋWKӕQJTXҧQWUӏ&6'

&OLHQW6HUYHU
EҧQ
Ĉk\
GQJ
Oj KӋ
OѭX
WKӕQJ
WUӳFѫ
Gӳ OLӋX
GөQJOӟQKLӋQQD\

ӬQJGөQJNLӇX&OLHQW6HUYHU
0ӝWӭQJGөQJNLӇX&OLHQW6HUYHUEDRJ

Pi\FKӫ
YjSKҫQNKiFFKҥ\WUrQFiFZR

Hình 2.1 6˯ÿ͛ͱQJGͭQJ&OLHQW6HU
.

3KҫQ 6HUYHU FKӭD FiF &6'/ FXQJ FҩS

FKӭFYj
TXҧQOê&6'/FKRSKpSQKLӅXQJѭӡL

Qj\NK{QJFKӍWLӃWNLӋPPjFzQWKӇKLӋ

OLӋXÿӅXÿѭӧFWUX\[XҩWWK{QJTXDVHUYH

ÿӝEҧRPұWFDRWt
QKQăQJFKӏXOӛLFKҥ\ÿӗQJWKӡL

3KҫQ &OLHQW ӬQJ GөQJ NKiFK
 /j Fi

SKpSQJѭӡLVӱGөQJJLDRWLӃS&6'/WUrQ
WUuQK Yj WUX\ -64/
YҩQ &6'/
SKLrQ
PӝW 7UDQVDFW
FӫD
EҧQ
Structured Query

/DQJXDJH9ӟL7UDQVDFW
-64/EҥQFyWKӇWUX\[XҩWGӳ

WKӕQJ &6'/
9ӟL
TXDQ
PӛL
i\
KӋ
FKӫ

P
EҥQ FKӍ
TXҧQ
Fy PӝW
WUӏKӋ
&6

3KҥP9ăQ7~
±10CNTT1

Trang 5


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

64/6HUYHU1ӃXPXӕQFyQKLӅXKӋ
WKӕQJTXҧQWUӏ
&6'/EҥQFҫQFyQK
WѭѫQJӭ
ng.

2.1.2. &iFWKjQKSK̯QFͯDP͡W&6'/7URQJ64
0ӛL&6'/FyFiFÿӕLWѭӧQJVDX
-

Table OjÿӕLWѭӧQJFKtQ
KFӫD&6'/GQJOѭXGӳOLӋ
TXҧQOê0ӛL

FyKD\QKLӅX
WUѭӡQJ
0ӛL
WUѭӡQJ
ӭQJYӟLPӝWPӝWORҥL

1JRjLUDWDEOHFzQFyFiFWKjQKSKҫQ
+ Constraint - 5jQJEXӝ
t

Constraint OjFiFFKӍÿӏQKUjQJEXӝFGӳ

NKiFQKDXWKHRPӝWTX\WҳFQjRÿy
+ Triggers - %ү\OӛL

7ULJJHUV WKѭӡQJ FKӭD FiF Pm OӋQK

ÿӝQJWKӵFKLӋQNKLFyKjQKÿӝQJQ

7DEOHQKѭLQVHUWXSGDWHGHOHWH
+ Indexs - &KӍPөF

+ӗWUӧFKRYLӋFVҳS[ӃSYjWuPNLӃ

-

Diagram - 6ѫÿӗ
TXDQKӋ7KӇKLӋQPӕLTXDQKӋ

-

Views - khung nhìn hay EҧQJ
ҧR/jÿӕLWѭӧQJGQJKL

WUtFKWtQKWRiQWӯFiFWDEOHWKHRQ
-

Stored Procedure - 7Kӫ
WөF&KӭDFiFOӋQK7
-SQL dùng thӵFKLӋQPӝW

WiF Yө QjR ÿy
edure Fy
6WRUHG
WKӇ QKұQ
3URFYj WUX\ӅQ

Procedure ÿѭӧFELrQGӏFKWUѭӟFGRÿyWKӡ

JӑL&yQKLӅX6WRUHG3URF
edure KӋWKӕQJÿѭӧFÿӏQKQJK

FyQKLӋPYөWKXWKұSW
K{QJWLQWӯFiFEҧQJKӋWK
TXҧQWUӏ
-

User Defined Function+jPGRQJѭӡLGQJÿӏQKQ

3KҥP9ăQ7~
±10CNTT1

Trang 6


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

-

Users &KӭD GDQK ViFK 8VHU Vӱ GөQJ &6'
QKҩWFy8VHU1DPHOjGERWrQÿăQJ

là sa. 7jLNKRҧQVDOX{QWӗQWҥLYjNK{QJ
-

Roles: &iF TXL ÿӏQK YDL WUz Yj FKӭF QăQ
Server.

-

Rules: &iFTXLWҳFUjQJEXӝFGӳ
OLӋXÿѭӧFOѭXWUӳWUrQW

-

Defaults: &iFNKDLEiRJLiWUӏPһFÿӏQK

-

User Defined Data Type: .LӇXGӳOLӋXGRQJѭӡLGQ

-

Full Text Catalogs: 7ұSSKkQORҥLGӳOLӋXWH[W

2.2. &{QJQJK͏-636HUYOHW
2.2.1. Servlet
2.2.1.1. .KiLQL͏P
-

-DYDVHUYOHWVÿѭӧFWҥRUDQKҵPPөF
&*,YjQKӳQJWUuQKFKӫVHUYHU$3,

-

/jFiFÿӕLWѭӧQJKRһFPӝWÿRҥQFKѭѫ
QăQJFӫDPӝW+773VHUYHU

-

ĈѭӧFiQK[ҥYӟLPӝW85/YjÿѭӧFTXҧ

-

&Kҥ\ÿѭӧFWUrQWҩWFҧFiFZHEVHUYH

-

.K{QJSKөWKXӝFYjRSODW
form và server.

2.2.1.2. ˰XÿL͋P
FͯD6HUYOHW
-

&yUҩWQKLӅXF{QJFөFӫDErQWKӭ

-

7UX\FұSÿѭӧFPӑL-DYD$3,V

-

ĈӝWLQFұ\FDR5HOLDEOH
DQWRjQ
JWӕWGӉPӣU
(scalability)

3KҥP9ăQ7~
±10CNTT1

Trang 7


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

2.2.1.3. Mơ hình Servlet request và response

+uQK0{KuQK[͵Ot5HTX
.
-

Request OjWK{QJWLQÿѭӧFJӱLWӯFOLHQW

WLQ FKӭD WURQJ UHTXHVW Pj VHUYHU E
ÿѭӧFXVHUQKұSYjRYjJӱLÿL
các HTTP header.
-

5HVSRQVHOjWK{QJWLQJӱLÿӃQFO

WH[WKWPOWKXҫQWH[W
KRһFGӳOLӋ
-

1KLӋPYөFӫD6HUYOHW
+

1KұQFOLHQWUHTXHVWKҫXKӃWӣGҥ

+

7UtFK[XҩWPӝWVӕWK{QJWLQWӯUH
uest.

+

;ӱ Ot QJKLӋS Yө WUX\ FұS GDWDED
GXQJPӟL

+

7ҥR Yj JӱL WUҧ UHVSRQVH FKR FOLH

KRһF IRUZDUG UHTXHVW FKR VHUYOH

3KҥP9ăQ7~
±10CNTT1

Trang 8


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

2.2.1.4. 9zQJÿͥLFͯD6HUYOHW

Hình 9zQJÿͥL6HUYOHW
-

.KL PӝW ӭQJ GөQJ FKѭD ÿѭӧF GHSOR\
ÿѭӧFNKӣLWҥR

-

.KLӭQJGөQJÿѭӧFGHSOR\YjRVHUYH

LQVWDQFH FKR VHUYOHW WURQJ O~F NK

LQLWFKӍÿѭӧFNtFKKRҥWOҫQGX\QKҩ
ELrQGӏFK
.
-

.KL Fy PӝW UHTXHVW ÿӃQ VHUYOHW
Q QKұQ
Fӫ

UHTXHVWYjFKӑQLQVWDQFHEHDQEҩWN
-

6DXNKLFKӑQÿѭӧFEHDQFRQWDLQHU

/ѭXêӣÿk\ӣOҫQ\rXFҫXWKӭW

KRҥW KjP VHUYLFH
 KjP
WѭѫQJ
VHUYLFH
ӭQJ GR
VӁ
Yұ\
ÿѭ
OҫQ

-

.KLVHUYOHWÿѭӧFFұSQKұWPӟLKD\V

UD NKӓL
±FRQWDLQHU
VHUYHU
WKu KjP GHVWUR\

1JKƭD Oj VHUYOHW FKӍ NtFK KRҥW SKѭ
nKҩW

3KҥP9ăQ7~
±10CNTT1

Trang 9


+ӋWKӕQJSKkQSKӕLKjQJKyDQ{QJ
VҧQ
GVHD - 3*676.+7UҫQ4Xӕ

&iFSK˱˯QJWKͱFWURQJYzQJÿͥL6H

2.2.1.5.

&RQWDLQHUÿLӅXNKLӇQYzQJÿӡLFӫD

YzQJÿӡL6HUYOHWÿѭӧFJӑLEӣLFRQWDLQ
-

init(
ĈѭӧFJӑLPӝWOҫQNKLVHUYOHWÿ

VӁWKӵFKLӋQFiFNKӣLWҥRWURQJSKѭ
-

GHVWUR\
 ĈѭӧF JӑL WUѭӟF NKL Kӫ\
KLӋQWKDRWiFGӑQGҽS

-

service(
WURQJOӟSMDYD[VHUYOHWKWWS

ÿһWWӯSKѭѫQJWKӭFDEVWUDFWWURQJ

Qj\ JӑL ÿӃQ KDL SKѭѫQJ WKӭF GR*HW
SKѭѫQJWKӭFQj\
-

GR*HW