音响店DVD零售出租管理数据库

1、大型数据库课程设计设计报告题 目：音响店DVD出租/零售管理系统学 号： 1 2 1 0 0 6 3 1 4 学生姓名： 刘 可 指导教师： 刘 宁 提交时间： 目录第1章需求分析11.1需求调查11.2 系统功能分析1第2章概念结构设计22.1 局部E-R图22.2 全局E-R图3第3章逻辑结构设计43.1 E-R图向关系模式转换43.2建立关系模式43.3关系模式规范化处理43.4用户子模式建立43.5关系模式逻辑结构定义5第4章数据库物理结构设计74.1 数据库物理设计7第5章数据库实施85.1 数据库及数据库对象建立8第6章 数据库完整性设计96.1 主键96.2 参照完整性设计96.

2、3 触发器设计96.4 视图设计12第7章 数据库存储过程设计13总结14参考文献：14大型数据库课程设计报告第1章需求分析1.1需求调查通过对各个用户的调查，该音响店DVD零售出租管理系统如下需求：1) 系统管理：实现系统管理人员对系统的管理，包括添加删除用户，更改密码等功能。2) 数据管理：实现管理人员对系统的管理，包括DVD入库，出租，出售，归还等功能。3) 基本信息：实现显示客户和DVD基本信息（包括客户信息和客户所租赁DVD信息，DVD基本信息）。4) 查询：查询当前DVD状况；查询当前用户租赁状况及历史租赁状况。1.2 系统功能分析音响店DVD零售/出租管理系统DVD借还管理DVD

3、零售管理用户信息管理DVD信息管理DVD入库管理1) DVD信息管理：存放及查看各DVD的基本信息和数量。2) 用户信息管理：用于对用户基本信息的录入、查询、修改、维护、删除等常用功能，并记录用户的租赁情况。3) DVD入库管理：用于对DVD的入库情况进行记录，并修改DVD总量。4) DVD零售管理：用于记录DVD的零售情况，并修改DVD总量。5) DVD借还管理：用于统计各DVD的借还情况。第2章概念结构设计2.1局部E-R图：（1）对DVD建立E-R图 （2）对用户建立E-R图用户用户编号姓名历史租赁性别当前租赁DVDDVD编号主演库存现货名称（3）对DVD租赁建立E-R图DVD租赁DVD

4、编号租赁用户编号租赁日期租赁期限DVD名称租赁编号（4）对DVD归还建立E-R图DVD归还DVD编号归还用户编号归还日期逾期天数DVD名称归还编号（5）对DVD零售建立E-R图DVD零售DVD编号出售日期出售数量DVD编号DVD名称（6）对DVD入库建立E-R图DVD入库DVD编号入库日期入库数量DVD编号DVD名称2.2全局E-R图：DVD名称DVD编号归还日期DVD名称入库日期DVD编号DVD入库归还用户编号入库数量DVD归还归还编号提供现货姓名逾期天数DVD名称主演性别用户编号DVD编号DVD提供用户DVD零售办理库存出售日期出售数量DVD编号当前租赁历史租赁DVD名称DVD编号租赁日期

5、DVD租赁DVD名称租赁期限租赁编号租赁用户编号第3章逻辑结构设计3.1E-R图向关系模式转变逻辑结构是独立于任何一种数据模型的，在实际应用中，一般所用的数据库环境已经给定（如SQL Server或Oracel或MySql)。由于目前使用的数据库基本上都是关系数据库，因此首先需要将E-R图转换为关系模型，然后根据具体DBMS的特点和限制转换为特定的DBMS支持下的数据模型，最后进行优化系模式转换3.2建立关系模式DVD信息（DVD编号，DVD名称，主演，现货，库存）用户信息（用户编号，姓名，性别，当前租赁，历史租赁）DVD租赁（DVD编号，DVD名称，租赁日期，租赁期限，租赁用户编号，租赁编号

6、）DVD归还（DVD编号，DVD名称，归还日期，逾期天数，归还用户编号，归还编号）DVD零售（DVD编号，DVD名称，出售日期，出售数量）DVD入库（DVD编号，DVD名称，入库日期，入库数量）3.3 关系模式规范化处理根据F，分析每一个关系模式是否满足3NF，对不满足3NF的关系模式要进行规范化处理。3.4 用户子模式建立 根据需求分析，研究建立满足不同需求的用户子模式，子模式表示形式为：子模式名（属性列表）3.5 关系模式逻辑结构定义1.DVD详细信息字段名数据类型长度约束DVD编号char4主键DVD名称char10不为空主演char10不为空现货int不为空库存int不为空2.用户详细

