在线电影售票系统设计文档

1、在线电影购票系统设计文档第X组XX“在线电影购票系统“是面向用户的一款系统,线购票，特此本系统的数据库设计如下：2.”在线电影购票系统”的表:数据库设计1“在线电影购票系统”的ER图和实体:用户(Customer)、座位(Seat)、电影(Movie)、订单(Ordered)旨在让用户方便的在某个电影院在序号表名字段名称类型WG 否丿为空缺省默认值说明备注1CustomerCflowl ineintNOT NULL流水线Cidchar(11)NOT NULL用户账号，用手机号表示红色为王键，监色为固疋长度Ckeyvarchar(10)NOT NULL用户密码Cn amevarchar(20)N

2、OT NULL用户昵称Csexvarchar(10)性别Cageint年龄CstatuscharNOT NULL0删除标志，1 为已删除Cwill1varchar(100)binary备用 1Cwill2varchar(100)binary备用 22SeatSflowli neintNOT NULL流水线Sidchar (3)NOT NULL座位编号编号咼位为 A-F,低位为两位数形式Midchar(6)NOT NULL电影编号一部电影只放映一场，只有一种座位状态Sflagchar(1)NOT NULL0座位是否已选择的状态1 表示已选择3will1varchar(100)binary备用 1

3、will2varchar(100)binary备用 2MovieCflowl ineintNOT NULL流水线Midchar(6)NOT NULL电影编号Mn amevarchar(30)NOT NULL电影名称MoutdatedatetimeNOT NULL上映日期MoffdatedatetimeNOT NULL下架日期MpictureNOT NULL海报Mbriefvarchar(500)NOT NULL简介MshowtimedatetimeNOT NULL放映时间MpricefloatNOT NULL价格MstatuscharNOT NULL0删除标志，1 为已删除Mwill1varc

4、har(100)binary备用 14Mwill2varchar(100)binary备用 2OrderedOflowli neintNOT NULL流水线Oidchar(6)NOT NULL订单编号Cidchar(11)NOT NULL用户账号Midchar(6)NOT NULL电影编号Sidchar (3)NOT NULL座位编号OdatetimestampNOT NULL订单生成日期通过读取系统时间，精确到分钟MshowtimedatetimeNOT NULL电影放映时间OffcharNOT NULL0订单关闭状态为 1,则订单关闭OrevokecharNOT NULL0订单撤销（退款）

5、状态为 1,则订单已撤销PaidcharNOT NULL0订单支付状态为 1,则已付款Owill1varchar(100)binary备用 1Owill2varchar(100)binary备用 2主要涉及上述四个表。3.”在线电影购票系统“的数据库实现 建立数据库的SQL语句：CREATBDATABASE132312 IF NOTEXISTS*/cin_ticksystem /*!40100 DEFAULTCHARACTER SETutf8 */;USE cin_ticksystem;建立表和插入数据的SQL语句：/*Table structure for table customer */

