java基于ssm的电影院订票选座系统

技术：ssm+mysql+eclipse+tomcat+java

截图：

部分数据库：
CREATE TABLE allusers (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
pwd varchar(50) DEFAULT NULL,
cx varchar(50) DEFAULT ‘普通管理员’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

---

– Records of allusers

---

INSERT INTO allusers VALUES (‘2’, ‘hsg’, ‘hsg’, ‘超级管理员’, ‘2019-02-26 07:46:56’);

---

– Table structure for dx

---

DROP TABLE IF EXISTS dx;
CREATE TABLE dx (
ID int(11) NOT NULL AUTO_INCREMENT,
leibie varchar(50) DEFAULT NULL,
content longtext,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

---

– Records of dx

---

INSERT INTO dx VALUES (‘1’, ‘系统公告’, ‘

\r\n 欢迎大家登陆我站，我站主要是为广大朋友精心制作的一个系统，希望大家能够在我站获得一个好心情，谢谢！\r\n

\r\n

\r\n 自强不息，海纳百川，努力学习！wfwefASX啊X\r\n

’);
INSERT INTO dx VALUES (‘2’, ‘系统简介’, ‘系统简介hhrthrrrrr22ggg’);
INSERT INTO dx VALUES (‘3’, ‘关于我们’, ’    本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!

公司行为准则:忠信仁义，以人为本。
忠：即忠诚， 包括三重含义：企业忠于国家、忠于民族；企业忠于客户；员工忠于企业。
信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。
仁：即仁爱，上司对下属要仁爱、体贴，同事之间要关怀、友爱。
义：即大义，公司在与合作伙伴、客户的交往过程中，不做损人利己的事，维护自己利益的前提是不损害他人利益；对民族、社会要共襄义举，要识大义，明是非。
');
INSERT INTO dx VALUES (‘4’, ‘联系方式’, ‘联系人：xxxxxxxx
电话：0000-0000000
手机：010000000000
传真：0000-0000000
邮件：xxxxxxxx@163.com
地址：您公司的地址
网址：http://www.xxxx.com
’);
INSERT INTO dx VALUES (‘6’, ‘影院简介’, ‘影院简介wfefweASX’);

---

– Table structure for goupiaojilu

---

DROP TABLE IF EXISTS goupiaojilu;
CREATE TABLE goupiaojilu (
id int(11) NOT NULL AUTO_INCREMENT,
yingpianmingcheng varchar(50) DEFAULT NULL,
yingpianleibie varchar(50) DEFAULT NULL,
shangyingshijian varchar(50) DEFAULT NULL,
piaojia varchar(50) DEFAULT NULL,
shuliang varchar(50) DEFAULT NULL,
jine varchar(50) DEFAULT NULL,
xuanzezuowei varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
goupiaoren varchar(50) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
iszf varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;

---

– Records of goupiaojilu

---

INSERT INTO goupiaojilu VALUES (‘2’, ‘P影片’, ‘E类’, ‘2019-01-29’, ‘52’, ‘48’, ‘2496’, ‘0606；0806；’, ‘暂无’, ‘017’, ‘是’, ‘是’, ‘2019-02-26 11:27:44’);
INSERT INTO goupiaojilu VALUES (‘3’, ‘E影片’, ‘P类’, ‘2019-03-08’, ‘78’, ‘45’, ‘3510’, ‘’, ‘ok’, ‘016’, ‘是’, ‘是’, ‘2019-02-26 11:27:44’);
INSERT INTO goupiaojilu VALUES (‘4’, ‘G影片’, ‘E类’, ‘2019-03-08’, ‘52’, ‘48’, ‘2496’, ‘’, ‘ok’, ‘003’, ‘是’, ‘是’, ‘2019-02-26 11:27:44’);
INSERT INTO goupiaojilu VALUES (‘5’, ‘G影片’, ‘E类’, ‘2019-03-08’, ‘52’, ‘33’, ‘1716’, ‘’, ‘没问题’, ‘007’, ‘是’, ‘是’, ‘2019-02-26 11:27:44’);
INSERT INTO goupiaojilu VALUES (‘7’, ‘P影片’, ‘E类’, ‘2019-01-29’, ‘52’, ‘2’, ‘104’, ‘0606；0806；’, ‘’, ‘001’, ‘否’, ‘是’, ‘2019-02-26 03:33:24’);
INSERT INTO goupiaojilu VALUES (‘8’, ‘B影片’, ‘E类’, ‘2019-03-08’, ‘46’, ‘2’, ‘92’, ‘0505；0605；’, ‘’, ‘001’, ‘否’, ‘是’, ‘2019-02-26 03:39:11’);
INSERT INTO goupiaojilu VALUES (‘10’, ‘P影片’, ‘E类’, ‘2019-01-29’, ‘52’, ‘1’, ‘52’, ‘0306；’, ‘’, ‘001’, ‘否’, ‘是’, ‘2019-02-26 04:14:09’);
INSERT INTO goupiaojilu VALUES (‘11’, ‘M影片’, ‘A类’, ‘2019-03-08’, ‘52’, ‘2’, ‘104’, ‘0604；0705；’, ‘’, ‘001’, ‘是’, ‘是’, ‘2019-02-26 11:15:10’);
INSERT INTO goupiaojilu VALUES (‘12’, ‘E影片’, ‘P类’, ‘2019-03-08’, ‘78’, ‘2’, ‘156’, ‘0506；0606；’, ‘’, ‘555’, ‘否’, ‘是’, ‘2019-02-26 04:28:03’);
INSERT INTO goupiaojilu VALUES (‘13’, ‘B影片’, ‘E类’, ‘2019-03-08’, ‘46’, ‘3’, ‘138’, ‘0506；0806；0804；’, ‘’, ‘555’, ‘是’, ‘是’, ‘2019-02-26 16:41:15’);
INSERT INTO goupiaojilu VALUES (‘16’, ‘第三种爱情’, ‘爱情片’, ‘2019-04-14’, ‘200’, ‘5’, ‘1000’, ‘0104；0305；0607；0707；0807；’, ‘asx’, ‘888’, ‘是’, ‘是’, ‘2019-04-14 02:41:50’);

---

– Table structure for liuyanban

---

DROP TABLE IF EXISTS liuyanban;
CREATE TABLE liuyanban (
id int(11) NOT NULL AUTO_INCREMENT,
cheng varchar(50) DEFAULT NULL,
xingbie varchar(50) DEFAULT NULL,
QQ varchar(50) DEFAULT NULL,
youxiang varchar(50) DEFAULT NULL,
shouji varchar(50) DEFAULT NULL,
neirong varchar(500) DEFAULT NULL,
huifuneirong varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;

---

– Records of liuyanban

---

INSERT INTO liuyanban VALUES (‘2’, ‘001’, ‘1’, ‘3263266’, ‘43643933@qq.com’, ‘17505772420’, ‘rh’, null, ‘2019-02-26 01:13:31’);
INSERT INTO liuyanban VALUES (‘14’, ‘fwef’, ‘2’, ‘’, ‘df@dkdk.com’, ‘13888888888’, ‘wfe’, ‘adf’, ‘2019-02-26 11:16:01’);
INSERT INTO liuyanban VALUES (‘15’, ‘wfe’, ‘1’, ‘’, ‘abc@abc.com’, ‘13888888888’, ‘fwewfe’, ‘wefASC按顺序啊’, ‘2019-02-26 16:41:58’);
INSERT INTO liuyanban VALUES (‘16’, ‘999’, ‘2’, ‘1451754085’, ‘1451754085@qq.com’, ‘15179072520’, ‘我的’, null, ‘2019-04-14 02:29:27’);

---

– Table structure for pinglun

---

DROP TABLE IF EXISTS pinglun;
CREATE TABLE pinglun (
ID int(11) NOT NULL AUTO_INCREMENT,
xinwenID varchar(10) DEFAULT NULL,
pinglunneirong varchar(500) DEFAULT NULL,
pinglunren varchar(20) DEFAULT NULL,
pingfen varchar(4) DEFAULT NULL,
biao varchar(20) DEFAULT NULL,
addtime timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

---

– Records of pinglun

---

INSERT INTO pinglun VALUES (‘12’, ‘3’, ‘gs’, ‘001’, ‘5’, ‘yingpianxinxi’, ‘2019-02-26 10:56:43’);
INSERT INTO pinglun VALUES (‘13’, ‘3’, ‘’, ‘001’, ‘1’, ‘yingpianxinxi’, ‘2019-02-26 10:59:38’);
INSERT INTO pinglun VALUES (‘14’, ‘4’, ‘gsg’, ‘001’, ‘5’, ‘yingpianxinxi’, ‘2019-02-26 11:14:43’);
INSERT INTO pinglun VALUES (‘15’, ‘5’, ‘伟鹏w’, ‘555’, ‘5’, ‘yingpianxinxi’, ‘2019-02-26 16:40:56’);
INSERT INTO pinglun VALUES (‘16’, ‘10’, ‘AXAS’, ‘888’, ‘4’, ‘yingpianxinxi’, ‘2019-04-14 02:38:06’);