毕设第一天
程序员文章站
2022-07-01 15:16:09
...
毕业设计是车辆维修管理系统，前台采用layui框架，后台采用ssm技术，数据库mysql。
数据表
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50540
Source Host : localhost:3306
Source Database : car
Target Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001
Date: 2020-03-24 17:22:29
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`supplier_id` varchar(11) DEFAULT NULL,
`supplier_name` varchar(20) DEFAULT NULL,
`operatorId` varchar(255) DEFAULT NULL,
`paymoney` double(10,2) DEFAULT NULL,
`ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
KEY `userid` (`supplier_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', '1', '666666', null, '10000.00', '2019-07-16 10:57:19');
INSERT INTO `account` VALUES ('2', '1', '55', null, '111.00', '2019-07-16 11:15:37');
INSERT INTO `account` VALUES ('3', '1', '2', null, '23.00', '2019-07-17 15:30:31');
-- ----------------------------
-- Table structure for car_info
-- ----------------------------
DROP TABLE IF EXISTS `car_info`;
CREATE TABLE `car_info` (
`id` varchar(255) NOT NULL,
`plate` varchar(255) NOT NULL,
`user_id` varchar(255) NOT NULL,
`brand` varchar(255) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`color` varchar(255) DEFAULT NULL,
`price` varchar(255) DEFAULT NULL,
`date` timestamp NULL DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of car_info
-- ----------------------------
INSERT INTO `car_info` VALUES ('1', '鄂A KJ598', '1', '奔驰', 'c200', '黑色', '40万', '2020-02-21 00:00:00', '', 'user1');
-- ----------------------------
-- Table structure for notice_info
-- ----------------------------
DROP TABLE IF EXISTS `notice_info`;
CREATE TABLE `notice_info` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of notice_info
-- ----------------------------
-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
`id` varchar(255) NOT NULL,
`user_id` varchar(255) NOT NULL,
`user_name` varchar(255) NOT NULL,
`plate` varchar(255) NOT NULL,
`trouble_name` varchar(255) DEFAULT NULL,
`trouble_code` varchar(255) NOT NULL,
`contact` varchar(255) NOT NULL,
`contact_way` varchar(255) NOT NULL,
`remark` varchar(255) DEFAULT NULL,
`long_time` bigint(20) DEFAULT NULL,
`creart_time` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT NULL COMMENT '0未处理，1已处理',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of order_info
-- ----------------------------
INSERT INTO `order_info` VALUES ('1', '1', 'user1', '京A WP456', '燃油温度感知器', 'P0189', '用户1', '13112344321', '', '1482306027659', '2016年12月21日 15:40:27', '1');
-- ----------------------------
-- Table structure for parts_info
-- ----------------------------
DROP TABLE IF EXISTS `parts_info`;
CREATE TABLE `parts_info` (
`id` varchar(255) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`isimport` int(1) DEFAULT '0',
`photo` varchar(255) DEFAULT NULL,
`price` varchar(255) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of parts_info
-- ----------------------------
INSERT INTO `parts_info` VALUES ('1', '轮胎', '0', 'lt.png', '￥200.0', '1');
INSERT INTO `parts_info` VALUES ('2', '方向盘', '0', 'fxp.png', '￥150.0', '2');
INSERT INTO `parts_info` VALUES ('3', '油表盘', '0', 'yb.png', '￥100.0', '0');
INSERT INTO `parts_info` VALUES ('4', '变档杆', '0', 'dw.png', '￥100.0', '0');
INSERT INTO `parts_info` VALUES ('5', '齿轮', '0', 'cl.png', '￥50.0', '0');
-- ----------------------------
-- Table structure for purchase_info
-- ----------------------------
DROP TABLE IF EXISTS `purchase_info`;
CREATE TABLE `purchase_info` (
`id` int(11) NOT NULL,
`parts_id` varchar(255) DEFAULT NULL,
`part_name` varchar(255) DEFAULT NULL,
`isImport` int(1) DEFAULT '0',
`price` double(11,0) DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`total` double(20,0) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of purchase_info
-- ----------------------------
-- ----------------------------
-- Table structure for store_info
-- ----------------------------
DROP TABLE IF EXISTS `store_info`;
CREATE TABLE `store_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of store_info
-- ----------------------------
-- ----------------------------
-- Table structure for supplier_info
-- ----------------------------
DROP TABLE IF EXISTS `supplier_info`;
CREATE TABLE `supplier_info` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`contact_people` varchar(255) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of supplier_info
-- ----------------------------
-- ----------------------------
-- Table structure for trouble_info
-- ----------------------------
DROP TABLE IF EXISTS `trouble_info`;
CREATE TABLE `trouble_info` (
`id` varchar(255) NOT NULL,
`trouble_code` varchar(255) NOT NULL,
`trouble_name` varchar(255) DEFAULT NULL,
`trouble_remark` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT NULL COMMENT '0启用，1禁用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of trouble_info
-- ----------------------------
INSERT INTO `trouble_info` VALUES ('1482144327160', 'P0100', '空气流量计线路不良', '空气流量计线路不良', '0');
INSERT INTO `trouble_info` VALUES ('1482144384271', 'P0106', '进气压力感知器线路不良', '进气压力感知器线路不良', '0');
INSERT INTO `trouble_info` VALUES ('1482144432605', 'P0120', '节气门位置感知器线路不良', '节气门位置感知器线路不良', '0');
INSERT INTO `trouble_info` VALUES ('1482144455679', 'P0176', '燃料含水量感知器线路故障', '燃料含水量感知器线路故障', '0');
INSERT INTO `trouble_info` VALUES ('1482144482465', 'P0189', '燃油温度感知器', '燃油温度感知器', '1');
INSERT INTO `trouble_info` VALUES ('1482144560156', 'P0227', '节气门感知器或节气门开关', '节气门感知器或节气门开关', '0');
INSERT INTO `trouble_info` VALUES ('1482144592192', 'P0234', '引擎增压系统故障', '引擎增压系统故障', '1');
-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`id` int(11) NOT NULL,
`userid` varchar(20) NOT NULL,
`name` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`password` varchar(64) DEFAULT NULL,
`rtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`idcard` varchar(18) DEFAULT NULL,
`headimg` varchar(100) DEFAULT '1.jpg',
`introduce` varchar(100) DEFAULT NULL,
`type` varchar(255) NOT NULL DEFAULT '1' COMMENT '1 普通客户，2.员工 3.管理员',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('1', '3', '廖泽铭', null, null, '3', '2020-03-23 14:15:47', null, '1.jpg', null, '3');
INSERT INTO `user_info` VALUES ('2', '2', '田福生', null, null, '2', '2020-03-24 16:07:51', null, '1.jpg', null, '2');
INSERT INTO `user_info` VALUES ('3', '1', 'kk', null, null, '1', '2020-03-24 16:08:32', null, '1.jpg', null, '1');
数据表没有填充好，再实现的过程中再发现错误。
昨天带今天把整体框架搭建起来
登陆界面：根据用户ID,类型登陆。用户类型分位管理员，用户，员工。
注册页面，根据手机号进行注册实现。
用户后台界面
员工后台界面
管理员后台界面：
代码分包