devbox
Cpp五条
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于Java实现的汽车维修管理系统_汽车修理管理系统java

作者：Cpp五条 | 2024-03-12 13:27:51

赞

踩

汽车修理管理系统java

基于Java实现的汽车维修管理系统(文末含源码+数据库+文档)

前言

21世纪是一个知识大爆炸的时代，互联网拉近了人们的距离，信息化革命席卷了各个行业。物质生活水平的提高使得人们的消费观念悄然发生改变，人们对汽车维修管理系统的要求越来越高，这对于传统汽车维修管理系统行业来说既是机遇也是挑战。提高汽车维修管理系统水平、推进汽车维修管理系统信息化已势在必行，汽车维修管理系统的出现为此提供了有力的保证。

汽车维修管理系统采用B / S架构，主要使用Java技术进行开发，结合最新流行的java和mysql的SSM框架技术。中间件服务器是Tomcat服务器，使用Mysql数据库和MyEclipse开发环境。力求系统的全面、通用。严格按照软件开发和测试的规范流程进行开发和测试。本网站从总体架构部署上分为后台，后台内容全面、具体，操作简单,后台的主要功能是显示系统的整体图片，包括配件信息、入库信息、维修信息、评价信息和配件销售的功能，客户可根据关键字进行信息的查找自己想要了解的维修信息

车辆信息 本系统是基于java的汽车维修管理,其功能主要完成进站维修的车辆的基本信息的管理,公司库存管理、采购管理以及维修信息管理等。车辆维护包括客户单位管理、车辆信息车辆管理及车辆维修记录的管理,同时实现维修记录的增加…

采购管理实现对车辆配件的采购管理以及配件供应商信息的管理。综合查询实现对车辆的基本信息、维修记录信息、维修项目信息、维修结算信息和维修配件材料信息的查询

功能模块

本系统分为用户端和管理端。

用户端
  • 我的信息
  • 车辆信息
  • 维修信息
    请添加图片描述
管理端
  • 用户信息管理
  • 车辆信息管理
  • 故障信息管理
  • 维修订单管理
  • 零件管理
  • 统计管理
    请添加图片描述

技术栈

JDK1.7+SSM+LayUI+Jquery+Html+CSS

数据库