7、信息字段名数据类型长度约束用户编号char4主键姓名char10不为空性别nchar1男或女当前租赁int可为空历史租赁int可为空3.DVD租赁信息字段名数据类型长度约束DVD编号char4外键DVD名称char10不为空租赁日期datetime不为空租赁期限int不为空租赁用户编号char4外键租赁编号char20主键4.DVD归还信息字段名数据类型长度约束DVD编号char4外键DVD名称char10不为空归还日期datetime不为空逾期天数int不为空归还用户编号char4外键归还编号char20主键，外键5.DVD零售信息字段名数据类型长度约束DVD编号char4主键，外键DVD名

8、称char10不为空出售日期datetime主键出售数量int不为空6.DVD入库信息字段名数据类型长度约束DVD编号char4主键，外键DVD名称char10不为空入库日期datetime主键入库数量int不为空第4章数据库物理结构设计4.1数据库物理设计数据库物理设计：设计数据库的物理结构，根据数据库的逻辑结构来选定RDBMS（如Oracle、Sybase等），并设计和实施数据库的存储结构、存取方式等。数据库物理设计是后半段。将一个给定逻辑结构实施到具体的环境中时，逻辑数据模型要选取一个具体的工作环境，这个工作环境提供了数据存储结构与存取方法，这个过程就是数据库的物理设计。物理结构依赖于给

9、定的DBMS和和硬件系统，因此设计人员必须充分了解所用RDBMS的内部特征、存储结构、存取方法。数据库的物理设计通常分为两步，第一，确定数据库的物理结构，第二，评价实施空间效率和时间效率确定数据库的物理结构包含下面四方面的内容：1、确定数据的存储结构2、设计数据的存取路径3、确定数据的存放位置4、确定系统配置数据库物理设计过程中需要对时间效率、空间效率、维护代价和各种用户要求进行权衡，选择一个优化方案作为数据库物理结构。在数据库物理设计中，最有效的方式是集中地存储和检索对象。第5章 数据库实施5.1数据库及数据库对象建立（1）创建数据库：create database 音响店DVD零售出租管理

10、系统数据库on( name ='音响店DVD零售出租管理系统数据文件', filename ='E:SJKKCSJ音响店DVD零售出租管理系统数据文件.mdf', size =15MB, maxsize = 50MB, filegrowth =5%)log on( name ='音响店DVD零售出租管理系统日志文件', filename = 'E:SJKKCSJ音响店DVD零售出租管理系统日志文件.ldf', size = 2MB, maxsize = 5MB, filegrowth = 1MB)（2）创建表：create tab

