音響店DVD零售出租管理數(shù)據(jù)庫

1、 . 79/80大型數(shù)據(jù)庫課程設(shè)計設(shè)計報告題 目：音響店DVD出租/零售管理系統(tǒng)學(xué) 號： 1 2 1 0 0 6 3 14學(xué)生： 可指導(dǎo)教師：寧提交時間：目錄TOC o 1-2 u 第1章需求分析 PAGEREF _Toc24098 11.1需求調(diào)查 PAGEREF _Toc17994 11.2 系統(tǒng)功能分析1第2章概念結(jié)構(gòu)設(shè)計22.1 局部E-R圖22.2 全局E-R圖3第3章邏輯結(jié)構(gòu)設(shè)計43.1 E-R圖向關(guān)系模式轉(zhuǎn)換43.2建立關(guān)系模式43.3關(guān)系模式規(guī)化處理43.4用戶子模式建立43.5關(guān)系模式邏輯結(jié)構(gòu)定義5第4章數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計74.1 數(shù)據(jù)庫物理設(shè)計7第5章數(shù)據(jù)庫實施85.1 數(shù)

2、據(jù)庫與數(shù)據(jù)庫對象建立8第6章 數(shù)據(jù)庫完整性設(shè)計96.1 主鍵96.2參照完整性設(shè)計96.3觸發(fā)器設(shè)計96.4視圖設(shè)計12第7章 數(shù)據(jù)庫存儲過程設(shè)計13總結(jié)14參考文獻：14第1章需求分析1.1需求調(diào)查通過對各個用戶的調(diào)查，該音響店DVD零售出租管理系統(tǒng)如下需求：系統(tǒng)管理：實現(xiàn)系統(tǒng)管理人員對系統(tǒng)的管理，包括添加刪除用戶，更改密碼等功能。數(shù)據(jù)管理：實現(xiàn)管理人員對系統(tǒng)的管理，包括DVD入庫，出租，出售，歸還等功能?；拘畔ⅲ簩崿F(xiàn)顯示客戶和DVD基本信息（包括客戶信息和客戶所租賃DVD信息，DVD基本信息）。查詢：查詢當(dāng)前DVD狀況；查詢當(dāng)前用戶租賃狀況與歷史租賃狀況。1.2 系統(tǒng)功能分析音響店DVD

3、零售/出租管理系統(tǒng)音響店DVD零售/出租管理系統(tǒng)DVD借還管理DVD零售管理用戶信息管理DVD信息管理DVD入庫管理DVD借還管理DVD零售管理用戶信息管理DVD信息管理DVD入庫管理DVD信息管理：存放與查看各DVD的基本信息和數(shù)量。用戶信息管理：用于對用戶基本信息的錄入、查詢、修改、維護、刪除等常用功能，并記錄用戶的租賃情況。DVD入庫管理：用于對DVD的入庫情況進行記錄，并修改DVD總量。DVD零售管理：用于記錄DVD的零售情況，并修改DVD總量。DVD借還管理：用于統(tǒng)計各DVD的借還情況。第2章概念結(jié)構(gòu)設(shè)計2.1局部E-R圖：（1）對DVD建立E-R圖（2）對用戶建立E-R圖用戶用戶編

4、號用戶用戶編號XX歷史租賃性別當(dāng)前租賃DVDDVD編號主演庫存現(xiàn)貨名稱（3）對DVD租賃建立E-R圖DVD租賃DVD租賃DVD編號租賃用戶編號租賃日期租賃期限D(zhuǎn)VD名稱租賃編號（4）對DVD歸還建立E-R圖DVD歸還DVD歸還DVD編號歸還用戶編號歸還日期逾期天數(shù)DVD名稱歸還編號（5）對DVD零售建立E-R圖DVD零售DVD零售DVD編號出售日期出售數(shù)量DVD編號DVD名稱（6）對DVD入庫建立E-R圖DVD入庫DVD入庫DVD編號入庫日期入庫數(shù)量DVD編號DVD名稱2.2全局E-R圖：DVD名稱DVD編號DVD名稱DVD編號歸還日期歸還日期DVD名稱入庫日期DVD名稱入庫日期DVD編號DV

