汽车租赁系统web开发：java+SpringBoot+Mysql+Mybatis+BootStrap

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50562 Source Host : 127.0.0.1:3306 Source Database : car_rental Target Server Type : MYSQL Target Server Version : 50562 File Encoding : 65001 Date: 2021-06-05 18:30:52 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `admin_id` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `admin_pwd` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `creat_time` datetime DEFAULT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('admin', '123456', null); INSERT INTO `admin` VALUES ('company', '123456', null); -- ---------------------------- -- Table structure for car_brand -- ---------------------------- DROP TABLE IF EXISTS `car_brand`; CREATE TABLE `car_brand` ( `id` int(11) NOT NULL AUTO_INCREMENT, `brand` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `creat-time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of car_brand -- ---------------------------- INSERT INTO `car_brand` VALUES ('10', '大众', null); INSERT INTO `car_brand` VALUES ('14', '红旗', null); INSERT INTO `car_brand` VALUES ('15', '凯迪拉克', null); INSERT INTO `car_brand` VALUES ('16', '斯诺克', null); INSERT INTO `car_brand` VALUES ('17', '奇瑞', null); INSERT INTO `car_brand` VALUES ('21', '77', null); INSERT INTO `car_brand` VALUES ('22', '88', null); -- ---------------------------- -- Table structure for car_comment -- ---------------------------- DROP TABLE IF EXISTS `car_comment`; CREATE TABLE `car_comment` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `car_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment_detail` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `comment_time` datetime DEFAULT NULL, PRIMARY KEY (`comment_id`), KEY `user_id` (`user_id`), KEY `car_id` (`car_id`), CONSTRAINT `car_comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `car_comment_ibfk_3` FOREIGN KEY (`car_id`) REFERENCES `car_detail` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of car_comment -- ---------------------------- INSERT INTO `car_comment` VALUES ('3', '津KQ2545', '123', '这车还不错', '2021-05-08 14:23:26'); INSERT INTO `car_comment` VALUES ('4', '晋KQ2146', '111', '这车还不错', '2021-05-24 16:00:37'); INSERT INTO `car_comment` VALUES ('5', '津KQ6666', '789', '车辆还不错，开着感觉舒适', '2021-06-02 15:03:08'); INSERT INTO `car_comment` VALUES ('6', '晋AQ6830', '789', '车辆还不错，开着感觉舒适', '2021-06-02 15:03:18'); INSERT INTO `car_comment` VALUES ('7', '晋AQ2549', '789', '车辆还不错，开着感觉舒适', '2021-06-02 15:03:24'); INSERT INTO `car_comment` VALUES ('8', '晋KQ2146', '789', '车辆还不错，开着感觉舒适', '2021-06-02 15:03:31'); INSERT INTO `car_comment` VALUES ('9', '晋AQ2536', '123', '车辆还不错，开着感觉舒适', '2021-06-02 15:09:20'); INSERT INTO `car_comment` VALUES ('11', '晋AQ2533', '123', '车辆还不错，开着感觉舒适', '2021-06-02 15:10:26'); INSERT INTO `car_comment` VALUES ('12', '晋KQ2146', '111', '222', '2021-06-02 16:03:05'); INSERT INTO `car_comment` VALUES ('13', '津KQ8888', 'admin', '121212', '2021-06-05 18:08:13'); -- ---------------------------- -- Table structure for car_detail -- ---------------------------- DROP TABLE IF EXISTS `car_detail`; CREATE TABLE `car_detail` ( `id` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `car_brand_id` int(11) DEFAULT NULL, `car_type_id` int(11) DEFAULT NULL, `rent` decimal(10,0) DEFAULT NULL, `user_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `car_status` tinyint(4) DEFAULT NULL, `audit_status` tinyint(4) DEFAULT NULL, `seating` int(11) DEFAULT NULL, `age` int(255) DEFAULT NULL, `count` int(11) DEFAULT NULL, `is_lu` tinyint(255) DEFAULT NULL, `creat_time` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `car_brand_id` (`car_brand_id`), KEY `car_type_id` (`car_type_id`), KEY `user_id` (`user_id`), CONSTRAINT `car_detail_ibfk_1` FOREIGN KEY (`car_brand_id`) REFERENCES `car_brand` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `car_detail_ibfk_2` FOREIGN KEY (`car_type_id`) REFERENCES `car_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `car_detail_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`id`) ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of car_detail -- ---------------------------- INSERT INTO `car_detail` VALUES ('晋AQ2444', '17', '3', '600', 'admin', 'd99cfadc34e34ecdb3006a90b573840e.jpg', '0', '1', '4', '5', '1', '0', '2021-06-02 14:13:01'); INSERT INTO `car_detail` VALUES ('晋AQ2533', '17', '1', '630', '111', '585de189a2c04166b64fda8005e51c92.webp', '0', '1', '8', '3', '1', '0', null); INSERT INTO `car_detail` VALUES ('晋AQ2536', '15', '3', '881', '111', 'c27eef94d86d4e42977be142cd626335.jpg', '1', '1', '5', '5', '1', '0', null); INSERT INTO `car_detail` VALUES ('晋AQ2541', '10', '1', '580', '111', '71a916f33c584098b0027f642c71606b.jpg', '0', '1', '6', '3', '1', '1', null); INSERT INTO `car_detail` VALUES ('晋AQ2549', '10', '1', '580', '111', '6bc7381163584305b232d6c6cd449b19.webp', '0', '1', '4', '3', '1', '1', null); INSERT INTO `car_detail` VALUES ('晋AQ2553', '16', '3', '507', 'admin', '6b1c2ae30ff345d9bdd28b4077c11482.jpg', '1', '1', '4', '5', '1', '0', '2021-06-02 14:12:26'); INSERT INTO `car_detail` VALUES ('晋AQ2555', '14', '3', '530', '111', '34e0487678fc4436a75bbe4e7a5c4d4a.jpg', '0', '0', '5', '5', '1', '0', null); INSERT INTO `car_detail` VALUES ('晋AQ2586', '16', '3', '590', '111', '620a819324f24cd8b54ad5ba8f8ed95d.webp', '0', '0', '6', '5', '1', '0', null); INSERT INTO `car_detail` VALUES ('晋AQ3645', '17', '3', '650', '111', 'dfedd1e5d40449a3a4e23da97c59a424.jpg', '0', '0', '5', '5', '1', '0', '2021-06-02 13:57:30'); INSERT INTO `car_detail` VALUES ('晋AQ6830', '15', '1', '750', 'admin', 'a696cf5dc6b84fd58519add241f7bea8.jpg', '0', '1', '1', '2', '1', '1', '2021-06-02 14:11:46'); INSERT INTO `car_detail` VALUES ('晋KQ2146', '14', '1', '800', 'admin', '79c49035c0e84efab01f6a0dfb1a214c.png', '0', '1', '4', '3', '1', '1', null); INSERT INTO `car_detail` VALUES ('津KQ2146', '17', '1', '500', 'admin', '5d070d7a799b44fc9a72da479991ea87.jpg', '0', '1', '4', '5', '1', '0', null); INSERT INTO `car_detail` VALUES ('津KQ2545', '10', '1', '600', '456', '8e02574445b1472dbe473c68bb0d4616.jpg', '0', '1', '5', '5', '1', '0', null); INSERT INTO `car_detail` VALUES ('津KQ6666', '15', '1', '700', 'admin', 'a084b02d78f445d995aaf36fad2bbf0a.jpg', '0', '1', '5', '4', '1', '0', null); INSERT INTO `car_detail` VALUES ('津KQ8888', '14', '3', '500', 'admin', 'ea8c645959714d2d8dc3f0fae26238fc.png', '0', '1', '4', '3', '1', '0', null); INSERT INTO `car_detail` VALUES ('津KQ9999', '17', '1', '900', 'admin', '50d3223c47c54a7480f5cb9988b09560.jpg', '1', '1', '6', '4', '1', '0', null); -- ---------------------------- -- Table structure for car_type -- ---------------------------- DROP TABLE IF EXISTS `car_type`;