/*
Navicat MySQL Data Transfer
Source Server : MyLocalhost
Source Server Version : 50710
Source Host : localhost:3306
Source Database : 4s
Target Server Type : MYSQL
Target Server Version : 50710
File Encoding : 65001
Date: 2016-11-06 13:08:38
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adminName` varchar(255) DEFAULT NULL,
`passWord` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'admin', 'admin');
INSERT INTO `t_admin` VALUES ('2', 'xiaoqian', '123456');
-- ----------------------------
-- Table structure for t_appointment
-- ----------------------------
DROP TABLE IF EXISTS `t_appointment`;
CREATE TABLE `t_appointment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`isDelete` int(11) NOT NULL,
`repairBookTime` varchar(255) DEFAULT NULL,
`numberplate_insurance_id` int(11) DEFAULT NULL,
`repairCategory_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_g1theopoak3rc6pkj78y85lcg` (`numberplate_insurance_id`),
KEY `FK_8t1evg52001bvhfryrxr98dw4` (`repairCategory_id`),
CONSTRAINT `FK_8t1evg52001bvhfryrxr98dw4` FOREIGN KEY (`repairCategory_id`) REFERENCES `t_repair_category` (`id`),
CONSTRAINT `FK_g1theopoak3rc6pkj78y85lcg` FOREIGN KEY (`numberplate_insurance_id`) REFERENCES `t_numberplate_insurance` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_appointment
-- ----------------------------
INSERT INTO `t_appointment` VALUES ('1', '0', '2016-10-29', '2', '2');
INSERT INTO `t_appointment` VALUES ('2', '0', '2016-10-29', '1', '1');
INSERT INTO `t_appointment` VALUES ('3', '0', '2016-10-30', '3', '5');
INSERT INTO `t_appointment` VALUES ('4', '0', '2016-10-30', '4', '4');
INSERT INTO `t_appointment` VALUES ('5', '0', '2016-10-30', '5', '3');
INSERT INTO `t_appointment` VALUES ('6', '0', '2016-10-30', '6', '2');
INSERT INTO `t_appointment` VALUES ('7', '0', null, '7', null);
INSERT INTO `t_appointment` VALUES ('8', '0', '2016-10-30', '8', '3');
INSERT INTO `t_appointment` VALUES ('9', '0', '2016-10-30', '9', '5');
-- ----------------------------
-- Table structure for t_book
-- ----------------------------
DROP TABLE IF EXISTS `t_book`;
CREATE TABLE `t_book` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bookName` varchar(255) DEFAULT NULL,
`bookTime` varchar(255) DEFAULT NULL,
`cat_category_id` int(11) DEFAULT NULL,
`bookPhone` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_3qllppg31nuo3my5dxtmrmc7a` (`cat_category_id`),
CONSTRAINT `FK_3qllppg31nuo3my5dxtmrmc7a` FOREIGN KEY (`cat_category_id`) REFERENCES `t_car_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_book
-- ----------------------------
INSERT INTO `t_book` VALUES ('1', '张三', '2016-10-30', '1', '18756964231');
INSERT INTO `t_book` VALUES ('2', '李四', '2016-10-30', '3', '18756423654');
INSERT INTO `t_book` VALUES ('3', '王文英', '2016-10-30', '7', '18547891267');
INSERT INTO `t_book` VALUES ('4', '机会', '2016-10-30', '3', '18756964231');
INSERT INTO `t_book` VALUES ('5', '测试2', '2016-10-30', '3', '18756964231');
-- ----------------------------
-- Table structure for t_car
-- ----------------------------
DROP TABLE IF EXISTS `t_car`;
CREATE TABLE `t_car` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`carDisplacement` varchar(255) DEFAULT NULL,
`carImage` varchar(255) DEFAULT NULL,
`carOilConsumption` varchar(255) DEFAULT NULL,
`carPrice` double NOT NULL,
`cat_category_id` int(11) DEFAULT NULL,
`carColr` varchar(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK_c0sl2va12fgmuus2vqa124pc0` (`cat_category_id`),
CONSTRAINT `FK_c0sl2va12fgmuus2vqa124pc0` FOREIGN KEY (`cat_category_id`) REFERENCES `t_car_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_car
-- ----------------------------
INSERT INTO `t_car` VALUES ('1', '1.6L', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '20', '0', '1', '黑色');
INSERT INTO `t_car` VALUES ('2', '2.0L', '\\upload\\dea8a9009c5411e625c26f9bc27fbe90330619-141023093K534.jpg', '30', '0', '2', '白色');
INSERT INTO `t_car` VALUES ('3', '2.0L', '\\upload\\105fdb809e6211e6422a00dab5f09b9f593778_104941646193_2.jpg', '40', '0', '3', '红色');
INSERT INTO `t_car` VALUES ('4', '2.0L', '\\upload\\f4b62f509ead11e6854eb9617b8c8dcd330619-141023093K534.jpg', '30', '0', '3', '白色');
INSERT INTO `t_car` VALUES ('5', '2.0L', '\\upload\\6a1b49109eae11e6854eb9617b8c8dcd118011_090349063_2.jpg', '50', '0', '4', '黑色');
-- ----------------------------
-- Table structure for t_car_category
-- ----------------------------
DROP TABLE IF EXISTS `t_car_category`;
CREATE TABLE `t_car_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`carNumber` int(11) NOT NULL,
`carReturn` int(11) NOT NULL,
`categoryImage` varchar(255) DEFAULT NULL,
`cname` varchar(255) DEFAULT NULL,
`price` varchar(255) DEFAULT NULL,
`carLevel` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_car_category
-- ----------------------------
INSERT INTO `t_car_category` VALUES ('1', '11', '0', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A1', '10', '1');
INSERT INTO `t_car_category` VALUES ('2', '8', '0', '\\upload\\dea8a9009c5411e625c26f9bc27fbe90330619-141023093K534.jpg', '奥迪A2', '20', '5');
INSERT INTO `t_car_category` VALUES ('3', '7', '2', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A3', '20', '9');
INSERT INTO `t_car_category` VALUES ('4', '10', '0', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A4', '30', '6');
INSERT INTO `t_car_category` VALUES ('5', '9', '0', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A5', '40', '1');
INSERT INTO `t_car_category` VALUES ('6', '8', '1', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A6', '50', '8');
INSERT INTO `t_car_category` VALUES ('7', '7', '0', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A7', '60', '6');
INSERT INTO `t_car_category` VALUES ('8', '9', '0', '\\upload\\d84a57509c5611e6753377f7265ec562118011_090349063_2.jpg', '奥迪A8', '60', '1');
-- ----------------------------
-- Table structure for t_car_return
-- ----------------------------
DROP TABLE IF EXISTS `t_car_return`;
CREATE TABLE `t_car_return` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reason` varchar(255) DEFAULT NULL,
`returnImage` varchar(255) DEFAULT NULL,
`returnTime` varchar(255) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`order_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_70vlw77m3bt8rnudtenboixyd` (`customer_id`),
KEY `FK_16m8us20p01gca44vwfhvvfew` (`order_id`),
CONSTRAINT `FK_16m8us20p01gca44vwfhvvfew` FOREIGN KEY (`order_id`) REFERENCES `t_order` (`id`),
CONSTRAINT `FK_70vlw77m3bt8rnudtenboixyd` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_car_return
-- ----------------------------
INSERT INTO `t_car_return` VALUES ('1', '11111', null, '2016-11-01', null, '6');
INSERT INTO `t_car_return` VALUES ('3', '22222', null, '2016-11-01', null, '7');
INSERT INTO `t_car_return` VALUES ('6', '111111', null, '2016-11-01', null, '8');
INSERT I
最新JAVA汽车4S店管理系统源码（前台+后台）
版权申诉
28 浏览量
2022-04-16
16:36:57
上传
评论
收藏 80.77MB ZIP 举报
最新JAVA汽车4S店管理系统源码（前台+后台） （2000个子文件） 
BaseDaoImpl.class 16KB BaseDaoImpl.class 16KB RepairMaterialsAction.class 10KB DateUtils.class 8KB DateUtils.class 8KB LoanAction.class 7KB SalesAction.class 7KB CarAction.class 6KB CarAction.class 6KB BookAction.class 6KB AppointmentAction.class 5KB NumberplateInsuranceAction.class 5KB PayfullAction.class 5KB NumberplateAction.class 4KB CarReturnAction.class 4KB VisitorAction.class 3KB SalesVisitAction.class 3KB AdminAction.class 3KB JsonUtil.class 3KB JsonUtil.class 3KB RepairConfirmAction.class 3KB BookAction.class 3KB Loan.class 3KB Loan.class 3KB CarDaoImpl.class 3KB BaseServiceImpl.class 3KB BaseServiceImpl.class 3KB SystemContextFilter.class 2KB SystemContextFilter.class 2KB Order.class 2KB Order.class 2KB InsuranceAction.class 2KB WorkerAction.class 2KB AdminDaoImpl.class 2KB CustomerAction.class 2KB UUIDUtils.class 2KB UUIDUtils.class 2KB RepairFinanceAction.class 2KB OrderDaoImpl.class 2KB Payfull.class 2KB Payfull.class 2KB SystemContext.class 2KB SystemContext.class 2KB Car.class 2KB Car.class 2KB RepairMaterials.class 2KB SalesFinanceAction.class 2KB Numberplate.class 2KB Numberplate.class 2KB OrderAction.class 2KB RepairConfirm.class 2KB Appointment.class 2KB TimestampMorpher.class 2KB TimestampMorpher.class 2KB Visitor.class 2KB CarCategory.class 2KB CarCategory.class 2KB Repair.class 2KB CarServiceImpl.class 2KB Returnvisit.class 2KB RepairFinance.class 2KB SalesDaoImpl.class 2KB CarReturn.class 2KB Book.class 2KB Book.class 2KB SalesVisit.class 2KB NumberplateInsurance.class 2KB NumberplateInsurance.class 2KB Sales.class 2KB Sales.class 2KB InsuranceDaoImpl.class 2KB CarCategoryDaoImpl.class 2KB CustomerDaoImpl.class 2KB PayfullDaoImpl.class 2KB Insurance.class 2KB Insurance.class 2KB WorkerDaoImpl.class 2KB SalesFinance.class 2KB LoanDaoImpl.class 2KB BookDaoImpl.class 2KB BookDaoImpl.class 2KB LoanDesign.class 2KB LoanDesign.class 2KB CarReturnDaoImpl.class 1KB CarReturn.class 1KB Pager.class 1KB Pager.class 1KB Manager.class 1KB Manager.class 1KB CustomerInsurance.class 1KB AdminServiceImpl.class 1KB Worker.class 1KB Worker.class 1KB FittingCategory.class 1KB Customer.class 1KB Customer.class 1KB Repair.class 1KB BookServiceImpl.class 1KB NumberplateInsuranceServiceImpl.class 1KB MyStrutsFilter.class 1KB共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