5、D入庫DVD編號DVD入庫歸還用戶編號入庫數(shù)量歸還用戶編號入庫數(shù)量DVD歸還歸還編號提供DVD歸還歸還編號提供現(xiàn)貨XX逾期天數(shù)現(xiàn)貨XX逾期天數(shù)DVD名稱主演性別用戶編號DVD名稱主演性別用戶編號DVD編號DVD編號DVD提供DVD提供用戶DVD零售辦理用戶DVD零售辦理庫存庫存出售日期出售數(shù)量DVD編號當(dāng)前租賃出售日期出售數(shù)量DVD編號當(dāng)前租賃歷史租賃DVD名稱歷史租賃DVD名稱DVD編號租賃日期DVD租賃DVD編號租賃日期DVD租賃DVD名稱租賃期限D(zhuǎn)VD名稱租賃期限租賃編號租賃編號租賃用戶編號租賃用戶編號第3章邏輯結(jié)構(gòu)設(shè)計3.1E-R圖向關(guān)系模式轉(zhuǎn)變邏輯結(jié)構(gòu)是獨立于任何一種數(shù)據(jù)模型的，在實

6、際應(yīng)用中，一般所用的數(shù)據(jù)庫環(huán)境已經(jīng)給定（如SQL Server或Oracel或MySql)。由于目前使用的數(shù)據(jù)庫基本上都是關(guān)系數(shù)據(jù)庫，因此首先需要將E-R圖轉(zhuǎn)換為關(guān)系模型，然后根據(jù)具體DBMS的特點和限制轉(zhuǎn)換為特定的DBMS支持下的數(shù)據(jù)模型，最后進行優(yōu)化系模式轉(zhuǎn)換3.2建立關(guān)系模式DVD信息（DVD編號，DVD名稱，主演，現(xiàn)貨，庫存）用戶信息（用戶編號，性別，當(dāng)前租賃，歷史租賃）DVD租賃（DVD編號，DVD名稱，租賃日期，租賃期限，租賃用戶編號，租賃編號）DVD歸還（DVD編號，DVD名稱，歸還日期，逾期天數(shù)，歸還用戶編號，歸還編號）DVD零售（DVD編號，DVD名稱，出售日期，出售數(shù)量）D

7、VD入庫（DVD編號，DVD名稱，入庫日期，入庫數(shù)量）3.3 關(guān)系模式規(guī)化處理根據(jù)F，分析每一個關(guān)系模式是否滿足3NF，對不滿足3NF的關(guān)系模式要進行規(guī)化處理。3.4 用戶子模式建立根據(jù)需求分析，研究建立滿足不同需求的用戶子模式，子模式表示形式為：子模式名（屬性列表）3.5 關(guān)系模式邏輯結(jié)構(gòu)定義1.DVD詳細(xì)信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵DVD名稱char10不為空主演char10不為空現(xiàn)貨int不為空庫存int不為空2.用戶詳細(xì)信息字段名數(shù)據(jù)類型長度約束用戶編號char4主鍵char10不為空性別nchar1男或女當(dāng)前租賃int可為空歷史租賃int可為空3.DVD租賃信息

8、字段名數(shù)據(jù)類型長度約束DVD編號char4外鍵DVD名稱char10不為空租賃日期datetime不為空租賃期限int不為空租賃用戶編號char4外鍵租賃編號char20主鍵4.DVD歸還信息字段名數(shù)據(jù)類型長度約束DVD編號char4外鍵DVD名稱char10不為空歸還日期datetime不為空逾期天數(shù)int不為空歸還用戶編號char4外鍵歸還編號char20主鍵，外鍵5.DVD零售信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵，外鍵DVD名稱char10不為空出售日期datetime主鍵出售數(shù)量int不為空6.DVD入庫信息字段名數(shù)據(jù)類型長度約束DVD編號char4主鍵，外鍵DVD名稱c

