基于Spring+SpringMVC+Mybatis开发的航空订票系统
chengrenpiaojia int(11) DEFAULT NULL,
ertongpiaojia int(11) DEFAULT NULL,
del varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of t_hangban
INSERT INTO t_hangban VALUES (‘2’, ‘2018-02-20’, ‘H001’, ‘北京’, ‘青岛’, ‘08:00:00’, ‘190’, ‘200’, ‘150’, ‘yes’);
INSERT INTO t_hangban VALUES (‘3’, ‘2018-02-20’, ‘H002’, ‘北京’, ‘大连’, ‘09:00:00’, ‘197’, ‘180’, ‘120’, ‘no’);
INSERT INTO t_hangban VALUES (‘4’, ‘2018-02-20’, ‘H003’, ‘北京’, ‘南京’, ‘10:00:00’, ‘198’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘5’, ‘2018-02-07’, ‘MU1818’, ‘北京’, ‘上海’, ‘16:00:00’, ‘197’, ‘1590’, ‘1288’, ‘yes’);
INSERT INTO t_hangban VALUES (‘6’, ‘2018-12-31’, ‘CA1110’, ‘北京’, ‘成都’, ‘12:00:00’, ‘196’, ‘990’, ‘698’, ‘no’);
INSERT INTO t_hangban VALUES (‘7’, ‘2018-05-27’, ‘MU1818’, ‘北京’, ‘上海’, ‘12:00:00’, ‘195’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘8’, ‘2018-05-20’, ‘MU1818’, ‘北京’, ‘武汉’, ‘12:00:00’, ‘186’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘9’, ‘2018-03-21’, ‘C9191’, ‘北京’, ‘上海’, ‘12:00:00’, ‘200’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘10’, ‘2018-03-22’, ‘C888’, ‘四川’, ‘北京’, ‘12:00:00’, ‘176’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘11’, ‘2018-03-24’, ‘C9191’, ‘成都’, ‘北京’, ‘12:00:00’, ‘200’, ‘100’, ‘50’, ‘no’);
INSERT INTO t_hangban VALUES (‘12’, ‘2018-03-24’, ‘111’, ‘11’, ‘111’, ‘12:00:00’, ‘200’, ‘100’, ‘50’, ‘yes’);
– Table structure for t_liuyan
DROP TABLE IF EXISTS t_liuyan;
CREATE TABLE t_liuyan (
id int(11) NOT NULL,
neirong varchar(4000) DEFAULT NULL,
liuyanshi varchar(55) DEFAULT NULL,
userId int(11) DEFAULT NULL,
huifu varchar(4000) DEFAULT NULL,
huifushi varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of t_liuyan
INSERT INTO t_liuyan VALUES (‘3’, ‘测试留言板测试类测试留言板测试测试留言板测试’, ‘2018-02-11 16:33’, ‘1’, ‘wwwwwwwwwwwwwwwwwwwwwwwww’, ‘2018-03-11 16:34’);
INSERT INTO t_liuyan VALUES (‘5’, ‘有没有特价机票啊？？？’, ‘2018-08-06 20:51’, ‘4’, ‘1221’, ‘2018-03-23 16:09’);
INSERT INTO t_liuyan VALUES (‘6’, ‘123123’, ‘2018-03-23 16:16’, ‘2’, ‘’, ‘’);
INSERT INTO t_liuyan VALUES (‘7’, ‘ceshi11111111111’, ‘2018-03-23 16:41’, ‘2’, ‘’, ‘’);
– Table structure for t_order
DROP TABLE IF EXISTS t_order;
CREATE TABLE t_order (
id varchar(255) NOT NULL DEFAULT ‘’,
userId int(11) DEFAULT NULL,
xiadanshi varchar(255) DEFAULT NULL,
shouhourenming varchar(255) DEFAULT NULL,
shouhourenhua varchar(255) DEFAULT NULL,
shouhourenzhi varchar(255) DEFAULT NULL,
zongjiage int(11) DEFAULT NULL,
zhuangtai varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of t_order
INSERT INTO t_order VALUES (‘1438865495737’, ‘4’, ‘2018-08-06 08:51:35’, ‘高圆圆’, ‘13255555555’, ‘中国北京市’, ‘3180’, ‘已受理’);
INSERT INTO t_order VALUES (‘1464197933831’, ‘5’, ‘2018-05-26 01:38:53’, ‘qinb’, ‘12365498732’, ‘湖北武汉’, ‘580’, ‘已受理’);
INSERT INTO t_order VALUES (‘1521794443359’, ‘2’, ‘2018-03-23 04:40:43’, ‘测试2’, ‘16765456765’, ‘北京’, ‘100’, ‘未受理’);
INSERT INTO t_order VALUES (‘1522040268671’, ‘2’, ‘2018-03-26 12:57:48’, ‘1’, ‘19767876565’, ‘1’, ‘0’, ‘未受理’);
INSERT INTO t_order VALUES (‘1522047726879’, ‘2’, ‘2018-03-26 03:02:06’, ‘黄晓明’, ‘16765456765’, ‘是的发送到发送到’, ‘200’, ‘未受理’);
INSERT INTO t_order VALUES (‘1522058210543’, ‘2’, ‘2018-03-26 05:56:50 《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》无偿开源 威信搜索公众号【编程进阶路】 ’, ‘11’, ‘19767876565’, ‘123123123’, ‘1980’, ‘未受理’);
INSERT INTO t_order VALUES (‘1522058251064’, ‘2’, ‘2018-03-26 05:57:31’, ‘123123’, ‘16765456765’, ‘123123’, ‘1980’, ‘未受理’);
– Table structure for t_orderitem
DROP TABLE IF EXISTS t_orderitem;
CREATE TABLE t_orderitem (
id varchar(255) NOT NULL DEFAULT ‘’,
orderId varchar(255) DEFAULT NULL,
hangbanId int(11) DEFAULT NULL,
piaoleixing varchar(255) DEFAULT NULL,
danjia int(11) DEFAULT NULL,
shuliang int(11) DEFAULT NULL,
zuoweihao varchar(100) DEFAULT NULL,
zwIndex varchar(100) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of t_orderitem