current position:Home>Java based car rental management system (car rental, 2021 Java factory interview experience sharing

Java based car rental management system (car rental, 2021 Java factory interview experience sharing

2021-08-28 10:09:22 Programmer day

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


– Records of t_admin


INSERT INTO t_admin VALUES (‘1’, ‘admin’, ‘0’, ‘000’, ‘ Zhang Zong ’);

INSERT INTO t_admin VALUES (‘2’, ‘testAdmin’, ‘0’, ‘000’, ‘ Test administrator ’);

INSERT INTO t_admin VALUES (‘3’, ‘13121321’, ‘0’, ‘000’, ‘1231’);


– Table structure for t_car


DROP TABLE IF EXISTS t_car;

CREATE TABLE t_car (

id int(11) NOT NULL AUTO_INCREMENT,

carImage varchar(255) DEFAULT NULL,

carNumber varchar(255) DEFAULT NULL,

carOilType varchar(255) DEFAULT NULL,

carType varchar(255) DEFAULT NULL,

dailyPrice varchar(255) DEFAULT NULL,

distance varchar(255) DEFAULT NULL,

isDelete int(11) NOT NULL,

car_category_id int(11) DEFAULT NULL,

isDiscount int(11) NOT NULL,

isRecommend int(11) NOT NULL,

flag int(11) NOT NULL,

user_id int(11) DEFAULT NULL,

carPrice varchar(255) DEFAULT NULL,

PRIMARY KEY (id),

KEY FK_1a6pqndequjgtklnv0bvl6mvy (car_category_id),

KEY FK_4eat59djtct2bv2nvcxhv46qo (user_id),

CONSTRAINT FK_1a6pqndequjgtklnv0bvl6mvy FOREIGN KEY (car_category_id) REFERENCES t_car_category (id),

CONSTRAINT FK_4eat59djtct2bv2nvcxhv46qo FOREIGN KEY (user_id) REFERENCES t_user (id)

) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;


– Records of t_car


INSERT INTO t_car VALUES (‘1’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘ Sue A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘2’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘ Sue A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘6 ten thousand ’);

INSERT INTO t_car VALUES (‘3’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘ Sue A222222’, ‘123’, ‘123’, ‘100’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘4 ten thousand ’);

INSERT INTO t_car VALUES (‘4’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘ Sue A3333333’, ‘as’, ‘as’, ‘100’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘5 ten thousand ’);

INSERT INTO t_car VALUES (‘5’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘ Sue A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘7 ten thousand ’);

INSERT INTO t_car VALUES (‘6’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘ Sue A111111’, ‘12’, ‘12’, ‘100’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘4 ten thousand ’);

INSERT INTO t_car VALUES (‘7’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘ Sue A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘7 ten thousand ’);

INSERT INTO t_car VALUES (‘8’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘ Sue A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘9 ten thousand ’);

INSERT INTO t_car VALUES (‘9’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘ Sue A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘8 ten thousand ’);

INSERT INTO t_car VALUES (‘10’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘ Sue A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘11’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘ Sue A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘12’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘ Sue A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘13’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘ Sue A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘14’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘ Sue A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘8 ten thousand ’);

INSERT INTO t_car VALUES (‘15’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘ Sue A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘16’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘ Sue A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘8 ten thousand ’);

INSERT INTO t_car VALUES (‘17’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘ Sue A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘18’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘ Sue A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘19’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘ Sue A3333333’, ‘as’, ‘12345’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘6 ten thousand ’);

INSERT INTO t_car VALUES (‘20’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘ Sue A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘21’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘ Sue A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘22’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘ Sue A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘0’, ‘1’, ‘1’, null, ‘9 ten thousand ’);

INSERT INTO t_car VALUES (‘23’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘ Sue A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘24’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘ Sue A444444’, ‘1234’, ‘333’, ‘100’, ‘1000’, ‘0’, ‘2’, ‘0’, ‘1’, ‘1’, null, ‘5 ten thousand ’);

INSERT INTO t_car VALUES (‘25’, ‘\upload\b6ee0ad0c9eb11e6e7e1b8ec2a416551118011_090349063_2.jpg’, ‘ Sue A888888’, ‘1234’, ‘ BMW X5’, ‘200’, ‘1000’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10 ten thousand ’);

INSERT INTO t_car VALUES (‘26’, ‘\upload\88b981c0cc4411e6e3d78598213b3e8275.JPG’, ‘ Sue A55555’, ‘123’, ‘666’, ‘200’, ‘1000’, ‘0’, ‘3’, ‘0’, ‘1’, ‘1’, null, ‘10 ten thousand ’);

Finally, share a wave ,Java Advanced knowledge points of core architecture

In fact, success in an interview is inevitable , Because I've done enough preparation before that , It's not just about writing questions , More will go to brush some Java Advanced knowledge points of core architecture , such as :JVM、 High concurrency 、 Multithreading 、 cache 、Spring relevant 、 Distributed 、 Microservices 、RPC、 The Internet 、 Design patterns 、MQ、Redis、MySQL、 Design patterns 、 Load balancing 、 Algorithm 、 data structure 、kafka、ZK、 Cluster etc. . And all of these have been condensed into one pdf——《Java Advanced knowledge points of core architecture 》, All are the cream of the essence. , In a win-win mentality , Good things should be shared

image

image

image

There are many contents , Space is limited , This is not too much introduction , According to the above screenshots, you can make up your own mind , But this one 《Java Advanced knowledge points of core architecture pdf》 And the front P8 The whole set of interview questions can be shared with you for free ,  Click here to get all the information in the article for free

copyright notice
author[Programmer day],Please bring the original link to reprint, thank you.
https://caren.inotgo.com/2021/08/20210828100920323i.html

Random recommended