– Table structure for dpiao
DROP TABLE IF EXISTS dpiao
;
CREATE TABLE dpiao
(
Id
int(11) NOT NULL AUTO_INCREMENT,
cidcard
varchar(255) DEFAULT NULL COMMENT ‘身份证号’,
pid
int(11) DEFAULT NULL COMMENT ‘票id’,
lyflag
varchar(255) DEFAULT NULL COMMENT ‘订票状态’,
PRIMARY KEY (Id
)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT=‘订票信息表’;
– Records of dpiao
INSERT INTO dpiao
VALUES (‘2’, ‘110’, ‘9’, ‘已领票’);
INSERT INTO dpiao
VALUES (‘3’, ‘2’, ‘13’, ‘已付款’);
INSERT INTO dpiao
VALUES (‘4’, ‘2’, ‘14’, ‘已领票’);
INSERT INTO dpiao
VALUES (‘9’, ‘2’, ‘2’, ‘待付款’);
INSERT INTO dpiao
VALUES (‘10’, ‘2’, ‘4’, ‘待付款’);
– Table structure for piao
DROP TABLE IF EXISTS piao
;
CREATE TABLE piao
(
Id
int(11) NOT NULL AUTO_INCREMENT,
tid
varchar(255) DEFAULT NULL COMMENT ‘车id’,
szdid
int(11) DEFAULT NULL COMMENT ‘始发站点id’,
ezdid
int(11) DEFAULT NULL COMMENT ‘目的站点id’,
stime
varchar(255) DEFAULT NULL COMMENT ‘发车时间’,
pval
float DEFAULT NULL COMMENT ‘票价’,
cxzh
varchar(255) DEFAULT NULL COMMENT ‘车厢座号’,
ptype
varchar(255) DEFAULT NULL COMMENT ‘车票类型’,
yxsj
datetime DEFAULT NULL COMMENT ‘有效日期’,
PRIMARY KEY (Id
)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT=‘车票信息表’;
– Records of piao
INSERT INTO piao
VALUES (‘1’, ‘1’, ‘1’, ‘2’, ‘07:30:00’, ‘50’, ‘一车厢20号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘2’, ‘1’, ‘8’, ‘9’, ‘8:20:00’, ‘50’, ‘1车厢22号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘3’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘二车厢33号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘4’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘二车厢32号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘5’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘二车厢31号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘6’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘二车厢01号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘7’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘二车厢02号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘8’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘二车厢03号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘9’, ‘3’, ‘1’, ‘4’, ‘7:00’, ‘10’, ‘一车厢12座号’, ‘软卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘10’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12车厢12座号’, ‘软卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘11’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12车厢12座号’, ‘软卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘12’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12车厢12座号’, ‘软卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘13’, ‘3’, ‘1’, ‘4’, ‘10:30’, ‘100’, ‘12车厢12座号’, ‘硬座’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘14’, ‘2’, ‘1’, ‘3’, ‘12:12’, ‘100’, ‘12车厢12座号’, ‘软卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘15’, ‘2’, ‘1’, ‘3’, ‘12:30’, ‘100’, ‘1车13座’, ‘硬卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘16’, ‘2’, ‘1’, ‘3’, ‘12:30’, ‘100’, ‘1车12座’, ‘硬卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘17’, ‘3’, ‘6’, ‘3’, ‘14:00’, ‘100’, ‘一车厢15座’, ‘硬卧’, ‘2019-04-19 00:00:00’);
INSERT INTO piao
VALUES (‘18’, ‘1’, ‘1’, ‘2’, ‘10:12’, ‘190’, ‘一车厢12座’, ‘软卧’, ‘2019-04-19 00:00:00’);
– Table structure for traininfo
DROP TABLE IF EXISTS traininfo
;
CREATE TABLE traininfo
(
Id
int(11) NOT NULL AUTO_INCREMENT,
tname
varchar(255) DEFAULT NULL COMMENT ‘车名’,
cz
varchar(255) DEFAULT NULL COMMENT ‘车长’,
znums
varchar(255) DEFAULT NULL COMMENT ‘总座位数’,
xcnums
varchar(255) DEFAULT NULL COMMENT ‘限乘人数’,
traintype
varchar(255) DEFAULT NULL COMMENT ‘火车类型’,
PRIMARY KEY (Id
)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT=‘火车信息表’;
– Records of traininfo
INSERT INTO traininfo
VALUES (‘1’, ‘k100’, ‘张三’, ‘400’, ‘400’, ‘特快’);
INSERT INTO traininfo
VALUES (‘2’, ‘t200’, ‘李四’, ‘100’, ‘105’, ‘特快’);
INSERT INTO traininfo
VALUES (‘3’, ‘t123’, ‘李四’, ‘400’, ‘450’, ‘特快’);
– Table structure for userinfo
DROP TABLE IF EXISTS userinfo
;
CREATE TABLE userinfo
(
Id
int(11) NOT NULL AUTO_INCREMENT,
uname
varchar(255) DEFAULT NULL COMMENT ‘账号’,
upassword
varchar(255) DEFAULT NULL COMMENT ‘密码’,
utype
varchar(255) DEFAULT NULL COMMENT ‘权限’,
PRIMARY KEY (Id
)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=‘管理员信息表’;
– Records of userinfo
最后
针对最近很多人都在面试,我这边也整理了相当多的面试专题资料,也有其他大厂的面经。希望可以帮助到大家。
上述的面试题答案都整理成文档笔记。 也还整理了一些面试资料&最新2021收集的一些大厂的面试真题(都整理成文档,小部分截图)
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。
在面试,我这边也整理了相当多的面试专题资料,也有其他大厂的面经。希望可以帮助到大家。
[外链图片转存中…(img-V1VXfKKu-1714653666160)]
上述的面试题答案都整理成文档笔记。 也还整理了一些面试资料&最新2021收集的一些大厂的面试真题(都整理成文档,小部分截图)
[外链图片转存中…(img-GRdo4zfd-1714653666160)]
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。