“在線(xiàn)電影售票系統(tǒng)”設(shè)計(jì)文檔

1、在線(xiàn)電影購(gòu)票系統(tǒng)設(shè)計(jì)文檔第X組 XX一、 數(shù)據(jù)庫(kù)設(shè)計(jì)“在線(xiàn)電影購(gòu)票系統(tǒng)“是面向用戶(hù)的一款系統(tǒng)，旨在讓用戶(hù)方便的在某個(gè)電影院在線(xiàn)購(gòu)票，特此本系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)如下：1“在線(xiàn)電影購(gòu)票系統(tǒng)”的ER圖和實(shí)體：ER圖：實(shí)體：用戶(hù)(Customer)、座位(Seat)、電影(Movie)、訂單(Ordered)2.”在線(xiàn)電影購(gòu)票系統(tǒng)”的表：主要涉及上述四個(gè)表。3.”在線(xiàn)電影購(gòu)票系統(tǒng)“的數(shù)據(jù)庫(kù)實(shí)現(xiàn)建立數(shù)據(jù)庫(kù)的SQL語(yǔ)句：CREATE DATABASE /*!32312 IF NOT EXISTS*/cin_ticksystem /*!40100 DEFAULT CHARACTER SET utf8 */;US

2、E cin_ticksystem;建立表和插入數(shù)據(jù)的SQL語(yǔ)句：/*Table structure for table customer */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 NU

3、LL, Csex varchar(100) CHARACTER SET utf8 DEFAULT NULL, Cage varchar(10) CHARACTER 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), K

4、EY Cflowline (Cflowline) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;/*Data for the table customer */insert into customer(Cflowline,Cid,Ckey,Cname,Csex,Cage,Cstatus,Cwill1,Cwill2) values (3,'123','123','易禮書(shū)','女','50','0',NULL,NULL),(11,'123

5、4','1234','你好','女','18','0',NULL,NULL),(9,'1777','11','哈哈','男','','0',NULL,NULL),(10,'#39;,'123','生氣果凍','男','19','0',NULL,NULL),(2,'admin','

6、admin','admin','男 ','19','0',NULL,NULL);/*Table structure for table movie */DROP TABLE IF EXISTS movie;CREATE TABLE movie ( Mflowline int(11) NOT NULL AUTO_INCREMENT, Mid char(6) NOT NULL DEFAULT '', Mname varchar(50) NOT NULL DEFAULT '', Moutdte c

7、har(20) NOT NULL, Moffdate char(20) NOT NULL, Mpicture char(1) NOT NULL DEFAULT '', Mbrief varchar(500) NOT NULL DEFAULT '', Mshowtime char(20) NOT NULL, Mprice varchar(10) NOT NULL, Mstatus char(10) DEFAULT '0', Cwill1 varchar(100) DEFAULT NULL, Cwill2 varchar(100) DEFAULT N

8、ULL, PRIMARY KEY (Mid), KEY Mflowline (Mflowline) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;/*Data for the table movie */insert into movie(Mflowline,Mid,Mname,Moutdte,Moffdate,Mpicture,Mbrief,Mshowtime,Mprice,Mstatus,Cwill1,Cwill2) values (1,'001','大魚(yú)海棠','','&#

9、39;,'','','2016-07-31 19:30','30','0',NULL,NULL),(2,'002','忍者神龜2','','','','','2016-07-28 13:35','25','0',NULL,NULL),(3,'003','時(shí)空戀旅人','','','','

10、','2016-07-25 17:00','40','0',NULL,NULL),(4,'004','Superman','','','','','2016-08-03 15:20','25','0',NULL,NULL),(9,'005','魔獸','','','','','2016-8-5

11、19:30','50','0',NULL,NULL);/*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_T

12、IMESTAMP, Mshowtime char(20) NOT NULL, Off 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) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8

13、;/*Data for the table ordered */insert into ordered(Oid,Cid,Mid,Sid,Odate,Mshowtime,Off,Orevoke,Paid,Owill1,Owill2) values (000023,'123','001','12','2016-07-21 16:59:12','2016-07-31 19:30','0','0','30',NULL,NULL),(000025,'123',&

14、#39;001','13','2016-07-22 09:04:57','2016-07-31 19:30','0','0','30',NULL,NULL),(000026,'123','001','22','2016-07-22 09:10:42','2016-07-31 19:30','0','0','30',NULL,NULL),(000027,'18

15、380129078','002','12','2016-07-22 09: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 ( Sfloeline int(11) NOT NULL AUTO_INCREMENT, Sid char(3) NOT NULL,數(shù)據(jù)庫(kù)實(shí)現(xiàn)截圖：

16、數(shù)據(jù)庫(kù)：表：Customer：Seat：Movie:Ordered:二、 界面設(shè)計(jì)”在線(xiàn)電影售票系統(tǒng)“設(shè)計(jì)的網(wǎng)頁(yè)界面，由我們?nèi)w項(xiàng)目組成員共同分析探討，設(shè)計(jì)到了如下的界面設(shè)計(jì)：1. 由rose2000e繪制的界面關(guān)系圖：用戶(hù)關(guān)系圖：管理員關(guān)系圖：2. 項(xiàng)目開(kāi)發(fā)實(shí)現(xiàn)中的界面實(shí)現(xiàn)主要是界面的jsp文件：其中，ad_movie.jsp管理員選擇添加電影界面admin_movie.jsp管理員電影管理界admin.jsp管理員登錄界面choose_seat.jsp購(gòu)票選座界面cinema.jsp用戶(hù)首頁(yè)Dyht.jsp電影大魚(yú)海棠界面get_cus.jsp查詢(xún)用戶(hù)信息界面get_ord.jsp查詢(xún)訂單信息界面index.jsp系統(tǒng)首頁(yè)int_mv.jsp添加電影界面login.jsp登錄界面menu.jsp