ƮIƪ
S˂|epصĵλͬNĈвͬ;һ ӰYаRͰlСռČƮI5ƪϣ
ƮI ƪ1
1Ŀ
IՓc`YϵҪhĿߌW;Cό`ߌWČWdȤߌWľ͘IûAʹW˽ӋCϢđìFlչMһIWĻՓ˽ӋCϢgİlչͬrҲBWՓϵHW֪RõHBWlF}}ͽQ}ĶߌWHͨ^wĿķՓ`Y얹̺ͰlչWՓ֪R_˼뷽ͻͨ^_cĿģ
1ӏ얹Փ֪RlF}\W֪R}ͽQ}
2呟ԼČmҹ
3˽⌍λӋCgđrrͰlչǰ
4H텢cĿČHɹ˽ӋCIܛ_lľw
5ͨ^JR˽ԼlFǰԼ.IҎ
2λ
ڌWӋCƌWcgIҌĵĆλϺһܛ˾ ԓ˾һҌעڸ߶ITӖܛаlԃĸ¼gI˾ijɆTɺWˆT́SybaseSunȇH˾YgˆTM̄յȷSČI_lӖ˾ȫ_չڵИIиܛ˲Ӗ˲I
˾Iգ ITӖADPS˲ӖĿJAVAܛ_lӖ/IҎӖBIӖĿI͑_ln/ܛ_l/Ŀ
ܛṩܛ_lպYԴ
аlԃṩIаlԃ
˾Ļ\I C
3ݼ^
@Ό^҂ҪČ΄ǣAndroidƽ_\javaZJDBCgOracle_lһ֙CϵđܛӰUϵy
3.1Pg
Androidƽ_AndroidǻLinuxȺ˵IJϵyGoogle˾20xx115չ֙Cϵyܛьӣsoftware stackܛBӣļܘҪ֞LinuxȺֻṩđܛtɸ˾_lֳJava
ORACLE죺ORACLE ԸYԃZ(SQL)AĴPϵͨv÷߉ZԲٿvҎɔļĿǰеĿ͑/(CLIENT/SERVER)wϵYĔ֮һ
JavaZԣJava ȡC++ĸ,b, ăc,F˳ĺԺͱھSoķb ^ԵPʹaֻһξgȻ ͨ^ԷTֻҪͽ ڵOӋ͑Java ṩ˱һ㌦ͨ^^мʹøķ
Java ^PϵdžһķǶصһ ֻһĸһJava ṩ Object ^PϵͬһõĘ Object Object ʹõ
JDBCgJDBCһNڈSQLZJavaAPIApplicationProgrammingInterfaceóOӋӿڣһЩJavaZԾͽMJDBC锵쑪_lˆTǰ__lˆTṩһN˜ʵđóOӋӿʹ_lˆTüJavaZԾĔ쑪ó ΄շNҪõPg҂֮ǰ]ЌW^҂C++ZԺSQL SERVERĻA@ЩgijЩͨ҂WҲ°빦
wʩ^
3.2ӰUϵy
֪Ra}õ˺ܺõıoһ㲻FIĆ}˳ȥӰԺӰ֮ؼȥ@NrӰĵ䁾ͱ^ϢıOӋһϵyӰIճˮ֮ͨ^͵䁽ͨ@IϢ
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꽛ԔՄ˽ԔĘIյϢ
1 ÿһT횱ӛ䛵ϢT̖Id,ЕTľ̖Ψһ Name, QTJoin_date,ԼҪӛ䛵ϢסլַAddress, ڳcity, סլԒphone.
2 ӰƷ(Title)횱ӛ䛵Ϣ̖IdӰƷľ̖Ҳ
Ψһ}TitleӰƬfDescriptionrPriceϢ ratingNcategory, lrelease_date.
3 ÿһӰؐTitleCopyиԵľ̖IdͬһӰɿ̖ؐ
ͬDzͬӰؐľ̖ܕ؏ӛǷѽԱ TSr܉ԃؐYϵĮǰB(status)
4 ϵySTAijӰYǰAsUrgres_date 5 ÿһ헳Ҫӛbook_dateHw߀act_ret_date,^ڕrg(exp_ret_date)
I߉F
1 ԃÑ(name)ԼÑ醵ӰY(title)ͽ醵(book_date)
2 ԃһӆӰYϵÑ(name)ӰY(title)(book_date)
ƮI ƪ2
һĿģ
ҌWČIǕӋ˼ӏ|B^ĕӋIJ20xx220520@g̫ԭһҹ˾MˌIgҪŬԼڌWУWՓ֪R`DMՓc`YعotJIkĹڌ@ΕrgҲҴWܳ䌍ÿD܇_l^Ȼ߀Ҫһ·̲ſԵλϢ°ҎzՓ֪RͬrҲҽ|ĸNrWôĺܶrҸm˺ܴ|M
˾śr
ڵĹ˾ɽͮxQ˾һȻͶYعɵ؟ι˾佛IǼҾľƷOӋaNҾOӋ҃bMܛ_laaƷᘼƷaƷΣUƷúƷF䓲ĵlƵԃCеONۼUؔOһؔղLһ{ɂӋŤҵϕӋӋ
^
ӋӋͽȿƵĕӋ{CԞ{ӛϴWWՓڅ^^ԭʼ{C쾚Ҳ@NđBҺҕ˕ӋѭhĻʯӋںӋ҇LԇƆεhttp//njrֻϻؼanѹ˾ճ^ʹõĕӋIJxӋڕϿԌWһЩyЎRƱlƱȾҪr|Ķ˸̵ӡeԞJR߀ҪеĆΓ°շTeÿPIյĆΓÈDbӆܞӛÜʂ
ƺÑ{CMӛmfӛȥcСW؏˴Ĺ]һĺͼǺyεһeSùPͿ˻ƤͿ˾ÿһEӋƶȶЇҪ猑e־ҪütPMw؟˵UڔֵĕҲЇҪEһҪܖ|ӛrҪÿһ䛼Q܁ytLĽJľͲܽYƽ˷ijҲжcR@Irԇre˾Ϳ۷ֶ@PһIĎһIԺƶlչӋ
Ɔεӛ^̻˽˂źҪJYϕ֪RYһֹôһӋҪĵĸvÿһNyЎεĘʽʽԼʲôrʹ@N˻JRԺW͕đ
ի@
@ΌMȡǷdzҪڹЃH҂nόW֪Rhh҂ҪrgoԼIĻAҲҪ،WIͬrڌHĹ}rҪՈHͨҲǷdzҪ.һcc˴һTˇgҲһNIڽĹҲDzܺҕRϾҪM҂ҲҪRʽČÿһεĽvһNe@NeպؔڹڌW҂Ҫ@ЩFؔl]Ķ_°빦ЧδĹҌWՓ֪R͌`đõHչʾҵĂ˃rֵrֵ錍FҵǰŬ
ƮI ƪ3
ˎgͷQˎˎ{Wбزٵă]ЈԌՓAôČ`ҲǛ]е{ˎ֮߀ҪMЏ͙z@njˎϵˎQͬˎMһһzǷe`@һcPIҪ{ˆTҪ^JˎA߀Ҫ^ľI]^ľI'Ԓô@ǰΣUoDzȡ
ˎr@ĹǺܴÿ춼Sಡˁ@ȡˎ@Ҫ{ˎҲܶÿҪкÎʮˎҪ{@﹤ҪSՓ֪RĄֲõӵĕrҪz鷽Л]І}_J]І}M{@ӓˎ{WՓ֪RͺҪ҂\ˎ{W֪R팦MЙzˎͬһNˎĄeS磺ſ··ͨţڳ׳ץˎrҪ쾚ʹˎMзQˎꭲͬ҂ƽrҊСu˕rõėUˎַǰͺʹÕrסԷQ50ԃȵסǰԷQ50250֮gʹÕr߀ҪڶP϶λڷQrMУ
H҂JҎg쾚ƽnЌWIJeOͬώMճoώ̵ӡͨ^PӛķʽӛԼڹеĵõώĽڷQٝڽĹҌӿ̿W_չьIgˮƽõ؞VȺ
ƮI ƪ4
CһwgI
I
wW ̖2011090118 ICһwg Cһwg01ָ̎ w rg XXXX-X-XXXXX-X-X
20xx19
Ŀ
Ŀ ............................................................................................................................... 2
ǰ ............................................................................................................................... 3
һĿ'΄ ................................................................................................... 3
1.1Ŀ........................................................................................................... 3
1.2΄Ҫ................................................................................................... 4
λλ ........................................................................................... 4
2.1λ................................................................................................... 4
2.2λ飨śr................................................................................... 5
ݣ^̣ ............................................................................................... 5
3.1eӋƌWcgIλύӖ................................................... 5
3.2mCһwgIλ........................................................... 5
3.3Wλ֪R................................................................................... 6
ĵw ....................................................................................................... 6
4.1ɫD׃............................................................................................... 6
4.2̓ՈW................................................................................... 7
4.3[đB옷....................................................................................... 7
Y ............................................................................................................... 8
5.1ûAPI............................................................................................... 8
5.2зe۽............................................................................................... 8
5.3I֪RյIJȫ........................................................................... 8
5.4I`醚vhS........................................................................... 8
ƮI ƪ5
һ xĿ
ÿһW횓еһνvʹ҂ڌ`˽҂W˺ܶnϸ͌W֪R_ҕҰLҊR҂ԺMһԌĻAӋָwMӋӛռPYͨ^ӹ̎DQÑQõؔϢՕӋHҪWÕĸNӋ֪RҲҪJeOącNӋęCՓ͌`ЙCՌĽYһֻ@Ӳܳɞһ|ĕӋI˲
΄
Ĺ˾ҵúVM˞ڃɂµČ˴Ό΄£
1.IՌWԭʼ{Cӛ~{C
2.Ӌ{CWӛӛ~
3.ӛ~{Cԭʼ{CWӛ~
4.ӛ~{C~WӋaƷɱ
5.ӛ~{C~Y㷨еľCϽYDWӋaƷijɱ
6.ӛ~{CWĿR
7.ĿRӛ~
8.W~(ԇƽ)
9.oPWƱµYaؓ
rg
xx-x-xxx-x-x
c
xxʡxxxxhxxx·x̖
λ
xx˾xxFxxʡxxxxhxx悵һȫYӹ˾xx˾xFһڽVŴ|VŴ|VVOӋaúV240fһOӋaúV120fϴúSVaúVҪoxx늏Sxx늏S늖|ݔVAӋxxxʽͶa
ݣ
ڌăɂwČ£
һܣ 1˾ؔrԼˆTOM˽ 2˽˾ؔҎԼؔƶ 3ϤӋ{Cľ
ڶܣ 1ϤӋ~ĵӛ 2Fӛ~yӛ~쾚
ܣ 1aλ˽aƷa 2˽aƷaҪԭϼo 3˽aƷijɱ
ܣ 1aƷaϺMЌ` 2aƷijɱMЌ`
ܣ 1o˾ĕӋˆTMйY 2o˾ĕӋˆTƕӋ 3o˾ĕӋˆTaN
ܣ 1ڽyӋTo
ܣ 1o˾ؔTMд؛رPc 2o˾ĕӋˆTM㻯ӋIJа{C {ӛ~ĵӛN~ĵӛ
ڰ 1o~ӋƅR~ĵӛĩӋ̎ 2˽ӈľ
(һ)ӋһTԵČWһҪĽǼӏ߽ЧҪֶx_ӋԽlչӋ@ԽҪӋ߽IĽIҪlչԃɂ棺һh׃;ǕӋϢʹϢ׃ǰǸĄQˌӋϢĔ|o~ԁӋCgϢgİlչahӰϢrѽɞ҂̎ĕrǡ
()@crMĕroՓh߀ϢʹߵϢҪڰl׃ӋϽvǰδе׃@N׃ҪwFڃɂ棺һǕӋgֶcӋ㻯ѽȡֹӛ~IȲWrrɞǕӋđ÷չӋ׃ԴIh׃ԼՓcĄⲿh׃
()Ӌ㻯ǕӋʷύµһӋCđȎ픵̎ߵĸ׃ҲϢdw׃㻯ӋyӋӋՓlӰĶӋƶӋwƵ׃Ӌ㻯MӋҎ˜ʻͨûMĬFλֹ㻯ʽMЕӋֹҪвϵĺaƷɱĺY㼰ľͨ^ąRҪ㻯팍F
()@Όһ呟־I֪RęCһWęC@̶̵ČgҿԼ¶o֪췀ص͑׃ͬrҲԼ^I˲ŷԼ߀SIJԼҪӿ첽ץorgJŬoηŬԼ呟21oҪďͺ˲Ŷ^!
Hݎæ˂λxxxxخa_l˾FAЃĿһĿRҪYһ20̖_،淶20̖ȥµĿrԒڼϢһچͬWѽ_ʼһ@rҵ_ʼc]µĿ_w_߀_ʼWУҪҪwڽĹԒҲ]ԽԽȵ20̖ұЂȥˌλrҵ˹vˁQȥҪõĹmfҪõҲ܌Wܶ|ҲԻ콨߀ܿWʲô㎧ҁˡxxxxǡҊĿҰһλ@_ʼDsxČȥ҆λ^ҌWˡCǵȲҪԼȥҵ
һҎRϾҪYĹʲôɿɆxxҊҵĎxxxxһλpؓ؟܌I֪RĹ̎IͿˇҶ쎟һDȦмvһ¹̵r@Ҳ֪ԭ@ܿWٵĖ|лõĶ15סլ͵ȷ֑Ҫ|һڵ10סլ܇1#~8#wѽm≦bTȉˮ̵ȵһ9#~10#̖ǵ䓽ģŹǕĘf漰˷һµĕrֻ܂ijЩ͎һƪ΄ՕݺҪ֪cҲf܌WĺÎ헹ƩʩMľԺúõĿλžȵڌ^ҲһЩ}һڼS|HRFԼȥ@ҲʹԼֵęCҪԿҲǰSһaڎλĶλһҪ̵ÿhҪܵ¾ͱ^҄|Wһһÿ̎DһЩx˽Ė|ҲǺ֪ܶIJλһЩI~ҶՈ̎
BһҌgĹr
һصĭh˽HĹhHhڹhfஔ֮DȥrĿk҄ᵽǰŵƷRrʹ֮gk҃ț]бOʩeDŽȥĕrsϸߜ^ȥk犱涼c@ӵĭhҲm20kҽð^ȥb˿{}kxһ·ÿ첻ֻҪߎׂH̶̵һ sҽ|˲ʩλҊĂĿ·ٵG߀ИĿOfkҾ҂̎ı^g߀|˷ܲT|z鲿Tְλϰ˾Iȵ
ڶؿĖ|̫XÿطֵúõĿώҲfҪDDZزٵһһ5#ǵʩD_cOӋʩfͽYf_кܶĖ|ҪӛסeǽYf䓽ʹ^̵ȵƽʈDg_gM߶˽ڴXγwDڿYDryYƽDǂİĸ䓽עȫBȥIˎױDĥĵط͆ЕrԼDȥF䓽Fڿfƽѽ]ʲô}
YҪfYϹό̫ϵΣ׃w֪ͨ;hӛҪO}hĿOCȲh;һ1#~4#ʩMOӋ;≦Ᵽع̵ʩ;7·8·ݵʩMӋ;Pڕ̆OÂļ˽˘ֵP֪R瘶ߴLΘQd110ӳܹעrܰlƿiӡȿSƫ|Ƶȵ;xxxxסլ|֑չҎvˆTM֑cյą^eՕrՃݵȵ;ȫyһ̻A~--xxxxʡrxxxxʡ̾CA㶨~xxxxнaA㶨~@ҪYҲŷһÿйfӋҎtӋrӋrһ_ʼҺЂATҿһʲôr˹MCеMMM߀һ1#~10#Ǽd1d2d3Ľ̵̘ʩYÿЎװُһЩҪԭ|ՈλDߑ׃zyȵ@ЩҪ͵n^n
ʩˇʩžO;ʲôǡ㾀;ˮc≦潻̎ս1-2M̎һl1MҌİ;䓽䓽Ľ^͔cӼ䓽gǷMҪQֲ䓽ͼs߅BӘֱС28ô28BCеӕrvAǰ500䓽eBӴ35d^gĘ÷Ͳ|Kʹģ֧wϵ10#ǵģúȞ18mmľzϰQ50mmx100mmľg250mmMp_䓹g600mm˨IJʹÏUC͝MͿ;Źвһ֧ģһΝעŵĜyصȵ;ֹˮ;ʩp50~100L1/3;sp;≦ˮ̎ͿɌӞrһƤuoܻ;lgö͵ķˮ;ܹעʩ^䓽\ǷϸΘٶȵĿCλ
fڼҪֵĵط߀治Ҫ߀ԿҪJĿĂط]ŪȻҷ@ҲҌgҪÿ͎ȥÿǶÿw߀ʩ10#ǵ䓽Ƿֲgv^LǷMҪֹˮϵAܼǷM;wYĿbͿǷͿλTܷz_ꎽDzλBˮF≦NuͱOҷһyxygƫǷ2փM_gǷҲMҪЛ]пչЛ]ѿpeT²λ׳FѿpҪN䓽zWbúǷۺ;Ϣƽ_ꖽǷƽֱȵÿ춼ܰlFٵĆ}
Ҷ̶̵һµČѽY ͨ^@Όի@njWmhͨ^@Ό_ʼm@N@Εrg呟ՓԺʲôһNԿ̈́ڵ`ڹ֪һЩcWУͬĆ}߀ڹ֪һgˆTԓȥIOPTĽ
ͨ^@ΌʹҌ̷P֪RڌH˸һЩ˽ԓfڌWУWٶČI֪RҲֻՓϵcH߀ce@ΌҵRDDһĎeDWcadһЩݷʽƿݔcomƄehȵ҅˃ɴιW{T֮gìȡЧĽQ
DeBmʮĸߜRrkқ]п{^ȥ·͛]^܌WһЩF|呟ǽQ}Č`磺OӋDϵ׃wʩrFĆ}c֮gĽͨȵֻͨ^`ҵ}lԭҵQk
PYҲһJR֪ʲôrԓʲôYʲô˺ֵ@Щǰ]н|^
һcǣmȻֻһµČrg˽Ŀ^xxǡЄ_ʼĕ˘;һ10#ǵĵͼ䓽ģ幤;һ1#~8#ǵb;G@߀ʹƽעĽYDҊrXЩ^mȻ@֮ǰ ώf^δW^ôһƽʩDЩۻʲôkzgdzqlllbatgtȵһ_ʼͲ֪ʲô˼^BIˎױƽƈDĈDDԔBxDķ^ŬٿDrKڲٸXyDȥF䓽
ͨ^@һΕrgČ@õČ`KԺĹЌõwFҕwW֪RWՓ֪R͌`õHЁ@_ˌĿ
ÿһIؽһνvʹ҂ڌ`˽얹֪RnjÿһλII֪RһNz҂W˺ܶnϸW֪R_ҕҰLҊR\WČI֪R˽ӋĹ̺ӋJRՓϵڌ`BHͷQ}_WõĿɹʂvĿСռ˾ʵČ淶҅ϣ!
gڌĿY@ӛڿԼMmȻ̕ի@^YҲֻǏķs˼wx˸|^ķՄՄԼһЩǺܳĿݲݞʲôĵطIώuָ
վǰľǂѾõʹÄڸ˻܇ҵһ·ƣvܿͱd^_ğoӰoۙKڿ@_չF˸ƽĴ_m춨AͬrɴWһҪhҲdzڌI͘IȥĿ]ҺԼٕrgȥ˼lһҏV湫˾ƽr͌V^dȤ]IԺп@ИIԵ֪܉ڏV湫˾ҷdzϧ@CĕrgNƽOӋ˽⼰ԼVJR@Όի@ҁfвԼX֪Rc˜ͨͽȷ涼LMwf@njҾC|B呟
hҳ_@~õδһֱԼʹĵ·,ҵĿǺ_,ǾǰM,ԗ,˿s!ҌVճMһ˽˹˾I_չcʽ\Ҏͬr˾I˳˽⣺|һuּ،ÿһ͑ijZһ͏V湫˾hƱС˞鱾\վ͑ϡڿ͑IbƽOӋVͻƏVֱЈINAעh؟εĘOʮ֑c܉@һ˾ęCʹ_۽ڌ^ի@ϲҲһЩzǾnjIЩJRHHͣڱֻڿ vδ܉Hw̎һЩԛ]I侫ͨ^ҌVSҵďV֪RʹҌVӴεĸԺJR
f_^yһ˾Ҳ֪ԓЩʲôʲôҲ岻ֻ@K߀ǹ˾ͬ½oָ·ʾҌWWphotoshopܛģ½̳ЩΈDƬKҵҾJDƬ̎fԒǰڌWУҲ^DƬ̎^ͨrһyͷŗFڮɆĕr߅ͬ¿ָ@ʹǜ\
ǰҿcӹҿXùһOǮx_WУMwǘһÿ϶ҪrϰcܻؼڹҲнzRÿ춼Ҫ_ʼϰĕrҵ鼤d^ϲֻJWúðÿһ϶гɿܶ|䌍Ҫܲ
Ȼ֮Sͬ^ͬ³ĵú_w@ôĐȻyǴδĿZuҰIǴҰIЕrgoڹ˾ČĵM˼ԼČԼĵ·ԼäĿ
@ùϵMֻеһҪδ߳У@rЪĹwҲoyöFwxhƏV湫˾ṩ@һWͽCҲòJҵČӽһΪČWһĹ1mȻҶһҪD
^һµČw
߀]M˾֮ǰҪJ˽˾wrƶԺĹʂܵđ;ҪWc̎c˜ֻͨ@õHPϵڿ옷Ěɹcͬ̎һҪYòt̓PæwՏ;ٴҪWCJعǰڌWУnֻ֪ͬWˣՄЦɲ@˾ǹĵطǽ^Sl@ӵðcRt͕ee͕o˾pʧRԼ^ǰǘҪW@ͬһӇCJŬع;ҪWֻ̓̓Ո̲W|Ҳֻ̓Ո̲ſʹԼMøҪнǰ݅WWĹBȺԭt@Ӳߺܶ·
ϵÁKX\^֪ҪСڶ̕Č^XԼյ֪Rw\ڌH\ЌI֪RąT_ʼһΕrgXoãȻ֪@ҷdzy^ڌWԞԼWIJeһ|HŰlFԼ֪Ƕô@rIWoֹĺx@ҲS҂뷨^҂ܵĽ͌-
`Ĵ_кLһξxgҲŬČڌWУWՓ֪RD`Mc`Y
֮ĸnjWУWĖ|Ǜ]ʲôԵڌĵطʲôǏ_ʼŌһҲyfwWʲôһcǿ϶ڹ˾|ĶǺ܌õĖ|n֪RôՓкҪc˴mfһ_ʼˎyҺܶǺ܌HĆ}ܶrҲòãȻ挦FXѽ܉̎һЩ}֪ôQijЩy@һNyôkQX@NǺҪ
̕Č^ȥsfϲϲǺܿҪصWУҊɐ۵ͬWǝhƹ˾ͬºт߀й˾TڵͰVȪˮߺlˮѽ
Áfڌgܵ˺ܴĆlڽĹK߀SµĖ|@Щ|oµww҈ţֻҪİl¸ҵ؇Lԇһиի@͆lҲֻ@ӲܞԼԺĹe۸֪R͌FĽ
ٴθxhƵĹˆTҁh@һκܺõĽvܸxhƹ˾ĸλͬ@νvضһܸؔмҵoҵĎxx
ѽY|Ǻӵի@ST^YҵČеʮֵοʹڌ`˽W˺ܶnϸ͌W֪RҲ_ҕҰLҊRҼԌĻA_ˌWУҪČĿ .
ƮI桿P£
ƮI02-14
PƮIƪ06-29
ƮIR9ƪ07-03
ƮIur07-07
ƮIb06-22
ƮIb06-25
ƮI06-24
]ƮIb11-26
ƮIb12-29
ƮIb]12-29