电影院售票后台管理系统SpringBoot+AngularJS

/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50724 Source Host : localhost:3306 Source Database : keshe_02 Target Server Type : MYSQL Target Server Version : 50724 File Encoding : 65001 Date: 2018-12-27 11:43:56 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cinema -- ---------------------------- DROP TABLE IF EXISTS `cinema`; CREATE TABLE `cinema` ( `Movie_id` int(2) NOT NULL AUTO_INCREMENT, `Movie_name` varchar(255) NOT NULL COMMENT '电影名称', `actor` varchar(255) DEFAULT NULL COMMENT '男演员', `actress` varchar(50) DEFAULT NULL COMMENT '女演员', `producer` varchar(50) DEFAULT NULL COMMENT '导演', `playdate` datetime(6) NOT NULL COMMENT '播放日期', PRIMARY KEY (`Movie_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of cinema -- ---------------------------- INSERT INTO `cinema` VALUES ('1', '第六感生死缘', '布拉德皮特', '安东尼', '马丁布莱斯特', '2018-12-16 12:36:25.000000'); INSERT INTO `cinema` VALUES ('2', '拆弹部队', '杰瑞米', '雷纳', '凯瑟琳', '2018-12-16 12:37:31.000000'); -- ---------------------------- -- Table structure for info -- ---------------------------- DROP TABLE IF EXISTS `info`; CREATE TABLE `info` ( `ticketsid` int(2) NOT NULL AUTO_INCREMENT, `seatid` int(2) NOT NULL, `Movie_id` int(2) NOT NULL, `Movie_name` varchar(50) DEFAULT NULL COMMENT '电影名称', `playdate` datetime(6) NOT NULL COMMENT '播放日期', `price` double(8,2) NOT NULL, `yanzhengma` int(2) NOT NULL COMMENT '验证码', PRIMARY KEY (`ticketsid`), KEY `seatid` (`seatid`), KEY `Movie-id` (`Movie_id`), CONSTRAINT `Movie-id` FOREIGN KEY (`Movie_id`) REFERENCES `cinema` (`Movie_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `seatid` FOREIGN KEY (`seatid`) REFERENCES `seat` (`seatid`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info -- ---------------------------- INSERT INTO `info` VALUES ('1', '1', '2', '第六感生死缘', '2018-12-16 12:39:23.000000', '32.00', '25343'); -- ---------------------------- -- Table structure for position -- ---------------------------- DROP TABLE IF EXISTS `position`; CREATE TABLE `position` ( `workerid` int(2) NOT NULL AUTO_INCREMENT, `password` varchar(2) NOT NULL DEFAULT '' COMMENT '口令', `leibie` varchar(2) NOT NULL COMMENT '类别', PRIMARY KEY (`workerid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of position -- ---------------------------- INSERT INTO `position` VALUES ('1', 'qw', 'P1'); INSERT INTO `position` VALUES ('2', 'we', 'P2'); -- ---------------------------- -- Table structure for seat -- ---------------------------- DROP TABLE IF EXISTS `seat`; CREATE TABLE `seat` ( `seatid` int(2) NOT NULL AUTO_INCREMENT, `price` float(8,2) NOT NULL, `soldornot` smallint(2) NOT NULL, PRIMARY KEY (`seatid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of seat -- ---------------------------- INSERT INTO `seat` VALUES ('1', '32.00', '0'); INSERT INTO `seat` VALUES ('2', '32.00', '0'); INSERT INTO `seat` VALUES ('3', '32.00', '0'); INSERT INTO `seat` VALUES ('4', '40.00', '0'); -- ---------------------------- -- View structure for host_summary -- ---------------------------- DROP VIEW IF EXISTS `host_summary`; CREATE ALGORITHM=TEMPTABLE DEFINER=`mysql.sys`@`localhost` SQL SECURITY INVOKER VIEW `host_summary` AS select if(isnull(`performance_schema`.`accounts`.`HOST`),'background',`performance_schema`.`accounts`.`HOST`) AS `host`,sum(`stmt`.`total`) AS `statements`,`sys`.`format_time`(sum(`stmt`.`total_latency`)) AS `statement_latency`,`sys`.`format_time`(ifnull((sum(`stmt`.`total_latency`) / nullif(sum(`stmt`.`total`),0)),0)) AS `statement_avg_latency`,sum(`stmt`.`full_scans`) AS `table_scans`,sum(`io`.`ios`) AS `file_ios`,`sys`.`format_time`(sum(`io`.`io_latency`)) AS `file_io_latency`,sum(`performance_schema`.`accounts`.`CURRENT_CONNECTIONS`) AS `current_connections`,sum(`performance_schema`.`accounts`.`TOTAL_CONNECTIONS`) AS `total_connections`,count(distinct `performance_schema`.`accounts`.`USER`) AS `unique_users`,`sys`.`format_bytes`(sum(`mem`.`current_allocated`)) AS `current_memory`,`sys`.`format_bytes`(sum(`mem`.`total_allocated`)) AS `total_memory_allocated` from (((`performance_schema`.`accounts` join `sys`.`x$host_summary_by_statement_latency` `stmt` on((`performance_schema`.`accounts`.`HOST` = `stmt`.`host`))) join `sys`.`x$host_summary_by_file_io` `io` on((`performance_schema`.`accounts`.`HOST` = `io`.`host`))) join `sys`.`x$memory_by_host_by_current_bytes` `mem` on((`performance_schema`.`accounts`.`HOST` = `mem`.`host`))) group by if(isnull(`performance_schema`.`accounts`.`HOST`),'background',`performance_schema`.`accounts`.`HOST`) ; -- ---------------------------- -- View structure for host_summary_by_file_io -- ---------------------------- DROP VIEW IF EXISTS `host_summary_by_file_io`; CREATE ALGORITHM=TEMPTABLE DEFINER=`mysql.sys`@`localhost` SQL SECURITY INVOKER VIEW `host_summary_by_file_io` AS select if(isnull(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`),'background',`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`) AS `host`,sum(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`COUNT_STAR`) AS `ios`,`sys`.`format_time`(sum(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`SUM_TIMER_WAIT`)) AS `io_latency` from `performance_schema`.`events_waits_summary_by_host_by_event_name` where (`performance_schema`.`events_waits_summary_by_host_by_event_name`.`EVENT_NAME` like 'wait/io/file/%') group by if(isnull(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`),'background',`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`) order by sum(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`SUM_TIMER_WAIT`) desc ; -- ---------------------------- -- View structure for host_summary_by_file_io_type -- ---------------------------- DROP VIEW IF EXISTS `host_summary_by_file_io_type`; CREATE ALGORITHM=MERGE DEFINER=`mysql.sys`@`localhost` SQL SECURITY INVOKER VIEW `host_summary_by_file_io_type` AS select if(isnull(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`),'background',`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`) AS `host`,`performance_schema`.`events_waits_summary_by_host_by_event_name`.`EVENT_NAME` AS `event_name`,`performance_schema`.`events_waits_summary_by_host_by_event_name`.`COUNT_STAR` AS `total`,`sys`.`format_time`(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`SUM_TIMER_WAIT`) AS `total_latency`,`sys`.`format_time`(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`MAX_TIMER_WAIT`) AS `max_latency` from `performance_schema`.`events_waits_summary_by_host_by_event_name` where ((`performance_schema`.`events_waits_summary_by_host_by_event_name`.`EVENT_NAME` like 'wait/io/file%') and (`performance_schema`.`events_waits_summary_by_host_by_event_name`.`COUNT_STAR` > 0)) order by if(isnull(`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`),'background',`performance_schema`.`events_waits_summary_by_host_by_event_name`.`HOST`),`performance_schema`.`events_waits_summary_by_host_by_event_name`.`SUM_TIMER_WAIT` desc ; -- ---------------------------- -- View structure for host_summary_by_stages -- ---------------------------- DROP VIEW IF EXISTS `host_summary_by_stages`; CREATE ALGORITHM=MERGE DEFINER=`mysql.sys`@`localhost` SQL SECURITY INVOKER VIEW `host_summary_by_stag