基于javaweb的租车管理系统（汽车租赁）

介绍：

http://localhost:8080/car/login_login.do?role=1 前台

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

java，SSH框架，mysql，eclipse开发

效果截图

数据库表：

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’, ‘张总’);
INSERT INTO t_admin VALUES (‘2’, ‘testAdmin’, ‘0’, ‘000’, ‘测试管理员’);
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’, ‘苏A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘2’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘苏A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘6万’);
INSERT INTO t_car VALUES (‘3’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘苏A222222’, ‘123’, ‘123’, ‘100’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘4万’);
INSERT INTO t_car VALUES (‘4’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘苏A3333333’, ‘as’, ‘as’, ‘100’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘5万’);
INSERT INTO t_car VALUES (‘5’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘苏A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘7万’);
INSERT INTO t_car VALUES (‘6’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘苏A111111’, ‘12’, ‘12’, ‘100’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘4万’);
INSERT INTO t_car VALUES (‘7’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘苏A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘7万’);
INSERT INTO t_car VALUES (‘8’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘苏A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘9万’);
INSERT INTO t_car VALUES (‘9’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘苏A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘8万’);
INSERT INTO t_car VALUES (‘10’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘苏A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘11’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘苏A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘12’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘苏A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘13’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘苏A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘14’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘苏A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘8万’);
INSERT INTO t_car VALUES (‘15’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘苏A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘16’, ‘\upload\e22843d0c51a11e6681cae703dc644b166.jpg’, ‘苏A111111’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, null, ‘8万’);
INSERT INTO t_car VALUES (‘17’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘苏A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘18’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘苏A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘19’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘苏A3333333’, ‘as’, ‘12345’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘6万’);
INSERT INTO t_car VALUES (‘20’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘苏A444444’, ‘1234’, ‘333’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘21’, ‘\upload\2168bd40c51b11e6681cae703dc644b166.jpg’, ‘苏A123456’, ‘12’, ‘12’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘22’, ‘\upload\52bfc890c51e11e6f1561e41b2eda34269.jpg’, ‘苏A222222’, ‘123’, ‘123’, ‘200’, ‘1000’, ‘0’, ‘2’, ‘0’, ‘1’, ‘1’, null, ‘9万’);
INSERT INTO t_car VALUES (‘23’, ‘\upload\077e6430c52e11e6b9c23dd695d32eb9330619-141023093K534.jpg’, ‘苏A3333333’, ‘as’, ‘as’, ‘200’, ‘100’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘24’, ‘\upload\1091b900c9e811e6e7e1b8ec2a416551timg.jpg’, ‘苏A444444’, ‘1234’, ‘333’, ‘100’, ‘1000’, ‘0’, ‘2’, ‘0’, ‘1’, ‘1’, null, ‘5万’);
INSERT INTO t_car VALUES (‘25’, ‘\upload\b6ee0ad0c9eb11e6e7e1b8ec2a416551118011_090349063_2.jpg’, ‘苏A888888’, ‘1234’, ‘宝马X5’, ‘200’, ‘1000’, ‘0’, ‘1’, ‘0’, ‘1’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘26’, ‘\upload\88b981c0cc4411e6e3d78598213b3e8275.JPG’, ‘苏A55555’, ‘123’, ‘666’, ‘200’, ‘1000’, ‘0’, ‘3’, ‘0’, ‘1’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘27’, ‘\upload\2b028dd0ef3d11e698d18aa13da627af66.jpg’, ‘12321’, ‘12312’, ‘13123’, ‘200’, ‘1312’, ‘0’, ‘3’, ‘1’, ‘0’, ‘1’, null, ‘10万’);
INSERT INTO t_car VALUES (‘28’, ‘\upload\1a25e320155a11e7d7c6b9e29cd1965f99bOOOPICd5.jpg’, ‘123123’, ‘1231’, ‘123123’, ‘100’, ‘100’, ‘0’, ‘3’, ‘0’, ‘0’, ‘2’, ‘3’, ‘4万’);
INSERT INTO t_car VALUES (‘29’, ‘\upload\6cd77930155a11e769af77ac76dff906330619-141023093K534.jpg’, ‘333’, ‘333’, ‘3333’, ‘200’, ‘3333’, ‘0’, ‘3’, ‘0’, ‘0’, ‘2’, ‘3’, ‘6万’);
INSERT INTO t_car VALUES (‘30’, ‘\upload\d14a5900155a11e73296c92026fe3b08118011_090349063_2.jpg’, ‘444’, ‘444’, ‘444’, ‘100’, ‘444’, ‘0’, ‘1’, ‘0’, ‘0’, ‘2’, ‘3’, ‘4万’);
INSERT INTO t_car VALUES (‘31’, ‘\upload\fdf122a0162111e729df674e61913df375.JPG’, ‘999’, ‘999’, ‘999’, ‘200’, ‘999’, ‘0’, ‘4’, ‘0’, ‘1’, ‘2’, ‘3’, ‘6万’);
INSERT INTO t_car VALUES (‘32’, ‘\upload\e011ba90174511e76148c17aef2e459574.jpg’, ‘6666’, ‘6666’, ‘测试型号’, ‘200’, ‘200’, ‘0’, ‘4’, ‘0’, ‘1’, ‘2’, ‘3’, ‘8万’);
INSERT INTO t_car VALUES (‘33’, ‘\upload\7efb8760175211e793dd24d2c91bf54f1.jpg’, ‘zzzz’, ‘zzzz’, ‘zzzz’, ‘200’, ‘1000’, ‘0’, ‘4’, ‘0’, ‘1’, ‘2’, ‘4’, ‘8万’);
INSERT INTO t_car VALUES (‘34’, ‘\upload\088bc66018fd11e74798b24f5b17bd412.jpg’, ‘qqqq’, ‘qqqq’, ‘qqqq’, ‘200’, ‘2000’, ‘0’, ‘4’, ‘1’, ‘1’, ‘2’, ‘1’, ‘8万’);

源码下载：http://www.bycxy123.com/
视频演示：https://www.bilibili.com/video/BV1Ta4y1v7SG/