ƷƮI(y)3ƪ
ڲMĕr;ԽԽɞһNda(chn)I(y)Ҋ^ĈʲôӵСռČƮI(y)3ƪgӭxcղ
ƮI(y) ƪ1
һĿģ
ҌWČI(y)ǕӋ˼ӏ|B(yng)^ĕӋIJ20xx.2.20-5.20@g̫ԭһҹ˾MˌI(y)gҪŬԼڌWУWՓ֪R`DMՓc`YعotˣJIkĹڌ@Ε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) ƪ2
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õHB(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́SybaseSunȇ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) ƪ3
҂@WڵǰǮI(y)rg֮ǰ҂քeMJRa(chn)ʩc팍Ӗ@ǮI(y)҂ҕ@Ό@҂УgһЌWУMČ҂I(y)һ֞˽MҾڵڰ˽MкώIώfĹؿԼͬWĽBڽ||^(q)l(wi)ġCϘǵһf칤όgҽ(jng)ώ(lin)ϵÿܶл؈MչĵώğĵPĺָ҂gWSnϛ]е֪RڌЮõط҂rָώڌ҂еի@ܴԺĹˈԌĻA
@ΌҵI(y)кܴĎ֮ǰҌ^uY^ܽYĸߌ^·@Όfӹ̸죬߀ǵһ@֪RһܺõaҏЌW˺֪ܶRҌn֪R˸MһļҵԺ(chung)˸V韵Ŀg
ڌҽ(jng)D͈Dһ_ʼݼӹ̵ʩһ[ͨ(jng)^ҵŬһںҾܿôһ䌍߀ǺܺεֻҪʩļ(ji)
F(xin)ڰڹ،W֪RεĔһ£
uYӹ̷飺
ĽYCl(f)ӹ̿Է֞pСüӹ̷Yӹ̷Ͷӹ̷pСҪͨ^YڻӴY팍F(xin)һ㑪ڴĿӹYļӹ̷wܵ䓽ӡ䓽W(wng)ˮɰ{Ӽӹ̷YwԵĉ{ӹ̷OȦӹ̷Y䓽ӹ̷ͨ^OͿܵõOw@ЩʩڶӵĴuYýӹǽöؿwϵһĵĿڏҵĵƉĺĵڶĿ֓m(x)ĵ_ɱCﰲȵȫڵ
ĽYӹ̷ρvӹʩҪӹ̷ȼӹ̷A剦ӹ̷ӹ̷һYϴuYČӔ(sh)bĽYҪڽӲͬ(sh)ĘȦԼCȦͿwf(xi)ͬU@Nһ㲻ռ҃ȽeסլסӰ^СӰ^ȼӹ̷ԭͬӹ̷ҲҪOȦUҪrԭЉwOwԭwȼӹ̷׃һmڹeRֽA剦ӹ̷ڼӹԭЉwĻA߿Ŀǰõ䓽W(wng)ˮɰ{Ӽӹ̷Ҫӹ̉wĆpO䓽W(wng)^̽Yȷ䓽W(wng)cǰwB
OȦ͘
1OȦ
ƤTƤg300mmҲϴuģ(sh)tȦ߶ȡ300mmϿҎ(gu)Ҫ
vȡ412ϿҎ(gu)Ҫ
Ҏ(gu)ȡ6@250wtÿ250mmډϴһ@ӼƉˉwwʩҲyüӴֱgķ乿12@600鱣CƤvλډɂȼӦ6@300ĸ䓽ҊDһТ̖䓽
4vM̎̎
ڙMϣcvȦvλ3050mmMȦv^ˮƽLȞ30dcvȦv13Ӳˮɰ{
2O
aycǣһcԭЉwĿɿBʹδ^ԭИǰ@cքeU
1cԭЉwB
ڃ≦vM̎ݹս̲̎NIcYʹ¼Әcԭ≦γw
2ǰ
鱣Cڸ߶ȷһw횴^һӘǰw£
һӘǰ̎vλãژǰ@30AİԴוr_ÿ׃ȴ14䓽¾¶550mmLȣúC30ӲƽעrMܳӯԭȣúcv픲^Әǰ
3ΪA²҃ȵ500mmҎ(gu)7324l
_Twӽɰ{Ӽӹ
䓽ɰ{ӼӹwÆpӹ
1ˇҪ
ɰ{M10
䓽W(wng)ɰ{Ӻ35mm䓽ⱣoӺȲС10mm䓽W(wng)ƬcwĿ϶С5mm
䓽W(wng).䓽ֱ6W(wng)ߴ猍ĉ300*300mmն200*200mm
Ӳ6L^p6SδL^g600mmSδg900mm÷β
䓽W(wng)ęM䓽Tڕrӹˌ䓽봰^pӹˌɂ䓽ڶ]ϡ
2ʩ
ԭb菳@ײˮ_ˢO䓽W(wng)O^ˮ桪Ĩˮɰ{B(yng)o
3ʩҪc
ԭ港gؕrɢ13ˮɰ{ĨԭɄӵĹpɰ{
@˳^λã@@ֱS^2mm^ֱ˞^ֱ2˞100mm^ˮɰ{
O䓽W(wng)rQ䓽
Ĩˮɰ{ǰډˣˮ{һٷĨÿӺȲ^15mm
ӑˮB(yng)o
ԭдļӹ
ļӹݵļӹһҪһh(hun)(ji)
ʩ
Ҫʂ֧ܣڴÿ20ͳߞ180Ȟ80ֵĿն֧ܵijߴL鉦p50Ȟ80֡ߞ180ǰ֧ܷ뉦ն֧ǿĵԾoǰ䓽Mȥ֧ģͿԝע^һǝעĻ@Ǵļӹ̵ķ
ĕrg^ĺܿѽһDһµĕrg^ȥ@ΌҌW˺֪ܶRի@ܴĵwܶࡣ
Ҷ҂Wĕr̫һ҂ֻͣڽʩϣ҂ҪMWc֪R@εfӹ̹̌ҌW˲һӵ֪RҌ@֪R˳˽ʹԺ@ĹںݽһuYķӺ͌һϷMмӹǃɂͬʩˇһ_ʼ߀Ԟ@ܺǴuYĕr֪ǘS֪Rͼ(ji)҂]Ҋ^ģҪ҂ȥWյ@εČ@Ŀհҕúӛס@Όģ҂ҪW߀кܶˇ҂ҪúÌWԼ֪R䌍ԺҵĹˈԌĻA
ڽMի@ܴǰĎ״Όֻcʩ߀ā]ЅcM@εČĿʩgTʩҵĵλҪÿܵĿֻҺĿ(jng)҂ɂȥڹҪʩṩgָͽMʩʩMһ_ʼҲȥʩڌWУmȻ_O@TṇM빤غͳF(xin)}һϵеʩM˽焂_ʼҲ˽ڎָͨ^ʩMOӋx˽Ҏ(gu)tǝuMʽĭh(hun)h(hun)˳@һҎ(gu)tJąĿl(f)ÿһʩMָҔMʩָ(jng)^H팍`@һҎ(gu)tܿ챻@ΌҜʂʩMָh]б̎ʩɼ{fҵָhڹMȵЧʺ|_˳̶ֻҕ|ҕʩM]ȫMȺ|ҪR^Mӏ呟͌W@߀д(jng)^@ΌҌʩM˺ܺõ@ԺõȥcMˈԌĻA
߀WôȥYϣڎYφTYϵ^ҌWôȥYʲôrʲôӵYʲô˺ֵ@ΌҌWȥYҰl(f)F(xin)Yһܲ£@Щǰ]н|^
ڹό@һҸ|һcǰȫ}ڹĿһTԼҪܺõĎ^鹤صİȫ}ǺҪģ҂(jng)MаȫڹؿYһЩȫ}һM빤ر횱o^f횴ȫñڶͬҪo_£ڹײȵ_ּߵĕrһҪעⲻҪȿЕrz]Ƭ̶ׄ@һcҲǽ(jng)_ּϹĹ˂ע߿Չeͬһֱ涼ڹĕr@һcڰȫҲǶһעǹеİȫڹ҂һҪעⰲȫҪcྀeˣ߀оDzҪyӺ́y늾lһҪעⰲbֹܵ늾ڹһҪΣUĵطʾƣ@һcö؞ʡXͲ䌍@cҲҪ鹤ص܇ľ@cɺҕ
҂ҪI(y)@Ҳ҂ĮI(y)҂һΌ҂֮ǰҲ^ܶεČ䌍J錍҂һܺõęCJڌWУWĶՓ֪R߀]`һgҪܸߵČI(y)ǙzWˮƽÉĵһ^ڌ҂ܰl(f)F(xin)ܶĆ}ͨ^l(f)F(xin)}ͽQ}^һܺõČW^̣@҂܌W֪Rͼ֪R҂ĮI(y)rg̫ϣWУԺ܌҂I(y)ŮI(y)ĕrgL
Ʈ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
-06-10
y -08-04
Ƶꌍ -06-01
ĸʽ -10-03
ʽ -08-12