“在線電影售票系統(tǒng)”設(shè)計(jì)文檔“在線電影售票系統(tǒng)”設(shè)計(jì)文檔“在線電影售票系統(tǒng)”設(shè)計(jì)文檔xxx公司“在線電影售票系統(tǒng)”設(shè)計(jì)文檔文件編號(hào)：文件日期：修訂次數(shù)：第1.0次更改批準(zhǔn)審核制定方案設(shè)計(jì)，管理制度在線電影購票系統(tǒng)設(shè)計(jì)文檔第X組XX數(shù)據(jù)庫設(shè)計(jì)“在線電影購票系統(tǒng)“是面向用戶的一款系統(tǒng)，旨在讓用戶方便的在某個(gè)電影院在線購票，特此本系統(tǒng)的數(shù)據(jù)庫設(shè)計(jì)如下：1．“在線電影購票系統(tǒng)”的ER圖和實(shí)體： ER圖： 實(shí)體： 用戶(Customer)、座位(Seat)、電影(Movie)、訂單(Ordered)2.”在線電影購票系統(tǒng)”的表： 主要涉及上述四個(gè)表。3.”在線電影購票系統(tǒng)“的數(shù)據(jù)庫實(shí)現(xiàn)建立數(shù)據(jù)庫的SQL語句：CREATEDATABASE/*!32312IFNOTEXISTS*/`cin_ticksystem`/*!40100DEFAULTCHARACTERSETutf8*/;USE`cin_ticksystem`;建立表和插入數(shù)據(jù)的SQL語句：/*Tablestructurefortable`customer`*/DROPTABLEIFEXISTS`customer`;CREATETABLE`customer`(`Cflowline`int(11)NOTNULLAUTO_INCREMENT,`Cid`char(11)CHARACTERSETutf8NOTNULL,`Ckey`varchar(10)CHARACTERSETutf8NOTNULL,`Cname`varchar(100)CHARACTERSETutf8NOTNULL,`Csex`varchar(100)CHARACTERSETutf8DEFAULTNULL,`Cage`varchar(10)CHARACTERSETutf8DEFAULTNULL,`Cstatus`varchar(10)CHARACTERSETutf8NOTNULLDEFAULT'0',`Cwill1`varchar(100)CHARACTERSETutf8DEFAULTNULL,`Cwill2`varchar(100)CHARACTERSETutf8DEFAULTNULL,PRIMARYKEY(`Cid`),KEY`Cflowline`(`Cflowline`))ENGINE=InnoDBAUTO_INCREMENT=12DEFAULTCHARSET=gbk;/*Dataforthetable`customer`*/insertinto`customer`(`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),(10,'','123','生氣果凍','男','19','0',NULL,NULL),(2,'admin','admin','admin','男','19','0',NULL,NULL);/*Tablestructurefortable`movie`*/DROPTABLEIFEXISTS`movie`;CREATETABLE`movie`(`Mflowline`int(11)NOTNULLAUTO_INCREMENT,`Mid`char(6)NOTNULLDEFAULT'',`Mname`varchar(50)NOTNULLDEFAULT'',`Moutdte`char(20)NOTNULL,`Moffdate`char(20)NOTNULL,`Mpicture`char(1)NOTNULLDEFAULT'',`Mbrief`varchar(500)NOTNULLDEFAULT'',`Mshowtime`char(20)NOTNULL,`Mprice`varchar(10)NOTNULL,`Mstatus`char(10)DEFAULT'0',`Cwill1`varchar(100)DEFAULTNULL,`Cwill2`varchar(100)DEFAULTNULL,PRIMARYKEY(`Mid`),KEY`Mflowline`(`Mflowline`))ENGINE=InnoDBAUTO_INCREMENT=10DEFAULTCHARSET=utf8;/*Dataforthetable`movie`*/insertinto`movie`(`Mflowline`,`Mid`,`Mname`,`Moutdte`,`Moffdate`,`Mpicture`,`Mbrief`,`Mshowtime`,`Mprice`,`Mstatus`,`Cwill1`,`Cwill2`)values(1,'001','大魚海棠','','','','','2016-07-3119:30','30','0',NULL,NULL),(2,'002','忍者神龜2','','','','','2016-07-2813:35','25','0',NULL,NULL),(3,'003','時(shí)空戀旅人','','','','','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);/*Tablestructurefortable`ordered`*/DROPTABLEIFEXISTS`ordered`;CREATETABLE`ordered`(`Oid`int(6)unsignedzerofillNOTNULLAUTO_INCREMENT,`Cid`char(11)NOTNULL,`Mid`char(6)NOTNULL,`Sid`char(3)NOTNULL,`Odate`timestampNOTNULLDEFAULTCURRENT_TIMESTAMP,`Mshowtime`char(20)NOTNULL,`Off`char(1)NOTNULLDEFAULT'0',`Orevoke`char(1)DEFAULT'0',`Paid`char(10)NOTNULLDEFAULT'0',`Owill1`varchar(100)DEFAULTNULL,`Owill2`varchar(100)DEFAULTNULL,PRIMARYKEY(`Oid`))ENGINE=InnoDBAUTO_INCREMENT=33DEFAULTCHARSET=utf8;/*Dataforthetable`ordered`*/insertinto`ordered`(`Oid`,`Cid`,`Mid`,`Sid`,`Odate`,`Mshowtime`,`Off`,`Orevoke`,`Paid`,`Owill1`,`Owill2`)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),(000027,'','002','12','2016-07-2209:14:42','2016-07-2813:35','0','0','25',NULL,NULL);/*Tablestructurefortable`seat`*/DROPTABLEIFEXISTS`seat`;CREATETABLE`seat`(`Sfloeline`int(11)NOTNULLAUTO_INCREMENT,`Sid`char(3)NOTNULL,數(shù)據(jù)庫實(shí)現(xiàn)截圖：數(shù)據(jù)庫： 表：Customer：Seat：Movie:Ordered:界面設(shè)計(jì)”在線電影售票系統(tǒng)“設(shè)計(jì)的網(wǎng)頁界面，由我們?nèi)w項(xiàng)目組成員共同分析探討，設(shè)計(jì)到了如下的界面設(shè)計(jì)：由rose2000e繪制的界面關(guān)系圖：用戶關(guān)系圖：管理員關(guān)系圖：項(xiàng)目開發(fā)實(shí)現(xiàn)中的界面實(shí)現(xiàn)主要是界面的jsp文件：其中，管理員選擇添加