Online train ticket purchase system based on Java JSP, Devops life cycle

Little old man typing code 2021-08-09 12:23:40 阅读数:477

本文一共[544]字,预计阅读时长:1分钟~
online train ticket purchase based

DROP TABLE IF EXISTS piao;

CREATE TABLE piao (

Id int(11) NOT NULL AUTO_INCREMENT,

tid varchar(255) DEFAULT NULL COMMENT ‘ vehicle id’,

szdid int(11) DEFAULT NULL COMMENT ‘ Originating site id’,

ezdid int(11) DEFAULT NULL COMMENT ‘ Destination site id’,

stime varchar(255) DEFAULT NULL COMMENT ‘ Departure time ’,

pval float DEFAULT NULL COMMENT ‘ The fare ’,

cxzh varchar(255) DEFAULT NULL COMMENT ‘ Car seat number ’,

ptype varchar(255) DEFAULT NULL COMMENT ‘ Ticket type ’,

yxsj datetime DEFAULT NULL COMMENT ‘ The effective date ’,

PRIMARY KEY (Id)

) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT=‘ Ticket information sheet ’;


– Records of piao


INSERT INTO piao VALUES (‘1’, ‘1’, ‘1’, ‘2’, ‘07:30:00’, ‘50’, ‘ A carriage 20 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘2’, ‘1’, ‘8’, ‘9’, ‘8:20:00’, ‘50’, ‘1 Carriage 22 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘3’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘ Second carriage 33 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘4’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘ Second carriage 32 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘5’, ‘1’, ‘8’, ‘9’, ‘8:00’, ‘50’, ‘ Second carriage 31 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘6’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘ Second carriage 01 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘7’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘ Second carriage 02 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘8’, ‘1’, ‘1’, ‘3’, ‘8:00’, ‘50’, ‘ Second carriage 03 Number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘9’, ‘3’, ‘1’, ‘4’, ‘7:00’, ‘10’, ‘ A carriage 12 Seat number ’, ‘ Soft sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘10’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12 Carriage 12 Seat number ’, ‘ Soft sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘11’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12 Carriage 12 Seat number ’, ‘ Soft sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘12’, ‘1’, ‘1’, ‘3’, ‘09:31:00’, ‘120’, ‘12 Carriage 12 Seat number ’, ‘ Soft sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘13’, ‘3’, ‘1’, ‘4’, ‘10:30’, ‘100’, ‘12 Carriage 12 Seat number ’, ‘ Hard seat ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘14’, ‘2’, ‘1’, ‘3’, ‘12:12’, ‘100’, ‘12 Carriage 12 Seat number ’, ‘ Soft sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘15’, ‘2’, ‘1’, ‘3’, ‘12:30’, ‘100’, ‘1 vehicle 13 seat ’, ‘ Hard sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘16’, ‘2’, ‘1’, ‘3’, ‘12:30’, ‘100’, ‘1 vehicle 12 seat ’, ‘ Hard sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘17’, ‘3’, ‘6’, ‘3’, ‘14:00’, ‘100’, ‘ A carriage 15 seat ’, ‘ Hard sleeper ’, ‘2019-04-19 00:00:00’);

INSERT INTO piao VALUES (‘18’, ‘1’, ‘1’, ‘2’, ‘10:12’, ‘190’, ‘ A carriage 12 seat ’, ‘ Soft sleeper ’, ‘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 ‘ A multitude ’,

cz varchar(255) DEFAULT NULL COMMENT ‘ conductor ’,

znums varchar(255) DEFAULT NULL COMMENT ‘ Total number of seats ’,

xcnums varchar(255) DEFAULT NULL COMMENT ‘ Limited number of passengers ’,

traintype varchar(255) DEFAULT NULL COMMENT ‘ Train type ’,

PRIMARY KEY (Id)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT=‘ Train information sheet ’;


– Records of traininfo


INSERT INTO traininfo VALUES (‘1’, ‘k100’, ‘ Zhang San ’, ‘400’, ‘400’, ‘ Express ’);

INSERT INTO traininfo VALUES (‘2’, ‘t200’, ‘ Li Si ’, ‘100’, ‘105’, ‘ Express ’);

INSERT INTO traininfo VALUES (‘3’, ‘t123’, ‘ Li Si ’, ‘400’, ‘450’, ‘ Express ’);


– 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 ‘ account number ’,

upassword varchar(255) DEFAULT NULL COMMENT ‘ password ’,

utype varchar(255) DEFAULT NULL COMMENT ‘ jurisdiction ’,

PRIMARY KEY (Id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=‘ Administrator information table ’;


– Records of userinfo


INSERT INTO userinfo VALUES (‘1’, ‘a’, ‘a’, ‘ Administrators ’);

INSERT INTO userinfo VALUES (‘2’, ‘b’, ‘b’, ‘ conductor ’);

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 ‘ Site serial number ’,

tid int(11) DEFAULT NULL COMMENT ‘ vehicle id’,

zdid int(11) DEFAULT NULL COMMENT ‘ Site id’,

PRIMARY KEY (Id)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT=‘ Line information sheet ’;


– Records of xianlu


INSERT INTO xianlu VALUES (‘1’, ‘1’, ‘1’, ‘1’);

INSERT INTO xianlu VALUES (‘2’, ‘2’, ‘1’, ‘2’);

summary

On the whole , If you want to change your career to work as a programmer ,Java Development must be your first choice . But no matter what programming language you choose , Improving your hardware strength is the only way to get a high salary .

If you follow this learning route , You will have a more systematic knowledge network , It's not like learning knowledge in a scattered way . Personally, I don't recommend watching... At the beginning 《Java Programming idea 》、《Java The core technology 》 These books , After reading it, you will definitely give up studying . It is suggested that you can watch some videos to learn , It's very rewarding to buy these books when you can get started .

These videos, if needed , I can share it with you free of charge , Click here to get it for free

版权声明:本文为[Little old man typing code]所创,转载请带上原文链接,感谢。 https://car.inotgo.com/2021/08/20210809122037205J.html