-- ----------------------------
-- Table structure for car_info
-- ----------------------------
DROP TABLE IF EXISTS `car_info`;
CREATE TABLE `car_info`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `plate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `model` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of car_info
-- ----------------------------
BEGIN;
INSERT INTO `car_info` VALUES ('1482305606196', '豫A UY788', '1482306686697', '宝马', 'x5', '白色', '60万', '2022-12-19', '', '张女士'), ('1482305613319', '沪A MR65T', '1482305613319', '宝马', 'X5', '黑色', '60万', '2022-12-05', '', '何先生'), ('1482305826221', '豫A UY6T5', '1675565458440', '奔驰', 'c200', '黑色', '40万', '2022-12-21', '', '秦先生'), ('1675657234442', '豫A 619RF', '1675655873310', '奥迪', 'Q5', '黑色', '40万', '2023-02-06', '', '王先生'), ('1675657918818', '沪A 88UI6', '1675655909778', '宝马', 'x3', '黑色', '30万', '2023-02-05', '', '李先生'), ('1675657984320', '豫A IU89T', '1675655917970', '奔驰', 'S500', '银色', '50万', '2023-02-05', '', '赵先生'), ('1675658032927', '粤A 71WE3', '1675655926853', '奥迪', 'Q1', '黑色', '35万', '2023-01-29', '', '孙女士'), ('1675658119525', '浙A 98R4T', '1675655934776', '奔驰', 'A120', '黑色', '30万', '2023-02-05', '', '李小姐');
COMMIT;

-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `plate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `trouble_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `trouble_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `contact_way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `long_time` bigint(20) NULL DEFAULT NULL,
  `creart_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT NULL COMMENT '0未处理，1已处理',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` VALUES ('1675659950739', '1482305613319', '何先生', '沪A MR65T', '进气压力感知器线路不良', 'P0106', ' 何先生', '18039667890', '', 1675659950740, '2023年02月06日   13:05:50', 1), ('1675661839999', '1482306686697', '张女士', '豫A UY788', '进气压力感知器线路不良', 'P0106', '张女士', '17789983456', '', 1675661839999, '2023年02月06日   13:37:19', 1), ('1675661869648', '1675565458440', '秦先生', '豫A UY6T5', '节气门感知器或节气门开关', 'P0227', '秦先生', '19989896688', '', 1675661869649, '2023年02月06日   13:37:49', 1), ('1675661901900', '1675655873310', '王先生', '豫A 619RF', '燃油温度感知器', 'P0189', '王先生', '18029334689', '', 1675661901900, '2023年02月06日   13:38:21', 1), ('1675661926495', '1675655909778', '李先生', '沪A 88UI6', '进气温度传感器线路间歇性故障', 'P0110', '李先生', '18529334689', '', 1675661926495, '2023年02月06日   13:38:46', 0), ('1675661948887', '1675655917970', '赵先生', '豫A IU89T', '燃料含水量感知器线路故障', 'P0176', '赵先生', '18839334670', '', 1675661948887, '2023年02月06日   13:39:08', 0), ('1675661970892', '1675655926853', '孙女士', '粤A 71WE3', '进气温度传感器接线不良', 'P0111', '孙女士', '17789090987', '', 1675661970892, '2023年02月06日   13:39:30', 0), ('1675661998024', '1675655934776', '李小姐', '浙A 98R4T', '进气温度传感器线路间歇性故障', 'P0114', '李小姐', '16878964567', '', 1675661998024, '2023年02月06日   13:39:58', 0);
COMMIT;

-- ----------------------------
-- Table structure for parts_info
-- ----------------------------
DROP TABLE IF EXISTS `parts_info`;
CREATE TABLE `parts_info`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `num` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of parts_info
-- ----------------------------
BEGIN;
INSERT INTO `parts_info` VALUES ('1', '轮胎', 'lt.png', '￥1600.0', 5), ('2', '方向盘', 'fxp.png', '￥2000.0', 3), ('3', '油表盘', 'yb.png', '￥900.0', 0), ('4', '变档杆', 'dw.png', '￥1000.0', 0), ('5', '齿轮', 'cl.png', '￥5000.0', 0);
COMMIT;

-- ----------------------------
-- Table structure for personal_info
-- ----------------------------
DROP TABLE IF EXISTS `personal_info`;
CREATE TABLE `personal_info`  (
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tel_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of personal_info
-- ----------------------------
BEGIN;
INSERT INTO `personal_info` VALUES ('1482305606196', ' 王女士', '女', '', '13112344321@sina.com', '北京', '13112344321', ''), ('1482305613319', '何先生', '男', NULL, 'HE666888@sina.com', NULL, '16890897887', NULL), ('1482306686697', ' 张女士', '女', '', '12345678956@qq.com', '上海', '17789983456', ''), ('1675565458440', '秦先生', '男', NULL, 'Qin888999@163.com', NULL, '19989896688', NULL), ('1675655873310', '王先生', '男', '', 'wangyong@sina.com', '郑州', '18029334689', ''), ('1675655909778', '李先生', '男', '', '12345678956@qq.com', '上海', '18529334689', NULL), ('1675655917970', '赵先生', '男', '', '157897678@163.com', '郑州', '18839334670', NULL), ('1675655926853', '孙女士', '女', '', 'sun777@163.com', '广州', '17789090987', NULL), ('1675655934776', '李小姐', '女', '', 'lilu666@163.com', '杭州', '16878964567', '');
COMMIT;

-- ----------------------------
-- Table structure for trouble_info
-- ----------------------------
DROP TABLE IF EXISTS `trouble_info`;
CREATE TABLE `trouble_info`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `trouble_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `trouble_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `trouble_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT NULL COMMENT '0启用，1禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of trouble_info
-- ----------------------------
BEGIN;
INSERT INTO `trouble_info` VALUES ('1482144327160', 'P0100', '空气流量计线路不良', '空气流量计线路不良', 0), ('1482144384271', 'P0106', '进气压力感知器线路不良', '进气压力感知器线路不良', 0), ('1482144432605', 'P0120', '节气门位置感知器线路不良', '节气门位置感知器线路不良', 0), ('1482144455679', 'P0176', '燃料含水量感知器线路故障', '燃料含水量感知器线路故障', 0), ('1482144482465', 'P0189', '燃油温度感知器', '燃油温度感知器', 0), ('1482144560156', 'P0227', '节气门感知器或节气门开关', '节气门感知器或节气门开关', 0), ('1482144592192', 'P0234', '引擎增压系统故障', '引擎增压系统故障', 1), ('1675656234190', 'P0107', '进气压力传感器输入电压过低', '', 0), ('1675656246157', 'P0108', '进气压力传感器输入电压过高', '', 0), ('1675656260457', 'P0109', '进气温度传感器线路不良或进气压力传感器线路间歇', '', 0), ('1675656286135', 'P0110', '进气温度传感器线路间歇性故障', '', 0), ('1675656300450', 'P0111', '进气温度传感器接线不良', '', 0), ('1675656398741', 'P0112', '进气温度传感器线路电压过低', '', 0), ('1675656411221', 'P0113', '进气温度传感器线路输入电压过高', '', 0), ('1675656426055', 'P0114', '进气温度传感器线路间歇性故障', '', 0), ('1675656439457', 'P0115', '发动机水温传感器线路不良', '', 0), ('1675656457551', 'P0116', '发动机水温传感器不良', '', 0), ('1675656469399', 'P0117', '发动机水温传感器电压过低', '', 0), ('1675656482689', 'P0118', '发动机水温传感器电压过高', '', 0), ('1675656495672', 'P0119', '发动机水温传感器线路间歇性故障', '', 0), ('1675656508273', 'P0120', '节气门位置传感器接线不良', '', 0);
COMMIT;

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114