9、har10不為空入庫日期datetime主鍵入庫數(shù)量int不為空第4章數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計4.1數(shù)據(jù)庫物理設(shè)計數(shù)據(jù)庫物理設(shè)計：設(shè)計數(shù)據(jù)庫的物理結(jié)構(gòu)，根據(jù)數(shù)據(jù)庫的邏輯結(jié)構(gòu)來選定RDBMS（如Oracle、Sybase等），并設(shè)計和實施數(shù)據(jù)庫的存儲結(jié)構(gòu)、存取方式等。數(shù)據(jù)庫物理設(shè)計是后半段。將一個給定邏輯結(jié)構(gòu)實施到具體的環(huán)境中時，邏輯數(shù)據(jù)模型要選取一個具體的工作環(huán)境，這個工作環(huán)境提供了數(shù)據(jù)存儲結(jié)構(gòu)與存取方法，這個過程就是數(shù)據(jù)庫的物理設(shè)計。物理結(jié)構(gòu)依賴于給定的DBMS和和硬件系統(tǒng)，因此設(shè)計人員必須充分了解所用RDBMS的部特征、存儲結(jié)構(gòu)、存取方法。數(shù)據(jù)庫的物理設(shè)計通常分為兩步，第一，確定數(shù)據(jù)庫的物理結(jié)構(gòu)