6、DROP TABLE IF EXISTS customer;CREATE TABLE customer (Cflowline int(11) NOT NULL AUTO_INCREMENT,Cid char(11) CHARACTER SET utf8 NOT NULL,Ckey varchar(10) CHARACTER SET utf8 NOT NULL,Cname varchar(100) CHARACTER SET utf8 NOT NULL,Csex varchar(100) CHARACTER SET utf8 DEFAULT NULL,Cage varchar(10) CHARA

7、CTER SET utf8 DEFAULT NULL,Cstatus varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 0,Cwill1 varchar(100) CHARACTER SET utf8 DEFAULT NULL,Cwill2 varchar(100) CHARACTER SET utf8 DEFAULT NULL,PRIMARY KEY (Cid),KEY Cflowline (Cflowline) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;/*Data for the

8、table customer */insert intocustomer(Cflowline,Cid,Ckey,Cname,Csex,Cage,Cstatus,Cwill1,Cwill2) values (3,123,123,易礼书,女,50,0,NULL,NULL),(11,1234,1234,你好,女,18,0,NULL,NULL),(9,1777,11,哈哈,0,NULL,NULL),(10123,19,0,NULL,NULL),(2,admin,admin,admin,男生气果冻,男男,19,0,NULL,NULL);/*Table structure for

9、 table movie */DROP TABLE IF EXISTS movie;CREATE TABLE movie (Mflowline int(11) NOT NULL AUTO_INCREMENT,Mid char(6) NOT NULL DEFAULT ”，Mn ame varchar(50) NOT NULL DEFAULT ,Moutdte char(20) NOT NULL，Moffdate char(20) NOT NULL,Mpicture char(1) NOT NULL DEFAULT ,Mbrief varchar(500) NOT NULL DEFAULT ,Ms

10、howtime char(20) NOT NULL,Mprice varchar(10) NOT NULL,Mstatus char(10) DEFAULT 0,Cwill1 varchar(100) DEFAULT NULL,Cwill2 varchar(100) DEFAULT NULL,PRIMARY KEY (Mid),KEY Mflowline (Mflowline) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;/*Data for the table movie */insert into movie(Mflowline

11、,Mid,Mname,Moutdte,Moffdate,Mpicture,Mbrief,Mshowtime,Mprice,Mstatus,Cwill1,Cwill2) values (1,001,2016-07-31 19:30,30,0,NULL,NULL),(2,002,2,2016-07-28 13:35,25,0,NULL,NULL),(3,003,2016-07-2517:00,40,0,NULL,NULL),(4,004,Superman,2016-08-0315:20,25,0,NULL,NULL),(9,005,魔兽,2016-8-519:30,50,0,NULL,NULL);

12、大鱼海棠忍者神龟时空恋旅人/*Table structure for table ordered */DROP TABLE IF EXISTS ordered;CREATE TABLE ordered (Oid int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,Cid char(11) NOT NULL,Mid char(6) NOT NULL,Sid char(3) NOT NULL,Odate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, Mshowtime char(20) NOT NULL,O

13、ff char(1) NOT NULL DEFAULT 0,Orevoke char(1) DEFAULT 0,Paid char(10) NOT NULL DEFAULT 0,Owill1 varchar(100) DEFAULT NULL,Owill2 varchar(100) DEFAULT NULL,PRIMARY KEY (Oid)ENGINES nn oDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;/*Data for the table ordered */in sert in toordered(Oid,Cid,Mid,Sid,Odate,

14、Mshowtime,Off,Orevoke,Paid,O will1,0will2) values(000023,123,001,12,2016-07-2116:59:12,2016-07-3119:30,0,0,30,NULL,NULL),(000025,123,001,13,2016-07-2209:04:57,2016-07-3119:30,0,0,30,NULL,NULL),(000026,123,001,22,2016-07-2209:10:42,2016-07-3119:30,0,0,30,NULL,NULL),(000027002,12,2016-07-

15、2209:14:42,2016-07-28 13:35,0,0,25,NULL,NULL);/*Table structure for table seat */DROP TABLE IF EXISTS seat;CREATE TABLE seat (Sfloeli ne i nt(11) NOT NULL AUTO_INCREMENT, Sid charNOT NULL,数据库实现截图:数据库:a a视存独表:Customer:口匸riQ-imeCa-geCSiaLLlEICWLLL1OW11L231123A50IWLL)1nULLf1112341224盘0U左11a.1855013907!

16、星0迥idmn.aJbdffiL Fin19IhVLLjffNUZL!跑LLilLL)aWLLfHULL)Y烷ED带制诗笔一讦： 则E 2抚就菲辺矍r垦窗怛予场I暦亘I司I&EritKiiae3iaMU5 lagswim5W11LZ1ii0011fWLLJfNULI；17110021fKULLj3311OOJ1fKULIJMTLZJ212001c恫mf皿邛ia12GO-20fKUH|3412CD 31fKUl口(liUZL)3130010fNiSrwLij口1913C02Q何L邛Movie:Ordered:界面设计”在线电影售票系统“设计的网页界面, 计到了如下的界面设计：1.由ros

17、e2000e绘制的界面关系图：用户关系图：TETTitT-FtZdQ3D帥WL111froirf2Oc0fmxjKidSid二liHK3&：WT1S=-Cl12上汇-l-21 L:i9：li-3L 1!:33Ml15翻畑IF心09: 04; 9?20L-fll-IL 19:MMl3300114(43lOLC-fll-lE 114M312m“-QU2!JQl-QT*2lumLczd二| joc:gisJ0134024131OQ) )OJ11I3BO1Z9-Q79岛I；口ILSeat:r u-ti-卩強讯由我们全体项目组成员共同分析探讨，设+Hvw r* iv iu.iJ KHshsvri

18、w2C-16-07-S1. 13:302Cl-07-a 1J;35rZUf -1-afNpZLjIBafw：时o唱出控轲事世电,冋K利XflLON淨亂电影1场次IJvhi.jp査录LugieJXD主界IfcCinema* J sc电影2怎次如-K- J 41退康Return- jsp玄付成功Pay.ucce, jsp|电影2诜廉Rzsig吧黑3场次Skllr. jspEdIt_inferjsp6 人信息Perinfor j电彩3握障Skllr_Sk?ittxJ：严/电钛管理员关系图:注射成功Reaiater. Jdk fKg ucccsJspr电觀Djht !sL逸陀itVlt. jP电2.项

19、目开发实现中的界面实现 主要是界面的jsp文件：& VJ&BdNF:严ad.mv.jsp:产admin_movie.j5p.f iadminjsp./ choose eatjsp；F dr ema j spf Dyht闻gtusjspJt Set_&rd.jp:广indexjsplOKih. Jtp控制攬轉订单Drop” Jsp廉悖录入Seat Invu t*由黑排片Wiike uoviettflWAcbuti. .jfipAid Kiu cpss査旳撤躺订Edit Order.录人禹功I atsuccess撤绡咸功Del sunt pus螺罠成功Orcp sueces衞堵申型Add_civie. jipint_nnvj5p/ loginpp祈