java基于ssm的航空订票（机票预订）系统

基于Spring+SpringMVC+Mybatis开发的航空订票系统air

技术：ssm+mysql

数据库表：
CREATE TABLE t_admin (
userId int(11) NOT NULL,
userName varchar(50) DEFAULT NULL,
userPw varchar(50) DEFAULT NULL,
PRIMARY KEY (userId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of t_admin

---

INSERT INTO t_admin VALUES (‘1’, ‘admin’, ‘admin’);

---

– Table structure for t_hangban

---

DROP TABLE IF EXISTS t_hangban;
CREATE TABLE t_hangban (
id int(11) NOT NULL DEFAULT ‘0’,
riqi varchar(255) DEFAULT NULL,
bianhao varchar(255) DEFAULT NULL,
shifadi varchar(255) DEFAULT NULL,
daodadi varchar(255) DEFAULT NULL,
qifeishi varchar(255) DEFAULT NULL,
shengpiao int(11) DEFAULT NULL,
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