10、，第二，評價實施空間效率和時間效率確定數(shù)據(jù)庫的物理結(jié)構(gòu)包含下面四方面的容：1、確定數(shù)據(jù)的存儲結(jié)構(gòu)2、設(shè)計數(shù)據(jù)的存取路徑3、確定數(shù)據(jù)的存放位置4、確定系統(tǒng)配置數(shù)據(jù)庫物理設(shè)計過程中需要對時間效率、空間效率、維護代價和各種用戶要求進行權(quán)衡，選擇一個優(yōu)化方案作為數(shù)據(jù)庫物理結(jié)構(gòu)。在數(shù)據(jù)庫物理設(shè)計中，最有效的方式是集中地存儲和檢索對象。數(shù)據(jù)庫實施5.1數(shù)據(jù)庫與數(shù)據(jù)庫對象建立（1）創(chuàng)建數(shù)據(jù)庫：createdatabase音響店DVD零售出租管理系統(tǒng)數(shù)據(jù)庫on(name=音響店DVD零售出租管理系統(tǒng)數(shù)據(jù)文件,filename=E:SJKKCSJ音響店DVD零售出租管理系統(tǒng)數(shù)據(jù)文件.mdf,size=15MB,

11、maxsize= 50MB,filegrowth=5%)logon(name=音響店DVD零售出租管理系統(tǒng)日志文件,filename=E:SJKKCSJ音響店DVD零售出租管理系統(tǒng)日志文件.ldf,size= 2MB,maxsize= 5MB,filegrowth= 1MB)（2）創(chuàng)建表：createtableDVD信息表(DVD編號char(4)notnullprimarykey,DVD名稱char(10)notnull,主演char(10)notnull,現(xiàn)貨intnotnull,庫存intnotnull)createtable用戶信息表(用戶編號char(4)notnullprimary

12、key,char(10)notnull,性別nchar(1)notnull,當(dāng)前租賃intnull,歷史租賃intnull)createtableDVD租賃表(DVD編號char(4)notnull,DVD名稱char(10)notnull,租賃日期datetimenotnull,租賃期限intnotnull,租賃用戶編號char(4)notnull,租賃編號char(20)notnullprimarykey,foreignkey(DVD編號)referencesDVD信息表(DVD編號),foreignkey(租賃用戶編號)references用戶信息表(用戶編號)createtableDV

13、D歸還表(DVD編號char(4)notnull,DVD名稱char(10)notnull,歸還日期datetimenotnull,逾期天數(shù)intnull,歸還用戶編號char(4)notnull,歸還編號char(20)notnullprimarykey,foreignkey(DVD編號)referencesDVD信息表(DVD編號),foreignkey(歸還編號)referencesDVD租賃表(租賃編號),foreignkey(歸還用戶編號)references用戶信息表(用戶編號)createtableDVD零售表(DVD編號char(4)notnull,DVD名稱char(10)n

14、otnull,出售日期datenotnull,出售數(shù)量intnotnull,primarykey(DVD編號,出售日期),foreignkey(DVD編號)referencesDVD信息表(DVD編號)createtableDVD入庫表(DVD編號char(4)notnull,DVD名稱char(10)notnull,入庫日期datenotnull,入庫數(shù)量intnotnull,primarykey(DVD編號,入庫日期),foreignkey(DVD編號)referencesDVD信息表(DVD編號)數(shù)據(jù)庫完整性設(shè)計6.1主鍵表名主鍵DVD信息表(DVD編號)用戶信息表(用戶編號)DVD租賃

15、表(租賃編號)DVD歸還表(歸還編號)DVD零售表(DVD編號，出售日期)DVD入庫表(DVD編號，入庫日期)6.2參照完整性設(shè)計表名外鍵參照DVD租賃表(DVD編號，租賃用戶編號)DVD信息表.DVD編號用戶信息表.用戶編號DVD歸還表(DVD編號，歸還用戶編號)DVD信息表.DVD編號用戶信息表.用戶編號DVD零售表(DVD編號)DVD信息表.DVD編號DVD入庫表(DVD編號)DVD信息表.DVD編號6.3觸發(fā)器設(shè)計1.實現(xiàn)出租時自動修改DVD現(xiàn)貨與客戶的當(dāng)前租賃數(shù)量createtrigger_rentonDVD租賃表-租賃觸發(fā)器forinsertasbeginupdateDVD信息表s

16、et現(xiàn)貨=現(xiàn)貨-1fromDVD信息表,insertedwhereDVD信息表.DVD編號=inserted.DVD編號update用戶信息表set當(dāng)前租賃=當(dāng)前租賃+1from用戶信息表,insertedwhere用戶信息表.用戶編號=inserted.租賃用戶編號end2.實現(xiàn)歸還時自動修改DVD現(xiàn)貨與客戶的當(dāng)前租賃數(shù)量和歷史租賃數(shù)量createtrigger_returnonDVD歸還表-歸還觸發(fā)器forinsertasbeginupdateDVD信息表set現(xiàn)貨=現(xiàn)貨+1fromDVD信息表,insertedwhereDVD信息表.DVD編號=inserted.DVD編號update用

17、戶信息表set當(dāng)前租賃=當(dāng)前租賃-1from用戶信息表,insertedwhere用戶信息表.用戶編號=inserted.歸還用戶編號update用戶信息表set歷史租賃=歷史租賃+1from用戶信息表,insertedwhere用戶信息表.用戶編號=inserted.歸還用戶編號updateDVD歸還表setDVD編號=DVD租賃表.DVD編號,DVD名稱=DVD租賃表.DVD名稱,歸還用戶編號=DVD租賃表.租賃用戶編號fromDVD租賃表,DVD歸還表,insertedwhereDVD租賃表.租賃編號=inserted.歸還編號end3.實現(xiàn)入庫時自動修改DVD庫存createtrigg

18、er_buyonDVD入庫表-入庫觸發(fā)器forinsertasupdateDVD信息表set庫存=庫存+inserted.入庫數(shù)量fromDVD信息表,insertedwhereDVD信息表.DVD編號=inserted.DVD編號4.實現(xiàn)零售時自動修改DVD庫存createtrigger_saleonDVD零售表-零售觸發(fā)器forinsertasupdateDVD信息表set庫存=庫存-inserted.出售數(shù)量fromDVD信息表,insertedwhereDVD信息表.DVD編號=inserted.DVD編號5.實現(xiàn)歸還時自動計算并存入逾期天數(shù)createtrigger_daysonDV

19、D歸還表-逾期天數(shù)觸發(fā)器forinsertasdeclaredaysintsetdays=(selectcast(inserted.歸還日期asint)-cast(DVD租賃表.租賃日期asint)fromDVD租賃表,insertedwhereDVD租賃表.租賃編號=inserted.歸還編號)ifdays(selectDVD租賃表.租賃期限fromDVD租賃表,insertedwhereDVD租賃表.租賃編號=inserted.歸還編號)beginupdateDVD歸還表set逾期天數(shù)=days-(selectDVD租賃表.租賃期限fromDVD租賃表whereDVD租賃表.租賃編號=in

20、serted.歸還編號)fromDVD租賃表,DVD歸還表,insertedwhereDVD租賃表.租賃編號=inserted.歸還編號endelsebeginupdateDVD歸還表set逾期天數(shù)=0fromDVD租賃表,DVD歸還表,insertedwhereDVD租賃表.租賃編號=inserted.歸還編號end6.4視圖設(shè)計創(chuàng)建視圖查詢各類DVD的庫存情況createviewnumberasselectDVD編號,DVD名稱,現(xiàn)貨,庫存fromDVD信息表數(shù)據(jù)庫存儲過程設(shè)計創(chuàng)建存儲過程統(tǒng)計某段時間各DVD的銷售、借還數(shù)量createproceduretongjibegintimedat

21、e,endtimedate,typechar(6)asdeclareleixingchar(6)setleixing=typebeginifleixing=零售selectbegintimeas起始日期,endtimeas截至日期,DVD編號,SUM(出售數(shù)量)as銷售量fromDVD零售表where出售日期=begintimeand出售日期=begintimeand租賃日期=begintimeand歸還日期=endtimegroupbyDVD編號elseprint請輸入正確的查詢類型end總結(jié)在做本次課程設(shè)計的過程中，遇到了許多困難，正是這些困難，讓我把這門課學(xué)得更好，有了更深一步的理解，明

22、白了理論和實踐要想充分地結(jié)合，需要非常扎實的基本功。這就說明學(xué)好基礎(chǔ)知識是理論付諸實踐的前提。參考文獻：王珊,薩師煊 .數(shù)據(jù)庫系統(tǒng)概論M. 高等教育,2005阿奇等. SQLserver實用教程（第3版）M . 電子工業(yè),2009乃真等. 信息系統(tǒng)設(shè)計與應(yīng)用. 清華大學(xué),2005 附錄：隨機插入用戶信息表數(shù)據(jù)存儲過程代碼：createproceduredbo.usermassage_proc1/* 為用戶表輸入數(shù)據(jù)*/asdeclarenumint,rmdfloatdeclaregendernchar(1)declareuseridintdeclarexingint,rxingint,nanv

23、archar(8)-姓declaremingint,rmingint,menvarchar(10)-名declarenamenvarchar(20)-setnum=0whilenum0.5)-隨機確定性別setgender=男elsesetgender=女setrxing=floor(rmd*100)setxing=rxing%35setrming=floor(rmd*10000)-rxing*100ifxing=1 beginsetna=王setming=(rming%17)if (ming=1 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一i

24、f (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13

25、 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrm

26、d=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 a

27、ndrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)

28、setme=勇if (ming=11 andrmd0.5)setme=智if(ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪

29、娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=

30、明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (

31、ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 a

32、ndrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 an

33、drmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 an

34、drmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)s

35、etme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setm

36、e=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)se

37、tme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (

38、ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=

39、6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (mi

40、ng=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 and

41、rmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5

42、)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.

43、5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme

44、=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (m

45、ing=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming

46、=11 andrmd=0.5)setme=曉彤if(ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming

47、=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd

48、0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5

49、)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0

50、.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪

51、志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (

52、ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if(ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if

53、 (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if (ming=8 andrmd0.5)setme=小寶if(ming=9 andrmd0.5)setme=海軍if (ming=10

54、andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強if (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=

55、0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if (ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd

56、=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)s

57、etme=力凱if (ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15andrmd0.5)setme=云龍if (ming=16andrmd0.5)setme=玉衡if (ming=0 andrmd0.5)setme=克強i

58、f (ming=1 andrmd=0.5)setme=洪霞if (ming=2 andrmd=0.5)setme=樂樂if (ming=3 andrmd=0.5)setme=洪娟if (ming=4 andrmd=0.5)setme=雪if (ming=5 andrmd=0.5)setme=冉冉if (ming=6 andrmd=0.5)setme=曉旭if (ming=7 andrmd=0.5)setme=曉旸if (ming=8 andrmd=0.5)setme=燕if (ming=9 andrmd=0.5)setme=思思if (ming=10andrmd=0.5)setme=雪嬌if

59、(ming=11 andrmd=0.5)setme=曉彤if (ming=12 andrmd=0.5)setme=春琪if (ming=13 andrmd=0.5)setme=明月if (ming=14 andrmd=0.5)setme=月if (ming=15 andrmd=0.5)setme=晶晶if (ming=16 andrmd=0.5)setme=小璐if (ming=0 andrmd0.5)setme=力宏if (ming=2 andrmd0.5)setme=天一if (ming=3 andrmd0.5)setme=洪軍if (ming=4 andrmd0.5)setme=天霸if

60、 (ming=5 andrmd0.5)setme=杰if (ming=6 andrmd0.5)setme=小童if (ming=7 andrmd0.5)setme=力凱if(ming=8 andrmd0.5)setme=小寶if (ming=9 andrmd0.5)setme=海軍if (ming=10 andrmd0.5)setme=勇if (ming=11 andrmd0.5)setme=智if (ming=12 andrmd0.5)setme=洪志if (ming=13 andrmd0.5)setme=志強if (ming=14andrmd0.5)setme=云凱if (ming=15a