jsp ssm 车辆维修管理系统 车辆修理 汽车维修 项目源码 web java【项目源码+数据库脚本+项目说明+软件工具】毕设

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50731 Source Host : localhost:3306 Source Schema : ssm_clwxxt Target Server Type : MySQL Target Server Version : 50731 File Encoding : 65001 Date: 28/09/2024 12:05:18 */ drop database if exists ssm_clwxxt; create database ssm_clwxxt charset utf8; use ssm_clwxxt; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `adminid` varchar(32) NOT NULL COMMENT '管理员表主键编号', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `password` varchar(50) DEFAULT NULL COMMENT '密码', `realname` varchar(50) DEFAULT NULL COMMENT '姓名', `contact` varchar(50) DEFAULT NULL COMMENT '联系方式', `addtime` varchar(28) DEFAULT NULL COMMENT '创建日期', PRIMARY KEY (`adminid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表'; -- ---------------------------- -- Records of admin -- ---------------------------- BEGIN; INSERT INTO `admin` (`adminid`, `username`, `password`, `realname`, `contact`, `addtime`) VALUES ('A20240928115214587', 'aaa', '123', '123', '13777777777', '2024-09-28'); INSERT INTO `admin` (`adminid`, `username`, `password`, `realname`, `contact`, `addtime`) VALUES ('A20241009133850721', 'admin', 'admin', 'admin', '13888888888', '2024-10-09'); COMMIT; -- ---------------------------- -- Table structure for buy -- ---------------------------- DROP TABLE IF EXISTS `buy`; CREATE TABLE `buy` ( `buyid` varchar(32) NOT NULL COMMENT '配件采购表主键编号', `bno` varchar(50) DEFAULT NULL COMMENT '采购单号', `goodsid` varchar(32) DEFAULT NULL COMMENT '配件', `price` varchar(50) DEFAULT NULL COMMENT '单价', `num` varchar(50) DEFAULT NULL COMMENT '数量', `supplier` varchar(50) DEFAULT NULL COMMENT '供货商', `addtime` varchar(28) DEFAULT NULL COMMENT '采购日期', `manager` varchar(50) DEFAULT NULL COMMENT '经手人', `memo` varchar(50) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`buyid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配件采购表'; -- ---------------------------- -- Records of buy -- ---------------------------- BEGIN; INSERT INTO `buy` (`buyid`, `bno`, `goodsid`, `price`, `num`, `supplier`, `addtime`, `manager`, `memo`) VALUES ('B20241010002322750', 'B20241010002307911', 'G20241009234944990', '125', '23', '123123', '2024-10-10', '黎芸贵', '123123'); INSERT INTO `buy` (`buyid`, `bno`, `goodsid`, `price`, `num`, `supplier`, `addtime`, `manager`, `memo`) VALUES ('B20241010002339792', 'B20241010002322203', 'G20241009235346107', '124', '25', '234234', '2024-10-10', '黎芸贵', '123123'); INSERT INTO `buy` (`buyid`, `bno`, `goodsid`, `price`, `num`, `supplier`, `addtime`, `manager`, `memo`) VALUES ('B20241010203724269', 'B20241010203702254', 'G20241010203657488', '180', '27', '123123', '2024-10-10', '吕致盈', '123123'); INSERT INTO `buy` (`buyid`, `bno`, `goodsid`, `price`, `num`, `supplier`, `addtime`, `manager`, `memo`) VALUES ('B20241010203745811', 'B20241010203724509', 'G20241010203647179', '360', '8', '234234', '2024-10-10', '李雅惠', '345345'); COMMIT; -- ---------------------------- -- Table structure for cate -- ---------------------------- DROP TABLE IF EXISTS `cate`; CREATE TABLE `cate` ( `cateid` varchar(32) NOT NULL COMMENT '零件类型表主键编号', `catename` varchar(50) DEFAULT NULL COMMENT '类型名称', `addtime` varchar(28) DEFAULT NULL COMMENT '创建日期', `memo` varchar(50) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`cateid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='零件类型表'; -- ---------------------------- -- Records of cate -- ---------------------------- BEGIN; INSERT INTO `cate` (`cateid`, `catename`, `addtime`, `memo`) VALUES ('C20241009234914139', '配件类型1', '2024-10-09', '配件类型1'); INSERT INTO `cate` (`cateid`, `catename`, `addtime`, `memo`) VALUES ('C20241010203625732', '配件类型2', '2024-10-10', '配件类型2'); COMMIT; -- ---------------------------- -- Table structure for employ -- ---------------------------- DROP TABLE IF EXISTS `employ`; CREATE TABLE `employ` ( `employid` varchar(32) NOT NULL COMMENT '员工表主键编号', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `password` varchar(50) DEFAULT NULL COMMENT '密码', `realname` varchar(50) DEFAULT NULL COMMENT '姓名', `sex` varchar(10) DEFAULT NULL COMMENT '性别', `birthday` varchar(28) DEFAULT NULL COMMENT '出生日期', `jiguan` varchar(50) DEFAULT NULL COMMENT '籍贯', `minzu` varchar(50) DEFAULT NULL COMMENT '民族', `workdate` varchar(28) DEFAULT NULL COMMENT '入职日期', `contact` varchar(50) DEFAULT NULL COMMENT '联系方式', `address` varchar(50) DEFAULT NULL COMMENT '联系地址', `memo` varchar(50) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`employid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工表'; -- ---------------------------- -- Records of employ -- ---------------------------- BEGIN; INSERT INTO `employ` (`employid`, `username`, `password`, `realname`, `sex`, `birthday`, `jiguan`, `minzu`, `workdate`, `contact`, `address`, `memo`) VALUES ('E20241009232822473', 'zhangsan', '123', '张三', '男', '2024-10-09', '江苏南京', '汉族', '2024-10-09', '13666666666', '中山路28号', '无'); INSERT INTO `employ` (`employid`, `username`, `password`, `realname`, `sex`, `birthday`, `jiguan`, `minzu`, `workdate`, `contact`, `address`, `memo`) VALUES ('E20241009232843490', 'lisi', '123', '李四', '男', '2024-10-09', '辽宁大连', '汉族', '2024-10-09', '13999999999', '知学路45号', '无'); INSERT INTO `employ` (`employid`, `username`, `password`, `realname`, `sex`, `birthday`, `jiguan`, `minzu`, `workdate`, `contact`, `address`, `memo`) VALUES ('E20241010203614250', 'wangwu', '123', '王五', '男', '2024-10-10', '辽宁沈阳', '汉族', '2024-10-10', '13444444444', ' 剪子巷139号', '无'); COMMIT; -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `goodsid` varchar(32) NOT NULL COMMENT '配件表主键编号', `gno` varchar(50) DEFAULT NULL COMMENT '配件号', `goodsname` varchar(50) DEFAULT NULL COMMENT '配件名称', `cateid` varchar(32) DEFAULT NULL COMMENT '配件类型', `price` varchar(50) DEFAULT NULL COMMENT '销售价格', `cars` varchar(50) DEFAULT NULL COMMENT '适用车型', `num` int(11) DEFAULT '0' COMMENT '库存数量', `addtime` varchar(28) DEFAULT NULL COMMENT '创建日期', `memo` varchar(50) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`goodsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配件表'; -- ---------------------------- -- Records of goods -- ---------------------------- BEGIN; INSERT INTO `goods` (`goodsid`, `gno`, `goodsname`, `cateid`, `price`, `cars`, `num`, `addtime`, `memo`) VALUES ('G20241009234944990', 'G20241009234916589', '配件名称1', 'C20241009234914139', '152', '适用车型1,适用车型2,适用车型3', 14, '2024-10-09', '适用车型适用车型适用车型'); INSERT INTO `goods` (`goodsid`, `gno`, `goodsname`, `cateid`, `price`, `cars`, `num`, `addtime`, `memo`) VALUES ('G20241009235346107', 'G20241009235322216', '配件名称2', 'C20241009234914139', '162', '适用车型2,适用车型3,适用车型4', 0, '2024-10-09', '配件名称2'); INSERT INTO `goods` (`goodsid`, `gno`, `goodsname`, `cateid`, `price`, `cars`, `num`, `addtime`, `memo`) VALUES ('G20241009235405730', 'G20241009235346687', '配件名称3', 'C20241009234914139', '1179', '适用车型3,适用车型4,适用车型5', 0, '2024-10-09', '配件名称3'); INSE