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

1、在线电影购票系统设计文档第X组 XX一、 数据库设计“在线电影购票系统“是面向用户的一款系统，旨在让用户方便的在某个电影院在线购票，特此本系统的数据库设计如下：1“在线电影购票系统”的ER图和实体：ER图：实体：用户(Customer)、座位(Seat)、电影(Movie)、订单(Ordered)2.”在线电影购票系统”的表：推荐精选主要涉及上述四个表。推荐精选3.”在线电影购票系统“的数据库实现建立数据库的SQL语句：CREATE DATABASE /*!32312 IF NOT EXISTS*/cin_ticksystem /*!40100 DEFAULT CHARACTER SET ut

2、f8 */;USE cin_ticksystem;建立表和插入数据的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 utf

3、8 NOT NULL, 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

4、(Cid), KEY 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,

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

6、9;,'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 '', M

7、outdte char(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(10

8、0) 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,Mid,Mname,Moutdte,Moffdate,Mpicture,Mbrief,Mshowtime,Mprice,Mstatus,Cwill1,Cwill2) values (1,'001','大鱼海棠','&

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','时空恋旅人','','','

10、;','','2016-07-25 17:00','40','0',NULL,NULL),(4,'004','Superman','','','','','2016-08-03 15:20','25','0',NULL,NULL),(9,'005','魔兽','','','','',&#

11、39;2016-8-5 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 DEFAU

12、LT CURRENT_TIMESTAMP, 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

13、CHARSET=utf8;/*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

14、,'123','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)

15、,(000027,'#39;,'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) N

16、OT NULL,数据库实现截图：数据库：表：Customer：Seat：推荐精选Movie:Ordered:二、 界面设计”在线电影售票系统“设计的网页界面，由我们全体项目组成员共同分析探讨，设计到了如下的界面设计：1. 由rose2000e绘制的界面关系图：用户关系图：推荐精选管理员关系图：推荐精选2. 项目开发实现中的界面实现主要是界面的jsp文件：推荐精选其中，ad_movie.jsp管理员选择添加电影界面admin_movie.jsp管理员电影管理界admin.jsp管理员登录界面choose_seat.jsp购票选座界面cinema.jsp用户首页Dyht.jsp电影大鱼海棠界面get_cus.jsp查询用户信息界面get_ord.jsp查询订单信息界面index.jsp系统首页int_mv.jsp添加电影界面login.jsp登录界面menu.jsp菜单界面my_inf.jsp个人信息界面my_ord.