加載中. ..
PDF
100 ( )
(
)
96601
(
)
________________
(
)
!"#$%&'
()*+, -#./01
234567 89:;03<=>46>>?:
30
: @ :
2
0 A /
60
0BC<D
>?:
2
: @ :
20
0 A /
40
0B1
>?:EF
2B
GHIJ '>KLMN O#PQRST #./01
D>?:EFUVWXHYZ[HIJ
]'^_`4abcd
efTghi.Q0
1
j)klmno;p[/qr s#ktKuv w#xyz{|}~|1
!"#$%&'()*+,-.
!"#$%&'()*+,-. !"#$%&'()*+,-.
!"#$%&'()*+,-./
//
/01234
0123401234
01234/
//
/567-.8
567-.8567-.8
567-.8/
//
/9 : ;
9:;9:;
9:;
10
<
<<
<=
==
=
%&'>?@ABCDE9FGHIJK
%&'>?@ABCDE9FGHIJK%&'>?@ABCDE9FGHIJK
%&'>?@ABCDE9FGHIJKL
LL
L
M N O
M N OM N O
M N O
(
P
PP
P
)
Q R S
Q R SQ R S
Q R S /
//
/TRS89:UV<%&
TRS89:UV<%&TRS89:UV<%&
TRS89:UV<%&L
LL
L
! " #
! " # ! " #
! " #
30
#
##
#
$ #
$ #$ #
$ #
2
%
%%
%
3
1.
SQL Injection
3
2. Android
!
"
#$
!
%
&'
()
C# C++ JAVA J#
2
3.Google
*+
()
Android
!
"
#
,
-
.
Visual Studio Eclipse xcode UltraEdit
2
4.
./
!
"
#
()
01
2
Model
3
Controller
3
View
4
56
#
MCV MVC CVM Prototype
4
5.
7
89
:;
:<
!
"
#
(Rich Internet Application)
=
>?
,
-
Sliverlight Flex HTML 5 JavaScript
4
6.
@
C
&'
BA
CD
EF
?
G
H I
KJ
L
printf(“%4dn”, 3); printf(“%4dn”, 2); printf(“%4dn”, 1);
for (int i= 3; i > 0; i--) printf(“%4dn”, i);
for (int i= 0; i < 3; i++) printf(“%4dn”, (3 – i));
printf(“%4d%4d%4d”, 3, 2, 1);
3
7.
@
C
&'
BA
if
MN
#
AND
OP
(&&)
Q
R
S
T U
VW
X
Y
A
X
YZ
Q
[
]
^
_
`aJ
b
[
c
^
_
`aJ
b
[
c
^
_
d
J
b
[
c
^
_
3
8.
@
C
&'
BA
^
_ e
"
# f
int i = 0; for (i = 0; i < 10; i++) { } printf(“%d”, i);
gh
G
CD
EF
.
8 9 10 11
3
9.
@
C
&'
BA
^
_ e
"
# f
int a = 5, b = 0, c = 6; a = (a = b) && (c = b);
gh
a, b, c
i
j
k
.
a = 5, b = 0, c = 6; a = 0, b = 0, c = 0; a = 0, b = 0, c = 6; a = 1, b = 0, c = 0;
l
1
m
10.
n
o
pq
r
s
t
uv
wx
yz
{|
}~
CDBC JDBC ODBC ADO.net
l
2
m
11.
n
pq
wx
y
q
|
q
l
4
m
12.
n
o
pq
s
MS SQL Server
|
wx
y
¡¢
£
¤
windows
¥
¡¢
|
¦§
¨©
ª
«
¨¬
©
SQL Server Browser
®
windows
¯°
±
²
3
13.
@
C
&'
A
^
_ e
"
# f
printf(“%4d%4d%4d”,1,2,3);
T
CD
³
´
EF
( _
µ ¶
·
¸
)
123 1_ _ _ 2 _ _ _ 3 _ _ _ 1 _ _ _ 2 _ _ _ 3 1 _ _ _ 2 _ _ _ 3 _ _ _
4
14.
7
¹
º»
¼
SUM COUNT AVG DISTINCT
2
15.
½
b
»
¼¾
¿À
5Á
YÂ
D
Ã
Ä
¼
SUM COUNT AVG DISTINCT
2
16.
@
C
&'
"
#
4
5
Å
A
stdlib.h
ÆÇ
ÈÉ
Ê
½
J
»
¼
system log atoi rand
3
17.
@
C
&'
4
5
Å
A
1
b
byte
Ë
Ì
·Í
T
!
³
´
Î
Ï
Ã
Ð
int long char bool
2
18.
YÂ
Å
A
½
J
bÑ
Ò
Ó
¾
e
ÔÕ
Ö×
TOP DISTINCT SUM INNER JOIN
4
19.
Ø Ù
ÚÛ
JAVA
"
#
Eclipse NetBean Jbuilder Visual Studio 2010
2
20.
Å
A
¾
e
Ü
Ý
Þß
à
!
áâ
Ý
ã
ä
Table View Database Stored Procedure
4
21.
Å
A
åæ
"
#
4
5ç
èé
êë
»
¼ì
!
í
î
E
ï
Table View Database Stored Procedure
1
22.
. ð
ñ
SQL
òó
&Ù
DECLARE @strA varchar(30); DECLARE @strA;
@strA varchar(30); SET @strA = ‘30’;
4
23.
ô
4
TableA
Q
(
Úõ
3
ö
÷
3
øõ
)
A
ù
SQL
YÂ
&Ù
Q ú
SELECT * FROM TableA SELECT * FROM TableA ORDER BY 1 DESC
SELECT * FROM TableA ORDER BY
Úõ
DESC
SELECT * FROM TableA ORDER BY 0 DESC
1
24.
µû
`ü
ð
ýþ
T ÿ
Õ
”
J
Ä
Å
A
Æ
”
`aJ
ð
ýþ
`
ð
ýþ
`
I
ð
ýþ
BCNF
1
25.
gh
JAVA
%
A
¾
e
Ý
¼
(
b
¼
Î
Ï
)
òó
b
Q
Ý
L
÷
å
Ù
Overload Override Virtual Overhead
2
26. C++
Å
A
»
¼
A
à
!
³
´Ñ
Ò
Ó
Overload Override Virtual Overhead
1
27. VB
$
!
½
J
b
Ó
Ã
òó
Q
k
»
¼
Sub Function void null
4
28.
"
#
N
A
G
!
"
÷
¾
7
DLL COM OLE EXE
3
29.
7
Stored Procedure
R
#
$%
YÂ
&Ù
åæ
"
#
4
5ç
à
!
ØÙ
¾
e
&
4
30.
?
G
H I
7
Ý
J
'
MS SQL Server MySQL Oracle Google BigTable
&
&&
&
' " #( #
' " #( #' " #( #
' " #( #
$ ( #
$(#$(#
$(#
20
%
%%
%
#
# #
#
!
20
"#
void swap(int x, int y) {
int temp = x;
x = y;
y = temp;
}
void main(void) {
int x = 3, y = 5;
swap(x, y)
printf(“x=%d, y=%d”, x, y);
}
#
# #
#
$%& ' (
DDL
) * + , - . /0 1 20 1 3 4 56 7 58 9 5": 5; < = >
?@2?456 7 5A B 5C D 5E F > G 0 1 3 4 H? 4 I J K L M
NOPJKQRSTUVWXUVYZ !
10
"#
$[& ] ^ _ ` 8 9 a b c P d 1 I
SQL
) * !
10
"#