103年 銀行招考、金融雇員 不分職等 合作金庫-開放系統程式設計人員 程式設計(以JAVA等語言為主)、系統分析、資料結構及網路管理 試卷

pdf
365.15 KB
2 頁
youbin
侵權投訴
加載中. ..
PDF

 103 








F2911




(
JAVA
C/C++
SQL



)

 

!"#$%&'()
!"#$%&'()!"#$%&'()
!"#$%&'()



________________

 !"#$%&'
()*+,"-./01
2345678!9:;<=>?;@;A/B3
25
/0
=>?;CDEFGHIJKLIMNO
&PQR4STUVW
XYZ[-]/

0



 !"#$%&&apos;( )
 !"#$%&&apos;( ) !"#$%&&apos;( )
 !"#$%&&apos;( )*
**
*
(+,-./0123456
+,-./0123456+,-./0123456
+,-./0123456
(
"^_`abcdefcdghijfkgh
)
l " m
nopqrst(Muvwx"yz<{L.|}~M7JD
DYZ]
10
/rZ{L.|}&apos;()Zuv0
789
789789
789:
::
:;89<=>?@A45
;89<=>?@A45;89<=>?@A45
;89<=>?@A45*
**
*1
*+
*+*+
* +
 

JAVA

“printArgs”

“main”

“printArgs”
  ! "#
9
$%

&&apos;
C
()*
+,
”(pointer)
+-.
“for”
+-/ 0 +-1 2 *34
56789:;<=>*
12
?@ A
(
BC&apos;
+,
D
“for”
EF
=@AGH$
)
"#
8
$%
int main(void)
{
int I,j,k,num[2][3][2]={1,3,5,7,9,0,2,4,6,8,10,11};
int *ptr;
printf(“n”);
return 0;}
}
9I J K L M N O P Q R S T U V W
Banks
.
Orders
X
Funds
Y 9?Z
(Table)
[
(schema)
$] ^ _ #
8
$%
Banks(no, name, address)//
`
(
`ab. c .d e
)
Orders(no, id, quantity)//
f g
(
`ab.J K ab.g h<
)
Funds(id,fundname, price)//
J K
(
J K ab.J K c .i j
)
k k l m n o p q
(attribute)
7 Z*r
(primary key)
s
Orders
Zt`ab/
J K abu ?v w r
(foreign key)
$] x y
Banks
ZX
Funds
Zo r "
z &apos; 
(1)
&apos;
SQL
+-{ | } J K R S
J K ab
101
.J K c ~ +< .
ij
88”
Funds
Z "
(2)
&apos;
Funds
o i j
(price)
J ` J K s&apos;
SQL
+-
t`ab.` c / J K
"
BC&apos;
+,
D
“for”
EF= @ A G H $"
class VarTest
{ public void printArgs(
k x < k
)
{
8*<j
}}
public class VarArgs
{ public static void main(String args[])
{ VarTest vt = new VarTest();
vt.printArgs("receive parameter first ", 1, 2);
System.out.println("######");
vt.printArgs("receive parameter second",15, 14, 13);}}
input:receive parameter first
get 2 parameters
args[0]=1
args[1]=2
######
input:receive parameter second
get 3 parameters
args[0]=15
args[1]=14
args[2]=13
*,
*,*,
* ,
 
 o C
(protocols)
 ¡ ¢ x £ ¤
(Internet
Reference Model)
$] ¥ p ¡ ¦ §
(layer)
oC¨
(1) 802.11 (Wi-Fi)
Wireless Fidelity
"#
2
$%
(2) TCP
Transmission Control Protocol
"#
2
$%
(3) FTP
File Transfer Protocol
"#
2
$%
(4) IP
Internet Protocol
"#
2
$%
&© ª 2 « ¬
(intruder)
&apos;
IP Spoofing (IP
® ¯
)
3 ° ± ² ¢ &apos;³
´µ¶·I
IP
he ¹ º ª » 
(1)
¼ ½
IP
®¯o¾µ¨#
4
$%
(2)
¼ 2 « ¬ * ¿ ÀÁ ¨#
4
$%
9I Â Ã Ä Å > Æ Ç tÈ
(subnet)
&apos;ªÉÊn¢©C¼È
*
IP
e<YË¡ÊÌÆÇ
4
Í
“C
Î
(Class C)
*ϤЪÑÒ
IP
h
e
188.88.8.0
"
(1)
¼ÈÓÔÆo
“IP
eÕÖ
× 7  ¨#
3
$%
(2)
¼ È he
(subnet address) “a.b.c.d/x”
Á 7 Z! ¨#
3
$%
(3)
7ÄÅØ×ÙwÚÛÜ| *ÝC
IP
he < Þ ß
1250
?à ¼ È
Ϥáâãäåæ¨#
3
$%
*
* *
* -
--
-
 tP ç o 
?é ê o Å ë ç ª ì É ¦ 9?í q î ï ð ñ *"#
10
$%
&
(a)
òç ª o ó ð ñ ô Å ë 3µ
structured method
õ
DFD
ö×÷ÅÀ
structure chart
"#
10
$%
(b)
&apos;ø
ùúûüÄ
ý þ ç *R S ó Àõ
Å À"#
5
$%
*
* *
* .
..
.
 tP R S Å o 
õ r j 
AVL-tree
"#
10
$%
16, 22, 25, 11, 15, 8, 31, 38, 27, 45
&
(a)
ô
(1
?
Stack)
ª
Infix
Postfix
o µ "#
10
$%
(b)
õ
Infix: A+B×(C-D/E)+F×G

Postfix
"#
5
$%
收藏 ⬇️ 下載