current position:Home>The car rental management system based on Java (car rental (1), the analysis and summary of Alibaba P7 boss, is true and in place

The car rental management system based on Java (car rental (1), the analysis and summary of Alibaba P7 boss, is true and in place

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

http://localhost:8080/car/login_login.do?role=2 backstage

java,SSH frame ,mysql,eclipse Development

Effect screenshots

 Insert picture description here

 Insert picture description here

 Insert picture description here

 Insert picture description here

 Insert picture description here

 Insert picture description here

 Insert picture description here

Database table :

CREATE TABLE t_admin (

id int(11) NOT NULL AUTO_INCREMENT,

adminName varchar(255) DEFAULT NULL,

isDelete int(11) NOT NULL,

passWord varchar(255) DEFAULT NULL,

realName varchar(255) DEFAULT NULL,

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 ’);

Last

This time I want to share with you the summary of things that are

All the information is in ——  My study notes : The real interview question of Dachang + Microservices +MySQL+Java+Redis+ Algorithm + The Internet +Linux+Spring Family bucket +JVM+ Study note map

Finally, share a big gift bag of the ultimate hand tearing Architecture ( Learning notes ): Distributed + Microservices + Open source framework + performance optimization

image

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

Random recommended