
103
-
-
F9405
(1)
(
SQL
VB
JAVA
)
(2)
!"#
!"#!"#
!"#
________________
!"#$%&'()
*+,-."/%01234
56789:";<=>26?@A7BAAC=
30
="D =
2
2"E 1
60
2FG?H A
C =
2
="D =
20
2"E 1
40
2F3
AC=IJ
2B
KLMN")AOPQR"S%TUVWX"%0123
HAC=IJYZ[L]^_LMN`
"a)bcd7efgh"i
jXklm0U2"
3
!
! !
! "
""
"#$%&'()*+#,
#$%&'()*+#,#$%&'()*+#,
#$%&'()*+#,-
--
-
5n;u_1vw
(
%xyz{|}~}~
)
" % p
OV+M;<%!u_1vwM:]qr""q
rX"kU
10
2Vku_1vwa*+,k;<¡¢£3
./0
./0./0
./01
11
12/03456789:
2/03456789:2/03456789:
2/03456789:-
--
-4
$
$$
$
%&'(&&)*
%&'(&&)*%&'(&&)*
%&'(&&)*
30
*
**
*+
++
+, *
, *, *
, *
2
-
--
-.
..
.
1
1.
R
100
SQL
SELECT COUNT(*)
FROM R
10000 100 10 1
4
2.
SELECT
!
"
GROUP BY ORDER BY JOIN WHERE
1
3.
#
SQL
SELECT
$%
&'
(
)
*
+
,
'
(
-.
+/
0
'
(
1/
0
2
34
5)
SELECT
$%
6
7
8
!
"
GROUP BY ORDER BY WHERE JOIN
2
4.MS SQL
9:
;
<
"
=>
? @
AB
CD
EF
"
G
*
HI
J
K
8
LM
NO
P Q
RB
S
T
RB
T
UV
WS
T
LX
YZ
[
]^
_
2
5.
.
`
P
RB
ab
c
V
d
=
SQL
e
%
N
fg
h
=G
i
IS LIKE CONT LEFT
3
6.
j
lk
SQL
e
%
m
SELECT * FROM A ? JOIN B ON A.id = B.id
.
n
j
o
A
p
"?"
qr
s
Q
fg
h
=
INNER RIGHT
LEFT RIGHT OUTER
3
7.
t
SQL
u
"
v
W
K
8
INSERT INTO A (colA, colB)
SELECT colA, colB
FROM B;
wx
y
A
A
z
B
{
|
}
B
~
Q
A
w
B
z
x
y
k
A
A
2
8.
s
Q
5
SQL
e
%
?
q
g
h
=
m
SELECT COUNT(?) ? B ? BY id
*/FROM/ORDER id/FROM/GROUP
id/JOIN/GROUP id/FROM/ORDER
3
9.
f
Visual Basic
u
t
9:
Visual Basic
6
H
Visual Basic
u
)
Dim
Function
)
Function
¡
Function
¢
£¤
¥
Visual Basic
u
¦
¡
)
Static
2
10.
f
Visual Basic
u
$¢
§
t
9:
¢
£
¨
k
f
= ©
Kª
«
P
=¬
¢
£
T
U
®
¯
¢
£ª
«
P°
K±
²
¢
£³
*
#
K
Visual Basic
´
µ
=
1
11.
VB
u
¶·
*
#
¸¹k
f
K
True
?
False
º
¯k
f»
¼
(block)
t
½³
F
{
|
(
¾¿
K
True
)
¿
³
F
{
|
À
»
¼
)
Do … Loop
For … Next
For Each … Next
If … Then … Else … End If
3
12.
Á
VB
t
Â
Dim Sale(120) As Integer
Ã
V
WÄ
Sale
Å
Sale
©
Æ
f
K
119
f
120
f
121
f
Ç È
ÉF
4
13.
Á
VB
t
Â
Dim Arr = {{1, 2}, {3, 4}, {5, 6}}
Ã
V
WÄ
Arr
t
8Ê
Ë
Ì
Arr
k
f
6
f©
Æ
k
ÍÄ
Arr
k
f
7
f©
Æ
k
ÍÄ
V
W Î
Ä
Arr(3, 2)
©
Æ
Arr(2, 1)
6
1
14.
Java
u
t
Ï
P
(Overriding)
Ð
Ñ
9:
Ï
P
§È
YÒ
Ó
®
*
#
«Ô
I
§È
Ï
P
ÕÖ
×
Ø
g
Ù
Ú
Û
ÜÝ
Ï
P
§È
¢
£
6
±
²
Ï
P
§È
Þ
ß
³
à
áãâ
Ûä
å
æç
è
é
6
ê
I
§È
±
²
4
15.
Java
u
t
×
Ø
g
Ù
ë
has-a
ì
g
Ù
Ú
Û
(Class)
Á
í
(Interface)
g
h
=
extends
k
f
Á
í
Ú
Û
î
ïð
(Overloading)
¯
ñO
í
p
§È
í
Ú
Û
k
í
Ú
Û
*
#
×
Øò
f
#
^
í
Ú
Û
1
16.
8Ê
óô
£
õ
ö÷
øù
ECDSA TripleDES
SHA2 DES
3
17.
;
<ú
Û
øù
(Message Authentication Code)
MAC
*
#
û
ü
k
ýþ
ÿ
H
÷
(confidentiality)
³
*
½
(Non-repudiation)
(integrity)
*
(availability)
1
18.
8Ê
³
B
(digital signature)
ÿ
H
AES RSA DSA DSS
4
19.
8Ê
Ç È
û
ü
ò
ýþ
SHA384 AES RSA JPG
3
20.
g
(certificate)
¤
t
8Ê
³
Ë
Ì
r
b
Ì
r
b
Ì
½
D
^
7
k
Á
Ê
û
ü
ð
K
¤
À
K
Ë
Ì
*
#
±
!
§¿
X.509
"
#
o
$
±
g
%&