在線電影售票系統(tǒng)設(shè)計文檔

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

2、E cin_ticksystem;建立表和插入數(shù)據(jù)的SQL語句：/*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','易禮書','女','50','0',NULL,NULL),(11,'123

5、4','1234','你好','女','18','0',NULL,NULL),(9,'1777','11','哈哈','男生氣果凍','男','19','0',NULL,NULL),(2,'admin','admin','admin','男 ','19','0',NULL,NULL);/*Table s

6、tructure 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 char(20) NOT NULL, Moffdate char(20) NOT NULL, Mpicture char(1) NOT NULL DEFAULT '

7、', 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 NULL, PRIMARY KEY (Mid), KEY Mflowline (Mflowline) ENGINE=InnoDB AUTO_INCREMENT=10 DEF

8、AULT 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','大魚海棠','','','','','2016-07-31 19:30','30','0',NULL,NU

9、LL),(2,'002','忍者神龜2','','','','','2016-07-28 13:35','25','0',NULL,NULL),(3,'003','時空戀旅人','','','','','2016-07-25 17:00','40','0',NULL,NULL),(4,'004'

10、,'Superman','','','','','2016-08-03 15:20','25','0',NULL,NULL),(9,'005','魔獸','','','','','2016-8-5 19:30','50','0',NULL,NULL);/*Table structure for table ordered */

11、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, Off char(1) NOT NULL DEFAULT '0', Orev

12、oke 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;/*Data for the table ordered */insert into /*Table structure for table seat */DROP T

13、ABLE IF EXISTS seat;CREATE TABLE seat ( Sfloeline int(11) NOT NULL AUTO_INCREMENT, Sid char(3) NOT NULL,數(shù)據(jù)庫實現(xiàn)截圖：數(shù)據(jù)庫：表：Customer：Seat：Movie:Ordered:二、 界面設(shè)計”在線電影售票系統(tǒng)“設(shè)計的網(wǎng)頁界面，由我們?nèi)w項目組成員共同分析探討，設(shè)計到了如下的界面設(shè)計：1. 由rose2000e繪制的界面關(guān)系圖：用戶關(guān)系圖：管理員關(guān)系圖：2. 項目開發(fā)實現(xiàn)中的界面實現(xiàn)主要是界面的jsp文件：其中，ad_movie.jsp管理員選擇添加電影界面admin_movie.jsp管理員電影管理界admin.jsp管理員登錄界面choose_seat.jsp購票選座界面cinema.jsp用戶首頁Dyht.jsp電影大魚海棠界面get_cus.jsp查詢用戶信息界面get_ord.jsp查詢訂單信息界面index.jsp系統(tǒng)首頁int_mv.jsp添加電影界面login.jsp登錄界面menu.jsp菜單界面my_inf.jsp個人信息界面my_ord.jsp個人訂單界面no_