加載中. ..
PDF
103
-
-
F9407
(1)
(
COBOL
SQL
VB
JAVA
)
(2)
!"#$%"#
!"#$%"# !"#$%"#
!"#$%"#
________________
!"#$%&'()
*+,-."/%01234
56789:";<=>26?@A7BAAC=
20
="D =
2
2"E 1
40
2FG?H A
C =
3
="D =
20
2"E 1
60
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
r X "k U
10
2Vku_1vwa*+,k;<¡¢£3
./0
./0./0
./01
11
12/03456789:
2/03456789:2/03456789:
2/03456789:-
--
-4
&
&&
&
'()*((+,
'()*((+,'()*((+,
'()*((+,
20
,
,,
,-
--
-. ,
. ,. ,
. ,
2
/
//
/0
00
0
3
1.
COBOL
77 Y PIC 999B99.
:
:
MOVE "12345" TO Y.
DISPLAY Y.
123B45 123,45 123 45 123.45
2
2.
COBOL
!"
#
$%
&'
()
*
(DIVISION)
+
CONFIGURATION IDENTIFICATION
PROCEDURE DATA
4
3.
COBOL
,
-.
/0
1
23
45
6
E85 :ALPHABET-NAME DEFINED
!
7 8
9:
;
<=
>?
:
@
9:
;
=
>A
)
B
C
@D
E
9:
;
FG
H
D
E
9:
;
HI
J
D
E
4
4.
KL
M
7
R
N
S
*O
30
P
N
50
P
L
M
!
P
SQL
Q
R
ST
P
L
M
+
SELECT *
FROM R, S
30 50 20 1500
3
5.
B
SQL
2
SELECT
UV
W
*
XY
Z
Q
R
K
[
*
X
2
Y
Z
]^
_
,
Q
R
`
ab
c
d
*
Xe
f
gh
i
"
SELECT
UV
`
b
jk
lm
n
o
+
EXISTS EXCEPT HAVING IN
4
6.
p
j
VB
q
r
Dim Arr = {{1, 2}, {3, 4}, {5, 6}}
s
D
Et
P
Arr
P
q
l
u
v
+
Arr
wyx
(
6
(z
{
2|x
}t
P
Arr
wyx
(
7
(z
{
2|x
}t
P
D
E ~
t
P
Arr(3, 2)
z
{
Arr(2, 1)
2
w
6
1
7.
,
VB
2
Function
`
Function
2
q
p
q
2
q
#
p
j
Return Resume Stop Sub
4
8.
&
VB
2
Try...Catch...Finally
q
`
2
Finally
)
P
q
l
u
v
+
Try
)
Catch
)
Try
)
Catch
)
Catch
)
Catch
)
3
9.
,
Java
`
C
D
E
x
O
class C
{
static int n;
}
!
P
q
l
A
u
v
+
n
O
C
2|x
(
g
n
O
C
n
O
2
g
O
C
2
g
¡
2
n
n
2
¢
2
10.
P
Java
£
¤
l
+
int i = 3, j = 4;
j = (i++) + 3;
System.out.println(“i = “ + i “, j = “ + j);
i = 3, j = 6 i = 4, j = 6 i = 3, j = 7 i = 4, j = 7
2
11.
P
l
w
DAM(Database Activity Monitoring)
2¥
+
¦
§¨
©ª
L
M
«
¬
L
M
«
2®
e
¯
°
±
_L
M
«²
³
´µ
2¶
·
*
¸
¹
c
º»
¼
½
2
L
M
«
¬
¾¿
4
12.
P
SQL
o
l
¢
3
4
+
SELECT * FROM tblTest
SELECT * FROM tblTest, tblTest2
INSERT INTO tblTest VALUES (‘test1’, ‘test2’)
UPDATE SET col1=’test’ FROM tblTest
2
13.
P
l
wL
M
D
E
(Data Definition Language, DDL)
2À
Á
+
CREATE INSERT ALTER DROP
2
14.
P
l
w
Â
L
M
«
+
MS SQL HBase Oracle MariaDB
1
15.
ÃÄ
Å
ER Model
B
Æ Ç
u
ÈÉ
±
e
Ê
ËL
M
7
+
4 3 2 1
2
16.
,
x
fÌ
Í
Î
Ì
ÏÐ
ÑÒ
25
Ó
"
=
b
p
j
2Ì
Ô
Õ
P
l
+
Ö
×Ì
Ô
Õ
Ø
×Ì
Ô
Õ
Ù
PÌ
Ô
Õ
Ú
PÌ
Ô
Õ
4
17.
Û
(Ü
Ý
2
URL
Þ
ß
https://
à
á
7
Ü
Ý
p
j
lm
âA
ã
+
SAT SAP SET SSL
2
18.
x
(ä
å
201.100.36.0/24
æ
201.100.37.0/24
æ
201.100.38.0/24
N
201.100.39.0/24
4
(Ü
ç
Supernet
è
B
é
à
4
(Ü
çê
ë
|x
(ì
í
Ü
ç
P
l
+
201.100.36.0/21 201.100.36.0/22 201.100.36.0/23 201.100.36.0/24
1
19.
ÃÄ
î
l
ï
p
j
2.4GHz
ð
¤
+
802.11a 802.11b 802.11g 802.15
3
20.
Û ñ
ò
(Ethernet)
Ü
çó
2
MAC
ôõ
w
00-E0-18-0E-B2-21
!ö
2
÷ø
ID (Manufacture ID)
w
P
l
+
0E-B2-21 18-0E-B2 00-E0-18 E0-18-0E
1
11
1
2(+,
2(+,2(+,
2(+,3
33
34 ,
4 ,4 ,
4 ,-
--
-. 4 ,
.4,.4,
.4,
20
/
//
/0
00
0
, )
, ), )
, )
Java
10
public class test {
public static int size = 5;
public static void main(String[] args) {
int[][] x = new int[size][size];
for (int i=0; i
for (int j=0; j
if ((i+j)%2 == 0)
x[i][j] = 2;
if ((i+j)%3 == 0)
x[i][j] = 3;
}
x = a(x);
for (int i=0; i
for (int j=0; j
System.out.print(x[i][j] + " ");
System.out.println();
}
}
static int[][] a(int[][] x) {
int [][] y = new int[size][size];
for (int i=0; i
for (int j=0; j
y[j][size-1-i] = x[i][j];
return y;
}
}
SQL
product
pid pname
101
102
103
201
C
302
price
pid
pname
101
300
102
500
201
600
302
1000
505
1500
1.
!"
select * from product left outer join price on product.pid = price.pid
#$%&
5
'
2.
!"
select * from product right outer join price on product.pid = price.pid
#$%&
5
'
,
,,
, 5
55
5
!
Events
"# $ % &
Events
Event_Time User Action_Type Details
2014/08/22 08:05:11 User1 DML SELECT * FROM Customers
2014/08/22 08:07:13 sa DCL GRANT CREATE TABLE TO User1
'()*+,-./0123/04
SQL
4
5
08:00-17:00
678+9:
Customers
4;<"=>?@AB'(CD4
SQL
78E!F?
BETWEEN
GHI
8
J' (
sa
4KL !MD4
SQL
N O > ? P Q R D "S
Format
T
CAST
U
8
,
,,
, 3
33
3
# $ VWXYTZVWTJVW[XY] G % &
^ _ `a4
IP
XY
192.170.2.133
"ZVWb c
255.255.255.248
"de`af54ZVW4
gVWXYh i j
6
255.255.252.0
klZVWbcmnOo
133.120.0.0
k lVWp q l+ r 4ZVWjKlZ
VWsmnO+q_`aj
8
Jt u ^
IP
XY
192.15.156.205
"ZVWb c
255.255.255.224
"v w eZVW4g[X
Yh i j
6