技术：Spring+SpringMVC+MyBatis
数据库：mysql
下面是整个项目目录截图：
部分数据库表
CREATE TABLE attribute (id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘属性集合ID’,name varchar(32) DEFAULT NULL COMMENT ‘属性集合名称’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
– Records of attribute
INSERT INTO attribute VALUES (‘1’, ‘角色’);
INSERT INTO attribute VALUES (‘2’, ‘工种’);
INSERT INTO attribute VALUES (‘3’, ‘车型’);
INSERT INTO attribute VALUES (‘4’, ‘银行类型’);
INSERT INTO attribute VALUES (‘5’, ‘业务类型’);
INSERT INTO attribute VALUES (‘6’, ‘维修类型’);
INSERT INTO attribute VALUES (‘7’, ‘支付类型’);
INSERT INTO attribute VALUES (‘8’, ‘车型颜色’);
INSERT INTO attribute VALUES (‘9’, ‘仓库’);
INSERT INTO attribute VALUES (‘10’, ‘车类’);
INSERT INTO attribute VALUES (‘11’, ‘厂牌’);
INSERT INTO attribute VALUES (‘12’, ‘油表’);
INSERT INTO attribute VALUES (‘13’, ‘班组’);
INSERT INTO attribute VALUES (‘14’, ‘险种’);
INSERT INTO attribute VALUES (‘15’, ‘承保公司’);
INSERT INTO attribute VALUES (‘16’, ‘结算方式’);
INSERT INTO attribute VALUES (‘17’, ‘发票类型’);
INSERT INTO attribute VALUES (‘18’, ‘三包厂商’);
– Table structure for attributedetail
DROP TABLE IF EXISTS attributedetail;
CREATE TABLE attributedetail (id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘属性集合明细ID’,name varchar(32) DEFAULT NULL COMMENT ‘属性集合明细名称’,abid int(11) DEFAULT NULL COMMENT ‘属性集合ID’,remark varchar(200) DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
– Records of attributedetail
INSERT INTO attributedetail VALUES (‘2’, ‘管理员’, ‘1’, ‘系统管理员’);
INSERT INTO attributedetail VALUES (‘3’, ‘前台接待员’, ‘1’, ‘前台接待’);
INSERT INTO attributedetail VALUES (‘4’, ‘采购员’, ‘1’, ‘采购模块’);
INSERT INTO attributedetail VALUES (‘7’, ‘机电’, ‘2’, ‘机械维修’);
INSERT INTO attributedetail VALUES (‘8’, ‘手工修’, ‘2’, ‘手动修’);
INSERT INTO attributedetail VALUES (‘10’, ‘宝马’, ‘3’, ‘宝马’);
INSERT INTO attributedetail VALUES (‘11’, ‘奔驰’, ‘3’, ‘奔驰’);
INSERT INTO attributedetail VALUES (‘12’, ‘中国农业银行’, ‘4’, ‘中国农业银行’);
INSERT INTO attributedetail VALUES (‘13’, ‘中国邮政银行’, ‘4’, ‘中国邮政银行’);
INSERT INTO attributedetail VALUES (‘14’, ‘中国工商银行’, ‘4’, ‘中国工商银行’);
INSERT INTO attributedetail VALUES (‘15’, ‘预约’, ‘5’, ‘预定’);
INSERT INTO attributedetail VALUES (‘16’, ‘来店维修’, ‘5’, ‘来到实体店维修’);
INSERT INTO attributedetail VALUES (‘17’, ‘人工修’, ‘6’, ‘人工修’);
INSERT INTO attributedetail VALUES (‘18’, ‘机修’, ‘6’, ‘机修’);
INSERT INTO attributedetail VALUES (‘20’, ‘销售员’, ‘1’, ‘销售模块’);
INSERT INTO attributedetail VALUES (‘22’, ‘仓管员’, ‘1’, ‘仓库模块’);
INSERT INTO attributedetail VALUES (‘23’, ‘现金’, ‘7’, ‘直接支付’);
INSERT INTO attributedetail VALUES (‘24’, ‘转账’, ‘7’, ‘电子支付’);
INSERT INTO attributedetail VALUES (‘27’, ‘挂起’, ‘7’, ‘客户挂起’);
INSERT INTO attributedetail VALUES (‘29’, ‘黄色’, ‘8’, ‘yello’);
INSERT INTO attributedetail VALUES (‘30’, ‘红色’, ‘8’, ‘red’);
INSERT INTO attributedetail VALUES (‘31’, ‘银白色’, ‘8’, ‘’);
INSERT INTO attributedetail VALUES (‘32’, ‘黑色’, ‘8’, ‘back’);
INSERT INTO attributedetail VALUES (‘33’, ‘白色’, ‘8’, ‘white’);
INSERT INTO attributedetail VALUES (‘34’, ‘A仓库’, ‘9’, ‘A仓库总面积 600平方’);
INSERT INTO attributedetail VALUES (‘35’, ‘B仓库’, ‘9’, ‘总面积为900平方’);
INSERT INTO attributedetail VALUES (‘36’, ‘C仓库’, ‘9’, ‘总面积500平方’);
INSERT INTO attributedetail VALUES (‘38’, ‘小货车’, ‘10’, ‘拉货’);
INSERT INTO attributedetail VALUES (‘39’, ‘大货车’, ‘10’, ‘拉很多货的’);
INSERT INTO attributedetail VALUES (‘40’, ‘面包车’, ‘10’, ‘拉面包的’);
INSERT INTO attributedetail VALUES (‘41’, ‘五十铃’, ‘10’, ‘小型汽车’);
INSERT INTO attributedetail VALUES (‘42’, ‘VOTOC’, ‘11’, ‘什么鬼’);
INSERT INTO attributedetail VALUES (‘43’, ‘DOOT’, ‘11’, ‘我不知道’);
INSERT INTO attributedetail VALUES (‘44’, ‘OOG’, ‘11’, ‘我中’);
INSERT INTO attributedetail VALUES (‘45’, ‘1/4’, ‘12’, ‘一半的一半’);
INSERT INTO attributedetail VALUES (‘46’, ‘1/2’, ‘12’, ‘一半’);
INSERT INTO attributedetail VALUES (‘47’, ‘3/4’, ‘12’, ‘比一半还多一半’);
INSERT INTO attributedetail VALUES (‘48’, ‘满表’, ‘12’, ‘全满’);
INSERT INTO attributedetail VALUES (‘49’, ‘机修一组’, ‘13’, ‘机修’);
INSERT INTO attributedetail VALUES (‘50’, ‘机修二组’, ‘13’, ‘机修’);
INSERT INTO attributedetail VALUES (‘51’, ‘机修三组’, ‘13’, ‘机修’);
INSERT INTO attributedetail VALUES (‘52’, ‘人修一组’, ‘13’, ‘人修’);
INSERT INTO attributedetail VALUES (‘53’, ‘人修二组’, ‘13’, ‘人修’);
INSERT INTO attributedetail VALUES (‘54’, ‘人修三组’, ‘13’, ‘人修’);
INSERT INTO attributedetail VALUES (‘55’, ‘车身受损险’, ‘14’, ‘车身受损险’);
INSERT INTO attributedetail VALUES (‘56’, ‘车祸险’, ‘14’, ‘车祸险’);
INSERT INTO attributedetail VALUES (‘57’, ‘车保平安险’, ‘14’, ‘车保平安险’);
INSERT INTO attributedetail VALUES (‘58’, ‘中国人寿保险公司’, ‘15’, ‘中国人寿保险公司’);
INSERT INTO attributedetail VALUES (‘59’, ‘太平洋保险公司’, ‘15’, ‘太平洋保险公司’);
INSERT INTO attributedetail VALUES (‘60’, ‘大西洋保险公司’, ‘15’, ‘大西洋保险公司’);
INSERT INTO attributedetail VALUES (‘61’, ‘安生保险公司’, ‘15’, ‘安生保险公司’);
INSERT INTO attributedetail VALUES (‘62’, ‘客付’, ‘16’, ‘客户付费’);
INSERT INTO attributedetail VALUES (‘63’, ‘三包’, ‘16’, ‘三包’);
INSERT INTO attributedetail VALUES (‘64’, ‘免费’, ‘16’, ‘免费’);
INSERT INTO attributedetail VALUES (‘65’, ‘保险’, ‘16’, ‘保险公司’);
INSERT INTO attributedetail VALUES (‘66’, ‘普通发票’, ‘17’, ‘普通发票’);
INSERT INTO attributedetail VALUES (‘67’, ‘增值发票’, ‘17’, ‘增值发票’);
INSERT INTO attributedetail VALUES (‘68’, ‘其他发票’, ‘17’, ‘其他发票’);
INSERT INTO attributedetail VALUES (‘69’, ‘三包A厂商’, ‘18’, ‘三包A厂商’);
INSERT INTO attributedetail VALUES (‘70’, ‘三包B厂商’, ‘18’, ‘三包B厂商’);
INSERT INTO attributedetail VALUES (‘71’, ‘三包C厂商’, ‘18’, ‘三包C厂商’);
INSERT INTO attributedetail VALUES (‘72’, ‘机电组合人工1’, ‘2’, ‘机电组合人工1’);
INSERT INTO attributedetail VALUES (‘73’, ‘前台接待员’, ‘1’, ‘1’);
– Table structure for bespeak
DROP TABLE IF EXISTS bespeak;
CREATE TABLE bespeak (id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘预约ID’,bespeakcode varchar(32) DEFAULT NULL COMMENT ‘预约号’,operationid int(11) DEFAULT NULL COMMENT ‘操作员’,operationtime datetime DEFAULT NULL COMMENT ‘操作时间’,carid int(11) DEFAULT NULL COMMENT ‘车辆ID’,bespeaktime datetime NOT NULL COMMENT ‘预约时间’,receptionid int(11) DEFAULT NULL COMMENT ‘接待人’,remark varchar(32) DEFAULT NULL COMMENT ‘备注’,state int(11) DEFAULT NULL COMMENT ‘状态(0预约,1未到,2已到,3取消,)’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;