11、le DVD信息表( DVD编号 char(4) not null primary key, DVD名称 char(10) not null, 主演 char(10) not null, 现货 int not null, 库存 int not null)create table 用户信息表( 用户编号 char(4) not null primary key, 姓名 char(10) not null, 性别 nchar(1) not null, 当前租赁 int null, 历史租赁 int null)create table DVD租赁表( DVD编号 char(4) not null,

12、DVD名称 char(10) not null, 租赁日期 datetime not null, 租赁期限 int not null, 租赁用户编号 char(4) not null, 租赁编号 char(20) not null primary key, foreign key(DVD编号) references DVD信息表(DVD编号), foreign key(租赁用户编号) references 用户信息表(用户编号)create table DVD归还表( DVD编号 char(4) not null, DVD名称 char(10) not null, 归还日期 datetime

13、not null, 逾期天数 int null, 归还用户编号 char(4) not null, 归还编号 char(20) not null primary key, foreign key(DVD编号) references DVD信息表(DVD编号), foreign key(归还编号) references DVD租赁表(租赁编号), foreign key(归还用户编号) references 用户信息表(用户编号) create table DVD零售表( DVD编号 char(4) not null, DVD名称 char(10) not null, 出售日期 date not

14、 null, 出售数量 int not null, primary key(DVD编号,出售日期), foreign key(DVD编号) references DVD信息表(DVD编号) )create table DVD入库表( DVD编号 char(4) not null, DVD名称 char(10) not null, 入库日期 date not null, 入库数量 int not null, primary key(DVD编号,入库日期), foreign key(DVD编号) references DVD信息表(DVD编号)第6章 数据库完整性设计6.1主键表名主键DVD信息表

15、(DVD编号)用户信息表(用户编号)DVD租赁表(租赁编号)DVD归还表(归还编号)DVD零售表(DVD编号，出售日期)DVD入库表(DVD编号，入库日期)6.2参照完整性设计表名外键参照DVD租赁表(DVD编号，租赁用户编号)DVD信息表.DVD编号用户信息表.用户编号DVD归还表(DVD编号，归还用户编号)DVD信息表.DVD编号用户信息表.用户编号DVD零售表(DVD编号)DVD信息表.DVD编号DVD入库表(DVD编号)DVD信息表.DVD编号6.3触发器设计1.实现出租时自动修改DVD现货及客户的当前租赁数量create trigger _rent on DVD租赁表-租赁触发器fo

16、r insertasbeginupdate DVD信息表 set 现货=现货-1from DVD信息表,insertedwhere DVD信息表.DVD编号=inserted.DVD编号update 用户信息表 set 当前租赁=当前租赁+1from 用户信息表,insertedwhere 用户信息表.用户编号=inserted.租赁用户编号end2.实现归还时自动修改DVD现货及客户的当前租赁数量和历史租赁数量create trigger _return on DVD归还表-归还触发器for insertasbeginupdate DVD信息表 set 现货=现货+1from DVD信息表,

17、insertedwhere DVD信息表.DVD编号=inserted.DVD编号update 用户信息表 set 当前租赁=当前租赁-1from 用户信息表,insertedwhere 用户信息表.用户编号=inserted.归还用户编号update 用户信息表 set 历史租赁=历史租赁+1from 用户信息表,insertedwhere 用户信息表.用户编号=inserted.归还用户编号update DVD归还表 set DVD编号=DVD租赁表.DVD编号,DVD名称=DVD租赁表.DVD名称,归还用户编号=DVD租赁表.租赁用户编号from DVD租赁表,DVD归还表,insert

18、edwhere DVD租赁表.租赁编号=inserted.归还编号end3.实现入库时自动修改DVD库存create trigger _buy on DVD入库表-入库触发器for insertasupdate DVD信息表 set 库存=库存+inserted.入库数量from DVD信息表,insertedwhere DVD信息表.DVD编号=inserted.DVD编号4.实现零售时自动修改DVD库存create trigger _sale on DVD零售表-零售触发器for insertasupdate DVD信息表 set 库存=库存-inserted.出售数量from DVD信息

19、表,insertedwhere DVD信息表.DVD编号=inserted.DVD编号5.实现归还时自动计算并存入逾期天数create trigger _days on DVD归还表-逾期天数触发器for insertasdeclare days intset days=(select cast(inserted.归还日期 as int)-cast(DVD租赁表.租赁日期 as int)from DVD租赁表,insertedwhere DVD租赁表.租赁编号=inserted.归还编号)if days>(select DVD租赁表.租赁期限 from DVD租赁表,inserted w

20、here DVD租赁表.租赁编号= inserted.归还编号)beginupdate DVD归还表 set 逾期天数= days-(select DVD租赁表.租赁期限 from DVD租赁表 where DVD租赁表.租赁编号=inserted.归还编号)from DVD租赁表,DVD归还表,insertedwhere DVD租赁表.租赁编号=inserted.归还编号endelsebeginupdate DVD归还表 set 逾期天数=0from DVD租赁表,DVD归还表,insertedwhere DVD租赁表.租赁编号=inserted.归还编号end6.4视图设计创建视图查询各类

21、DVD的库存情况create view numberasselect DVD编号,DVD名称,现货,库存from DVD信息表第7章 数据库存储过程设计创建存储过程统计某段时间内各DVD的销售、借还数量create procedure tongji begintime date,endtime date,type char(6) asdeclare leixing char(6)set leixing=typebeginif leixing='零售'select begintime as 起始日期,endtime as 截至日期,DVD编号,SUM(出售数量) as 销售量fr

22、om DVD零售表where 出售日期>=begintime and 出售日期<=endtimegroup by DVD编号else if leixing='出租'select begintime as 起始日期,endtime as 截至日期, DVD编号,count(DVD编号) as 出租量from DVD租赁表where 租赁日期>=begintime and 租赁日期<=endtimegroup by DVD编号else if leixing='归还'select begintime as 起始日期,endtime as 截至日

23、期,DVD编号,count(DVD编号) as 归还量from DVD归还表where 归还日期>=begintime and 归还日期<=endtimegroup by DVD编号else print '请输入正确的查询类型'end总结在做本次课程设计的过程中，遇到了许多困难，正是这些困难，让我把这门课学得更好，有了更深一步的理解，明白了理论和实践要想充分地结合，需要非常扎实的基本功。这就说明学好基础知识是理论付诸实践的前提。参考文献：1. 王珊,萨师煊 .数据库系统概论M. 高等教育出版社,20052. 郑阿奇等. SQLserver实用教程（第3版）M . 电

24、子工业出版社,20093. 赵乃真等. 信息系统设计与应用. 清华大学出版社,2005 附录：随机插入用户信息表数据存储过程代码：create procedure dbo.usermassage_proc1/* 为用户表输入数据*/asdeclare num int,rmd floatdeclare gender nchar(1)declare userid intdeclare xing int,rxing int, na nvarchar(8)-姓declare ming int,rming int,me nvarchar(10)-名declare name nvarchar(20)-姓名

25、set num=0while num<1000beginset num=num+1set rmd=rand()-产生的随机数rmdif(rmd>0.5)-随机确定性别set gender='男'else set gender='女'set rxing=floor(rmd*100)set xing= rxing%35set rming=floor(rmd*10000)-rxing*100if xing=1 begin set na='王' set ming= (rming%17) if (ming=1 and rmd>0.5) s

26、et me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪军' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凯'

27、if (ming=8 and rmd>0.5) set me='小宝' if (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志强' if (ming=14and r

28、md>0.5) set me='云凯' if (ming=15and rmd>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set

29、me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='晓旭' if (ming=7 and rmd<=0.5) set me='晓旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思'

30、; if (ming=10and rmd<=0.5) set me='雪娇' if (ming=11 and rmd<=0.5) set me='晓彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (mi

31、ng=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=2 begin set na='李' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪军' if

32、(ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凯' if (ming=8 and rmd>0.5) set me='小宝' if (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>

33、;0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志强' if (ming=14and rmd>0.5) set me='云凯' if (ming=15and rmd>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='

34、;玉衡' if (ming=0 and rmd>0.5) set me='克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (m

35、ing=6 and rmd<=0.5) set me='晓旭' if (ming=7 and rmd<=0.5) set me='晓旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪娇' if (ming=11 and rmd<=0.5) set me='晓彤' if (ming=12 and r

36、md<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=3 begin

37、set na='张' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪军' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5)

38、 set me='小童' if (ming=7 and rmd>0.5) set me='力凯' if (ming=8 and rmd>0.5) set me='小宝' if (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志&#

39、39; if (ming=13 and rmd>0.5) set me='志强' if (ming=14and rmd>0.5) set me='云凯' if (ming=15and rmd>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 a

40、nd rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='晓旭' if (ming=7 and rmd<=0.5) set me='晓旸' if (ming=8 and rmd<=0.

41、5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪娇' if (ming=11 and rmd<=0.5) set me='晓彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me

42、='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=4 begin set na='刘' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) se

43、t me='天一' if (ming=3 and rmd>0.5) set me='洪军' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凯' if (ming=8 and rmd>0.5) set me='小宝' i

44、f (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志强' if (ming=14and rmd>0.5) set me='云凯' if (ming=15and rm

45、d>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set

46、me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='晓旭' if (ming=7 and rmd<=0.5) set me='晓旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪娇'

47、; if (ming=11 and rmd<=0.5) set me='晓彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (m

48、ing=0 and rmd<=0.5) set me='蓉蓉' end else if xing=5 begin set na='苏' set ming= (rming%17) if (ming=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪军' if (ming=4 and rmd>0.5) set me='天霸' if (

49、ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5) set me='力凯' if (ming=8 and rmd>0.5) set me='小宝' if (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>

50、0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志强' if (ming=14and rmd>0.5) set me='云凯' if (ming=15and rmd>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='

51、克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' if (ming=6 and rmd<=0.5) set me='晓旭' if (m

52、ing=7 and rmd<=0.5) set me='晓旸' if (ming=8 and rmd<=0.5) set me='燕' if (ming=9 and rmd<=0.5) set me='思思' if (ming=10and rmd<=0.5) set me='雪娇' if (ming=11 and rmd<=0.5) set me='晓彤' if (ming=12 and rmd<=0.5) set me='春琪' if (ming=13 and

53、rmd<=0.5) set me='明月' if (ming=14 and rmd<=0.5) set me='月' if (ming=15 and rmd<=0.5) set me='晶晶' if (ming=16 and rmd<=0.5) set me='小璐' if (ming=0 and rmd<=0.5) set me='蓉蓉' end else if xing=6 begin set na='陈' set ming= (rming%17) if (ming

54、=1 and rmd>0.5) set me='力宏' if (ming=2 and rmd>0.5) set me='天一' if (ming=3 and rmd>0.5) set me='洪军' if (ming=4 and rmd>0.5) set me='天霸' if (ming=5 and rmd>0.5) set me='杰' if (ming=6 and rmd>0.5) set me='小童' if (ming=7 and rmd>0.5)

55、set me='力凯' if (ming=8 and rmd>0.5) set me='小宝' if (ming=9 and rmd>0.5) set me='海军' if (ming=10 and rmd>0.5) set me='勇' if (ming=11 and rmd>0.5) set me='智' if (ming=12 and rmd>0.5) set me='洪志' if (ming=13 and rmd>0.5) set me='志强&#

56、39; if (ming=14and rmd>0.5) set me='云凯' if (ming=15and rmd>0.5) set me='云龙' if (ming=16and rmd>0.5) set me='玉衡' if (ming=0 and rmd>0.5) set me='克强' if (ming=1 and rmd<=0.5) set me='洪霞' if (ming=2 and rmd<=0.5) set me='乐乐' if (ming=3 and rmd<=0.5) set me='洪娟' if (ming=4 and rmd<=0.5) set me='雪' if (ming=5 and rmd<=0.5) set me='冉冉' i