基于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