敲代码的小老头 2021-08-09 12:21:56 阅读数:542
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
INSERT INTO userinfo
VALUES (‘1’, ‘a’, ‘a’, ‘管理员’);
INSERT INTO userinfo
VALUES (‘2’, ‘b’, ‘b’, ‘售票员’);
INSERT INTO userinfo
VALUES (‘3’, ‘c’, ‘c’, ‘cus’);
– Table structure for xianlu
DROP TABLE IF EXISTS xianlu
;
CREATE TABLE xianlu
(
Id
int(11) NOT NULL AUTO_INCREMENT,
xh
int(11) DEFAULT NULL COMMENT ‘站点序号’,
tid
int(11) DEFAULT NULL COMMENT ‘车id’,
zdid
int(11) DEFAULT NULL COMMENT ‘站点id’,
PRIMARY KEY (Id
)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT=‘线路信息表’;
– Records of xianlu
INSERT INTO xianlu
VALUES (‘1’, ‘1’, ‘1’, ‘1’);
INSERT INTO xianlu
VALUES (‘2’, ‘2’, ‘1’, ‘2’);
总体来说,如果你想转行从事程序员的工作,Java开发一定可以作为你的第一选择。但是不管你选择什么编程语言,提升自己的硬件实力才是拿高薪的唯一手段。
如果你以这份学习路线来学习,你会有一个比较系统化的知识网络,也不至于把知识学习得很零散。我个人是完全不建议刚开始就看《Java编程思想》、《Java核心技术》这些书籍,看完你肯定会放弃学习。建议可以看一些视频来学习,当自己能上手再买这些书看又是非常有收获的事了。
这些视频如果需要的话,可以无偿分享给大家,点击这里即可免费领取
版权声明:本文为[敲代码的小老头]所创,转载请带上原文链接,感谢。 https://blog.51cto.com/u_15300758/3317936