ƮI(y)3ƪ
ڲMĕrԽԽնʹõ漰I(y)gZҪźܶѶеdzСČƮI(y)3ƪ҅bϣԎҪѡ
ƮI(y) ƪ1
1Ŀ
I(y)Փc`YϵҪh(hun)(ji)ĿߌW;Cό`ߌWČWdȤߌWľ͘I(y)ûAʹW˽ӋCϢđìF(xin)l(f)չMһIWĻՓ˽ӋCϢgİl(f)չáͬrҲB(yng)WՓ(lin)ϵHW֪RõHУB(yng)Wl(f)F(xin)}}ͽQ}ĶߌWHͨ^wĿķՓ`Yϣ얹̺Ͱl(f)չWՓ֪R_˼뷽ͻͨ^_cĿģ
1ӏ얹Փ֪Rl(f)F(xin)}\W֪R}ͽQ}
2呟ԼČmҹ
3˽⌍λӋCgđrrͰl(f)չǰ
4H텢cĿČHɹ˽ӋCI(y)ܛ_l(f)ľw̡
5ͨ^JR˽Լl(f)F(xin)ǰԼI(y)Ҏ(gu)
2λ
ڌWӋCƌWcgI(y)ҌĵĆλϺһܛ˾ ԓ˾һҌעڸ߶ITӖܛаl(f)ԃĸ¼gI(y)˾ijɆTɺWˆT́SybasešSunȇH˾YgˆTMš̄յȷSČI(y)_l(f)Ӗ(jng)˾ȫ_չڵИI(y)иܛ˲Ӗ˲I(y)
˾I(y)գ ITӖADPS˲ӖĿJAVAܛ_l(f)Ӗ/I(y)Ҏ(gu)ӖBI(y)ӖĿI(y)͑_l(f)n/ܛ_l(f)/Ŀ
ܛṩܛ_l(f)պYԴ
аl(f)ԃṩI(y)аl(f)ԃ
˾Ļ\I(y) C(chung)
3ݼ^
@Ό^҂ҪČ΄ǣAndroidƽ_\javaZJDBCgOracle(sh)(j)_l(f)һ֙CϵđܛӰUϵy(tng)
3.1Pg
Androidƽ_AndroidǻLinuxȺ˵IJϵy(tng)Google˾20xx115չ֙Cϵy(tng)ܛьӣsoftware stackܛBӣļܘҪ֞֡LinuxȺֻṩđܛtɸ˾_l(f)ֳJava
ORACLE(sh)(j)죺ORACLE ԸYԃZ(SQL)AĴPϵ(sh)(j)ͨv÷߉ZԲٿvҎ(gu)ɔ(sh)(j)ļĿǰеĿ͑/(CLIENT/SERVER)wϵYĔ(sh)(j)֮һ
JavaZԣJava ȡC++ĸ,(sh)(j)b, ă(yu)c,F(xin)˳ĺԺͱھSoķb ^ԵPʹaֻһξgȻ ͨ^ԷTֻҪͽ ڵ.OӋ͑Java ṩ˱һ㌦ͨ^^мʹøķ
Java ^PϵdžһķǶصģһ ֻһĸһJava ṩ Object ^PϵͬһõĘΣ Object Object (jng)ʹõ
JDBCgJDBCһNڈ(zh)SQLZJavaAPIApplicationProgrammingInterfaceóOӋӿڣһЩJavaZԾͽMJDBC锵(sh)(j)쑪_l(f)ˆT(sh)(j)ǰ__l(f)ˆTṩһN˜ʵđóOӋӿʹ_l(f)ˆTüJavaZԾĔ(sh)(j)쑪ó ΄շNҪõPg҂֮ǰ]ЌW^҂C++ZԺSQL SERVER(sh)(j)ĻA@ЩgijЩͨԣ҂WҲ°빦
wʩ^
3.2ӰUϵy(tng)
֪Ra(chn)}õ˺ܺõıoһ㲻F(xin)IĆ}˳ȥӰԺӰ֮ؼȥ@NrӰĵ䁾ͱ^ϢıOӋһϵy(tng)ӰI(y)ճˮ֮ͨ^͵䁽(jng)ͨ@I(y)Ϣ
1 ҪԓӰUӰıQTMember,ֻгɞԓĕT ԓӰY(Title)
2 ӰвڕُIһЩӰY(Title)ҫ@ˏԓӰYϵę ÿһӰƷжؐÿһݿؐQһƗlĿ(TitleCopy) 3 ͑ԭʼӰYϣTitleֻܱAҿͬrܶA (Reservation)͑UӰؐTitleCopy
4 κһ͑UϢRental횴nԱ㌢䁌͑UMu
ͨ^U꽛(jng)ԔՄ˽ԔĘI(y)յϢ
1 ÿһT횱ӛ䛵ϢT̖Id,ЕTľ̖Ψһ Name, QTJoin_date,ԼҪӛ䛵ϢסլַAddress, ڳcity, סլԒphone.
2 ӰƷ(Title)횱ӛ䛵Ϣ̖IdӰƷľ̖Ҳ
Ψһ}TitleӰƬfDescriptionrPriceϢ ratingNcategory, l(f)release_date.
3 ÿһӰؐTitleCopyиԵľ̖IdͬһӰɿ̖ؐ
ͬDzͬӰؐľ̖ܕ؏ӛǷѽ(jng)Ա TSr܉ԃؐYϵĮǰB(ti)(status)
4 ϵy(tng)STAijӰYǰAsUrgres_date 5 ÿһ헳Ҫӛbook_dateHw߀act_ret_date,^ڕrg(exp_ret_date)
I(y)߉F(xin)
1 ԃÑ(name)ԼÑ醵ӰY(title)ͽ醵(book_date)
2 ԃһӆӰYϵÑ(name)ӰY(title)(book_date)
ƮI(y) ƪ2
һĿģ
ҌWČI(y)ǕӋ˼ӏ|B(yng)^ĕӋIJ20xx.2.20-5.20@g̫ԭһҹ˾MˌI(y)gҪŬԼڌWУWՓ֪R`DMՓc`YϣعotJIkĹȡڌ@ΕrgҲҴWܳ䌍ÿD܇_l(f)^(q)Ȼ߀Ҫһ·̲ſԵλϢ°Ҏ(gu)zՓ֪RͬrҲҽ|ĸNrWôĺܶrҸm˺ܴ|M
˾śr
ڵĹ˾ɽͮxQ˾һȻͶYعɵ؟ι˾佛(jng)IǼҾľƷOӋa(chn)NۣҾOӋ҃bMܛ_l(f)ã(sh)aa(chn)Ʒ늡ᘼƷa(chn)ƷΣUƷúƷF䓲ĵl(f)ƵԃCеONۼUؔOһؔղLһ{ɂӋŤҵϕӋӋ
(jng)^
ӋӋͽȿƵĕӋ{CԞ{ӛϴWWՓڅ^(q)^(q)ԭʼ{C쾚Ҳ@NđB(ti)Һҕ˕Ӌѭh(hun)ĻʯӋ䛣ںӋ҇LԇƆεnjrֻϻؼanˣѹ˾ճ^ʹõĕӋI(y)JxӋڕϿԌWһЩyЎRƱl(f)Ʊ(lin)ȾҪr|Ķ˸̵ӡeԞJR߀ҪеĆΓ(j)°շTeÿPI(y)յĆΓ(j)ÈDbӆãܞӛÜʂ
ƺÑ{CMӛmfӛȥcСW؏˴Ĺ]һĺͼǺyεһeSùPͿ˻ƤͿ˾ÿһEӋƶȶЇҪ猑e(sh)־ҪütPMw؟˵Uڔ(sh)ֵ.ҲЇҪEһҪ㣬ܖ|ӛrҪÿһ䛼Q܁ytLĽJľͲܽYƽ˷ijҲжcR@I(y)rԇre˾Ϳ۷ֶ@PһI(y)ĎһI(y)Ժƶl(f)չӋ(j)
Ɔεӛ^̻˽˂źҪJYϕ֪RYһֹôһӋҪĵĸvÿһNyЎεĘʽʽԼʲôrʹ@N˻JRԺW͕đ
ġի@
@ΌMȡǷdzҪġڹЃH҂nόW֪Rhh҂ҪrgoԼ늣I(y)ĻAҲҪ،WIͬrڌHĹ}rҪՈ̡HͨҲǷdzҪһcc˴һTˇgҲһNIڽĹҲDzܺҕRϾҪM҂ҲҪRʽČÿһεĽ(jng)vһNe@NeպؔڹڌWϣ҂Ҫ@ЩFؔl(f)]Ķ_°빦ЧδĹҌWՓ֪R͌`(jng)đõHչʾҵĂ˃rֵrֵ錍F(xin)ҵǰŬ
ƮI(y) ƪ3
һĿ
1ͨ^،ʹҌг˽ʹXľCόWĽOӋcYȌI(y)֪RUI(y)֪R
2ͨ^`˽һ̵ČH\ԼOӋI(y)ˆTе
3Փ(lin)ϵHڌ`˽͌Wе¼gO²ϵđá
4˽⽨ʩ^еwʩ≦b
λλB
127ͨ^HݽBM˺d˾˲ֹ˾,ڽһӷ,11+1,ȥĕrܿՌ.Ŀǰڹ˾ʩT
ݼ^
Ҷİ@ʮČWļYĕr20xx127գ˺d˾˲ֹ˾_ʼҵČȫzҸWw˼ȶR(zhn)һKԇʯzܷWãWՓ֪R\õ`ȥ@PϵҌܷ@C(zhn)ҲҽĵPIҝMѶ־ٷְٵͶ뵽֮ڌ^ի@MM@
|ĺÉȌYİȫҲYrкܴӰʩ҂회ʩ|'ҕ
һ . I(y)ʂ䣺
ǰģȵsP䓽ϵɃ(jng)z䓽ˮ|KǷ|
ʹľģrˮʹģģ߿ڸˮƽsٷ]
. F(xin)裺
ڷֹƷŕrϵđʩŵĬF(xin)ԭϺϱȑcƷŵıһ
1 (j)ϱȴ_ÿPۣN܇vքe̶ˮɰʯQ˜Ϻˮʑ(jng)y
r{ϱˮ_ˮʴ_Ҫ^Q
2 bһbʯӣbˮbɰӣӓϕrcˮһ蓽ӄpˮ珊ȣr
۠(j)ÿPAӹbСbȣϴˣÕrcּͬrҺÿPcˮͬr딇C衣
3 rg̕rg(j)ʩҎ(gu)Ҫ_ӄrrgmL
4 _ʼrʩλܼgTLMPˆTP̮ԵMb
zǷϱ֪ͨҪ(jng){MД
. Ʒŵ|zҪ
1. ܇վǰÿ܇횽(jng)|zTzԺϸܺC̮ȳzÿ܇һΣ܇ؙzÿһϱÿ첻Сһ
2. F(xin)ȡӕrԔ܇ж1/43/4ǰĻȡԇB(yng)oɹpͬCJ
3. ܇жǰóF(xin)xͳF(xin)
F(xin)ûʩ
1. ͻǰȰу϶ˮĹܵó_坍ܵĿȻ϶ȼcϱͬˮɰ{12ˮɰ{ܵ_ʼͻ
2. Bm(x)I(y)r轵ͱٶ͕rДr費ֹͣ~Ƭr跴DDDһrgD^m(x)
3. ;ͣЪrg^20ܵ^Lrÿ5_һСܵ^̕rɲÿ5D23гʹ܃ȻӣֹˮxLrgͣã^45犣ظ̮Сrˌıúݔ
4. hڝuܡ
5. ڸߜؼ(ji)ÝݴwܵMнԽģض
. һҪ
1. ԵɃA߶Ȳó^2糬^2וr횲ȡʩ
2. QYr睲߶ȳ^3וrôͲۻģ_TӶڣ
3. rֶηMÿӲ߶ȑ(j)Yc䓽ܛQһӸ߶ȞʽòLȵ1.25^500mmƽķӺȞ200mm
4. ʹòʽcҪcƄMУz©ƄgӰð돽1.5һ300~400mmvһӕrӻ50mmɌgĽӿpƽƄgܱCƽ帲w߅
5. Bm(x)MgЪrgMsǰӻ֮ǰΌӻꮅgЪLrgˮƷNl_һ 㳬^2Сrʩp̎
6. rɌ˽(jng)^ģ䓽AAПoλ׃λrl(f)F(xin)}ಢѝĻǰꮅ
.
1. ǰcӻY̎ڵϾ50mmcϱͬˮɰ{ɰ{FPģ϶ֱӵģȡ
2. ӝvÿӝȿ500mmcɢѭh(hun)MBm(x)MӰ|䓽AvҪSrôģ
3. 3֮ȣֱ»ҝ^3וrȡʩôͰģ_TӶbб۷ֶΝÿθ߶Ȳó^2MÿλTӶģ]ܣù
4. ӻһΝꮅʩproǰ呪ñ档wrꮅͣЪ1~15Hʹ@ó^m(x)
5. ꮅSrĴ䓽λ
6. ӝÿӺȲó^300mm
.
1. Θǰ呪ͬrȝ(j)߷ӝA_ǰλÕrcĻһSAβBm(x)ǰM
2. (ji)c䓽^ܕr̎rСʯͬȵȼĻСֱӰv
3. ǰ坲̓䁺ȑԴڰƽֱvעⲻƄӘ־ԿƻȡvꮅùγϰĨƽ档
4. ʩpOãǰʩpڴ1/3ʩp摪cS洹ֱʩfƽڰĶ߅κλ
aʩpľ塢䓽zW(wng)
bʩp̎^m(x)ǰʩp摪ëˮౡĤʯӣˮ_ϴɃųeˮȝһˮ{ɷͬˮɰ{Ȼ^m(x)
. B(yng)o
1. ꮅ12СrԃȼԸwˮB(yng)o
2. ˮB(yng)oþӄп?ji)BҪĻС14ŏ_1.2Mpa֮ǰϲȻʩģB(yng)o2ģסˮB(yng)oԴ_Y汣֝B(ti)ÿ՝ˮΔ(sh)ֻܱ̎ĝ
. ԇ
cҎ(gu)ҪSCȡÿͿ?ji)Bԇԇ
ʮ.|z
շֳպͬF(xin)Yաģ^|MгȈɺęzա
1.Ȅ֙zհʩˮ΄֙zǰcO(jin)λһ֙z_z(sh)
2.gCYϣλṩYϱ֪ͨϸCȻAӋ
2.ʩF(xin)YϣF(xin)B(yng)ԇKȈ漰Ƚy(tng)Ӌuӛ?ji)Bԇ棻ʩӛʩp[AzӛA\ݔB(yng)o؟οz|ӛ
3.^|Y^Їȱݲr̎M̎ ʩ^гҊ|ֹͨʩ£
1. C
(1)a(chn)ԭ:v©ģp϶^ˮ{ʧ䓽^ܻʯ^
(2)Aʩ:Ҏ(gu)ʹúƄv;ͣЪٝvrfӿpҪСvģ尲bǰģ漰ģƴp̎{ʹӿpӿpȳ^2.5mm ȡʩ^ܕrxʯ
2.
(1)a(chn)ԭ:ģ治⻬ģ©Ϳx(2)Aʩ: ģ呪ƽ⻬bǰҪ{ɃMͿxvǰģҪˮ
3. ¶
(1)a(chn)ԭ:oӉ|K䓽oNģ壻v(2)Aʩ:䓽|KȼRF߶ҪOӋҎ(gu)ıoӺ|Kgm䓽ֱ^h |KgЩʹ䓽ؓ϶Ȝpʹv횴КȫųƄӡ
4.
(1)a(chn)ԭ:䓽^ܵIJλס©(2)Aʩ: 䓽^ܵIJλ^ִsСvĺҎ(gu)ʹv
5. p϶A
(1)a(chn)ԭ:ʩp]аҎ(gu)M͝{e^ݰ_(2)Aʩ:ǰ^ʩpݰ_Ȳλzsɰľм
6. ȱ
(1)a(chn)ԭ:Ͷϲʴ_費F(xin)ֲȵģ^ģ巽
(2)Aʩ:ָ˱O(jin)ͶͶӋʴ_rgҪģڻܱC漰DzڲģܓpĕrܲrǑԱo
7. ײ
(1)a(chn)ԭ:ģ¿ڿp϶©ˮ{ǰ]ȝ50mm ͬȵȼˮɰ{
(2)Aʩ:ģp϶ȳ^2.5mm eҪֹȰ_ǰȝ50 ͬȵȼˮɰ{
8. Yc̎^ߴƫ^
(1)a(chn)ԭ:^ģ儂ȲѰb^ģژnjģ尲bAȱ|ƺͱO(jin)
(2)Aʩ:bģǰȰb^ģzߴֱҪSgģ
9. ǰƽȲ
(1)a(chn)ԭ:δOF(xin)ȿcv]ϰγĨƽбˮλ]зϳߴģ߶λδ_K˺Ͳ
(2)Aʩ:ǰðcv摪ᳫʹϰγĨƽҪʹƽֱȷҪģ߶λ_1.2MPa Sڻϲ
10. ASλݿλ
(1)a(chn)ԭ:ģ֧β̶ʩrܵײ(2)Aʩ:Aģ֧ϵy(tng)ҪԳֿ]vݿוrҪMЏ;z飬rmrݿ߅ϣҪA˨Б䓼̶ܹ ҪrΝ
11. 治Ҏ(gu)tѿp
(1)a(chn)ԭ:һˮB(yng)r㣬ˮl(f)^زտs]Ј(zh)PҎ(gu)
(2)Aʩ:KMˮB(yng)ߜػҪݴȸw֘^õĝrgմweʩPҎ(gu)
12. 䓽oӉ|K
(1)a(chn)ԭ:|Kȵژ䓽Ǽܕr_^(2)Aʩ:|KďȲõژȣܵ䓽Õrě_˵䓽r|KБ䓽䓽z|KꮅˮB(yng)o ՄՄѿp} ѿpDzɱ^ѿpDZW|Qģк̶ǿԿƵк̶ȵĘ˜Ǹ(j)ʹ×lQġĽY;ҪdҪʹҪSѿpȞ0.1mm(j)ԇcͻĽ(jng)Ō0.2mmY̎ĭh(hun)oӺȝMOӋҪog|䓽ѿpȿɷŌ0.4mmڝ⼰О0.3mmںˮɝО0.15mm䓽혽ѿpк̶ȸ̎aѿpǰȫ濼]c֮PĸNӰмоa(chn)ѿpԭѿpǷѽ(jng)(wn)̎ڰl(f)չ^̣ҪӋԓѿpl(f)չKB(ti) ѿpĬF(xin){飨ѿpͺ͌ȣПo©ˮ䓽Pga(chn)ѿpĽ(jng)^l(f)rg^̣ʩӛ䛵ęz飻(j)@оz阋ďd{飻Իԇ䓽{飨䓽λá(sh)ПoPgػ{dԇԇѿp̎б̎䷨{ͽYa
1.̎ͿĨͱNa
ͿĨm÷ǝ{yԹļ\ѿpδ_䓽İl(f)zѿp©ˮĿpsѿpԼٻӵѿpNaĤˮƬmڴe©ˮCȻ״_w©ˮλ׃οpķB©
2.䷨
aֱѿpһÁa^ѿp0.3mmI(y)ΣMõС0.3mm^\ѿpѿpгù{y_ЧѿpԼСҎ(gu)ģѿpĺ̎ɲȡ_ͲȻ̎
3.{
ôˑ÷Vļѿpѿpm̎Ч
4.Ya
da(chn)ѿpѿpLrg̎팧µĻ;Խ͡ɵѿpӰ푽YȿɲȡYaa^aAȻѿp̎Чęzaԇ@ȡԇˮԇԇ
ƮI(y)桿P£
ƮI(y)棨x12ƪ05-16
xƮI(y)11ƪ05-22
ƮI(y)棨x10ƪ05-15
ƮI(y)b09-10
ƮI(y)b15ƪ04-28
ʽ -08-12
濂Y -07-08
淶 -08-28
I(y) -10-13
-06-10