代码

package com.controller;

import com.service.CarInfoService;
import com.util.Result;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;

@Controller
@RequestMapping("/carinfo")
public class CarInfoController {
	@Resource
	private CarInfoService cs;

	@RequestMapping("/add.do")
	@ResponseBody
	public Result execute(String user_id,
						  String plate,
						  String brand,
						  String model,
						  String color,
						  String price,
						  String date,
						  String remark){
		System.out.println("进入controller");
		Result rs=cs.addCarInfo(user_id, plate, brand, model, color, price, date, remark);
		System.out.println(rs.toString());
		return rs;
	}


	@RequestMapping("/show.do")
	@ResponseBody
	public Result show(String user_id){
		System.out.println("user_id="+user_id);
		Result rs=cs.showCarInfo(user_id);
		System.out.println(rs.toString());
		return rs;
	}

	@RequestMapping("/showone.do")
	@ResponseBody
	public Result showOneCar(String id){
		System.out.println("进入controller");
		Result rs=cs.showOneCar(id);
		System.out.println(rs.toString());
		return rs;
	}

	@RequestMapping("/showAll.do")
	@ResponseBody
	public Result showAllCar() {
		Result rs=cs.showAllCar();
		System.out.println(rs.toString());
		return rs;
	}

	@RequestMapping("/search.do")
	@ResponseBody
	public Result searchCar(String type,String keywords){
		System.out.println("进入controller/search.do");
		Result rs=cs.searchCar(type, keywords);
		return rs;
	}

	@RequestMapping("/delete.do")
	@ResponseBody
	public Result delete(String id){
		System.out.println("进入controller");
		Result rs=cs.delCarInfo(id);
		System.out.println(rs.toString());
		return rs;
	}

	@RequestMapping("/update.do")
	@ResponseBody
	public Result update(String id, String plate, String brand, String model, String color, String price,
						 String date, String remark) {
		System.out.println("进入controller");
		Result rs=cs.updateCarInfo(id, plate, brand, model, color, price, date, remark);
		System.out.println(rs.toString());
		return rs;
	}
}


  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
package com.controller;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.service.PersonalInfoService;
import com.service.UserService;
import com.util.Result;

@Controller
@RequestMapping("/personalinfo")
public class PersonalInfoController {
	@Resource
	private PersonalInfoService ps;
	
	@RequestMapping("/update.do")
	@ResponseBody
	public Result execute(String user_id,String real_name,String sex,String birthday,
			String email,String address,String tel_num,String remark){
		System.out.println("进入controller");
		Result rs=ps.updatePersonalInfo(user_id, real_name, sex, birthday, email, address, tel_num, remark);
		System.out.println(rs.toString());
		return rs;
	}
	
	@RequestMapping("/show.do")
	@ResponseBody
	public Result execute(String user_id){
		System.out.println("进入controller");
		Result rs=ps.showPersonalInfo(user_id);
		System.out.println(rs.toString());
		return rs;
	}
}


  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38

免费获取源码+数据库+论文文档

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/224259
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号