介绍:
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万’);