ssm租车系统，从放弃到开始，相信自己！自我调整，自我提高，自我提升

/* Navicat MySQL Data Transfer Source Server : 127.0.0.1 Source Server Version : 50527 Source Host : 127.0.0.1:3306 Source Database : carrent Target Server Type : MYSQL Target Server Version : 50527 File Encoding : 65001 Date: 2019-03-25 00:58:37 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for bus_cars -- ---------------------------- DROP TABLE IF EXISTS `bus_cars`; CREATE TABLE `bus_cars` ( `carnumber` varchar(255) DEFAULT NULL, `cartype` varchar(255) DEFAULT NULL, `color` varchar(255) DEFAULT NULL, `price` double DEFAULT NULL, `rentprice` double DEFAULT NULL, `deposit` double DEFAULT NULL, `isrenting` int(11) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `carimg` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bus_cars -- ---------------------------- INSERT INTO `bus_cars` VALUES ('dsfds', 'fdsfs', 'fd', '25', '5454', '5454', '1', '12121', '../upload/2019-03-24/201903240134134268847.png'); INSERT INTO `bus_cars` VALUES ('沪A123', '宝马', '红色', '123', '121', '1', '1', '权志龙', '../upload/2019-03-24/201903240133447821242.jpg'); -- ---------------------------- -- Table structure for bus_checks -- ---------------------------- DROP TABLE IF EXISTS `bus_checks`; CREATE TABLE `bus_checks` ( `checkid` varchar(255) NOT NULL, `checkdate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `checkdesc` varchar(255) DEFAULT NULL, `problem` varchar(255) DEFAULT NULL, `paymoney` double DEFAULT NULL, `opername` varchar(255) DEFAULT NULL, `rentid` varchar(255) DEFAULT NULL, PRIMARY KEY (`checkid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bus_checks -- ---------------------------- -- ---------------------------- -- Table structure for bus_customers -- ---------------------------- DROP TABLE IF EXISTS `bus_customers`; CREATE TABLE `bus_customers` ( `identity` varchar(255) DEFAULT NULL, `custname` varchar(255) DEFAULT NULL, `sex` int(11) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `career` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bus_customers -- ---------------------------- -- ---------------------------- -- Table structure for bus_rents -- ---------------------------- DROP TABLE IF EXISTS `bus_rents`; CREATE TABLE `bus_rents` ( `rentid` varchar(255) NOT NULL, `price` double DEFAULT NULL, `begindate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `returndate` datetime DEFAULT NULL, `rentflag` int(11) DEFAULT NULL, `identity` varchar(255) DEFAULT NULL, `carnumber` int(11) DEFAULT NULL, `opername` varchar(255) DEFAULT NULL, PRIMARY KEY (`rentid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bus_rents -- ---------------------------- -- ---------------------------- -- Table structure for sys_log_login -- ---------------------------- DROP TABLE IF EXISTS `sys_log_login`; CREATE TABLE `sys_log_login` ( `id` int(11) NOT NULL AUTO_INCREMENT, `loginname` varchar(255) DEFAULT NULL, `loginip` varchar(255) DEFAULT NULL, `logintime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of sys_log_login -- ---------------------------- INSERT INTO `sys_log_login` VALUES ('2', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-23 23:07:16'); INSERT INTO `sys_log_login` VALUES ('3', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-23 23:19:38'); INSERT INTO `sys_log_login` VALUES ('4', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-23 23:22:08'); INSERT INTO `sys_log_login` VALUES ('5', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-23 23:33:00'); INSERT INTO `sys_log_login` VALUES ('6', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-23 23:42:27'); INSERT INTO `sys_log_login` VALUES ('7', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 00:01:02'); INSERT INTO `sys_log_login` VALUES ('8', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 00:33:29'); INSERT INTO `sys_log_login` VALUES ('9', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 00:49:41'); INSERT INTO `sys_log_login` VALUES ('10', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 00:54:00'); INSERT INTO `sys_log_login` VALUES ('11', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 00:56:06'); INSERT INTO `sys_log_login` VALUES ('12', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 01:02:10'); INSERT INTO `sys_log_login` VALUES ('13', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 01:06:50'); INSERT INTO `sys_log_login` VALUES ('14', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 01:07:54'); INSERT INTO `sys_log_login` VALUES ('17', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 01:17:59'); INSERT INTO `sys_log_login` VALUES ('18', 'admin/null', '0:0:0:0:0:0:0:1', '2019-03-24 01:34:52'); INSERT INTO `sys_log_login` VALUES ('19', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:13:29'); INSERT INTO `sys_log_login` VALUES ('20', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:13:59'); INSERT INTO `sys_log_login` VALUES ('21', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:15:46'); INSERT INTO `sys_log_login` VALUES ('22', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:19:59'); INSERT INTO `sys_log_login` VALUES ('23', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:21:30'); INSERT INTO `sys_log_login` VALUES ('24', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:23:15'); INSERT INTO `sys_log_login` VALUES ('25', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:25:37'); INSERT INTO `sys_log_login` VALUES ('26', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:30:35'); INSERT INTO `sys_log_login` VALUES ('27', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:35:16'); INSERT INTO `sys_log_login` VALUES ('28', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:39:27'); INSERT INTO `sys_log_login` VALUES ('29', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:44:26'); INSERT INTO `sys_log_login` VALUES ('30', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:45:15'); INSERT INTO `sys_log_login` VALUES ('31', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:49:01'); INSERT INTO `sys_log_login` VALUES ('32', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:49:24'); INSERT INTO `sys_log_login` VALUES ('33', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:50:40'); INSERT INTO `sys_log_login` VALUES ('34', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 02:57:12'); INSERT INTO `sys_log_login` VALUES ('35', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:00:13'); INSERT INTO `sys_log_login` VALUES ('36', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:01:20'); INSERT INTO `sys_log_login` VALUES ('37', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:03:55'); INSERT INTO `sys_log_login` VALUES ('38', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:04:26'); INSERT INTO `sys_log_login` VALUES ('39', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:05:34'); INSERT INTO `sys_log_login` VALUES ('40', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:08:23'); INSERT INTO `sys_log_login` VALUES ('41', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:09:46'); INSERT INTO `sys_log_login` VALUES ('42', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:16:56'); INSERT INTO `sys_log_login` VALUES ('43', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:20:57'); INSERT INTO `sys_log_login` VALUES ('44', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:26:11'); INSERT INTO `sys_log_login` VALUES ('45', 'admin/zhangsan', '0:0:0:0:0:0:0:1', '2019-03-24 03:31:03'); INSERT INTO `sys_log_login` VALUES ('46', 'admin/zhangsan', '0: