java服装连锁店管理系统设计与实现_java服装信息管理系统设计与实现

作者：IT小白 | 2024-07-31 20:15:30

踩

java服装信息管理系统设计与实现

服装连锁店管理系统设计与实现
开发工具(eclipse/idea/vscode等)：
数据库(sqlite/mysql/sqlserver等)：
功能模块(请用文字描述，至少200字)：

/*
Navicat MySQL Data Transfer

Source Server : test
Source Server Version : 50722
Source Host : localhost:3306
Source Database : db_bdm012fuzhuangliansuo

Target Server Type : MYSQL
Target Server Version : 50722
File Encoding : 65001

Date: 2020-12-10 21:50:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`adminId` int(11) NOT NULL AUTO_INCREMENT,
`adminName` varchar(255) DEFAULT NULL,
`adminPassword` varchar(255) DEFAULT NULL,
PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'admin', 'admin');

-- ----------------------------
-- Table structure for `t_jcbiaoti`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcbiaoti`;
CREATE TABLE `t_jcbiaoti` (
`jcbiaotiId` int(11) NOT NULL AUTO_INCREMENT,
`jcbiaotiName` varchar(255) DEFAULT NULL COMMENT '汉字',
`jcbiaotiNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
`jcbiaotiMark` varchar(255) DEFAULT NULL,
`jcbiaotiMark1` varchar(255) DEFAULT NULL,
`jcbiaotiMark2` varchar(255) DEFAULT NULL,
`jcbiaotiPaixu` int(11) DEFAULT NULL,
`jcbiaotiType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
`jcbiaotiType1` int(11) DEFAULT NULL,
`jcbiaotiType2` int(11) DEFAULT NULL,
PRIMARY KEY (`jcbiaotiId`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcbiaoti
-- ----------------------------
INSERT INTO `t_jcbiaoti` VALUES ('2', '员工信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('3', '服装信息', null, null, null, null, '3', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('4', '采购信息', null, null, null, null, '4', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('6', '销售信息', null, null, null, null, '6', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('7', '批发信息', null, null, null, null, '3', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('8', '库存信息', null, null, null, null, '8', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('11', '服装信息', null, null, null, null, '3', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('12', '采购信息', null, null, null, null, '4', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('14', '销售信息', null, null, null, null, '6', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('15', '批发信息', null, null, null, null, '3', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('17', '门店信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('18', '门店信息', null, null, null, null, '2', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('19', '供应商信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('20', '供应商信息', null, null, null, null, '2', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('21', '财务信息', null, null, null, null, '9', '1', '0', null);

-- ----------------------------
-- Table structure for `t_jcdaohang`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcdaohang`;
CREATE TABLE `t_jcdaohang` (
`jcdaohangId` int(11) NOT NULL AUTO_INCREMENT,
`jcdaohangName` varchar(255) DEFAULT NULL COMMENT '汉字',
`jcdaohangNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
`jcdaohangMark` varchar(255) DEFAULT NULL,
`jcdaohangMark1` varchar(255) DEFAULT NULL,
`jcdaohangMark2` varchar(255) DEFAULT NULL,
`jcdaohangPaixu` int(11) DEFAULT NULL,
`jcdaohangType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
`jcdaohangType1` int(11) DEFAULT NULL,
`jcdaohangType2` int(11) DEFAULT NULL,
`jcbiaotiId` int(11) DEFAULT NULL,
`jcbiaotiName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`jcdaohangId`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcdaohang
-- ----------------------------
INSERT INTO `t_jcdaohang` VALUES ('4', '员工信息', 'user.jsp', null, null, null, '2', '1', '0', null, '2', null);
INSERT INTO `t_jcdaohang` VALUES ('8', '服装类型', 'sjleixing.jsp', null, null, null, '1', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('9', '服装品牌', 'sjxingtai.jsp', null, null, null, '2', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('10', '服装信息', 'shuju.jsp', null, null, null, '3', '1', '0', null, '3', null);
INSERT INTO `t_jcdaohang` VALUES ('11', '供应商信息', 'sjlaiyuan.jsp', null, null, null, '1', '1', '0', null, '19', null);
INSERT INTO `t_jcdaohang` VALUES ('12', '采购信息', 'sjduochu0.jsp', null, null, null, '2', '1', '0', null, '4', null);
INSERT INTO `t_jcdaohang` VALUES ('19', '销售信息', 'sjshaochu0.jsp', null, null, null, '1', '1', '0', null, '6', null);
INSERT INTO `t_jcdaohang` VALUES ('21', '门店信息', 'sjqita.jsp', null, null, null, '1', '1', '0', null, '17', null);
INSERT INTO `t_jcdaohang` VALUES ('22', '批发信息', 'sjjianchu.jsp', null, null, null, '2', '1', '0', null, '7', null);
INSERT INTO `t_jcdaohang` VALUES ('23', '库存信息', 'bingzhuangtu.jsp?tijiaoUrl=shujuTongji', null, null, null, '1', '1', '0', null, '8', null);
INSERT INTO `t_jcdaohang` VALUES ('24', '采购统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjduochuTongji', null, null, null, '2', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('25', '销售统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjshaochuTongji', null, null, null, '3', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('26', '批发统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjjianchuTongji', null, null, null, '4', '1', '0', null, '21', null);
INSERT INTO `t_jcdaohang` VALUES ('30', '服装信息', 'shuju.jsp', null, null, null, '1', '2', '0', null, '11', null);
INSERT INTO `t_jcdaohang` VALUES ('31', '供应商信息', 'sjlaiyuan.jsp', null, null, null, '1', '2', '0', null, '20', null);
INSERT INTO `t_jcdaohang` VALUES ('32', '采购信息', 'sjduochu0.jsp', null, null, null, '2', '2', '0', null, '12', null);
INSERT INTO `t_jcdaohang` VALUES ('35', '销售信息', 'sjshaochu0.jsp', null, null, null, '1', '2', '0', null, '14', null);
INSERT INTO `t_jcdaohang` VALUES ('37', '门店信息', 'sjqita.jsp', null, null, null, '1', '2', '0', null, '18', null);
INSERT INTO `t_jcdaohang` VALUES ('38', '批发信息', 'sjjianchu.jsp', null, null, null, '2', '2', '0', null, '15', null);

-- ----------------------------
-- Table structure for `t_jcpeizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcpeizhi`;
CREATE TABLE `t_jcpeizhi` (
`jcpeizhiId` int(11) NOT NULL AUTO_INCREMENT,
`jcpeizhiName` varchar(255) DEFAULT NULL,
`jcpeizhiNeirong` varchar(255) DEFAULT NULL,
`jcpeizhiMark` varchar(255) DEFAULT NULL,
`bumenBieming` varchar(255) DEFAULT NULL,
`buyuanBieming` varchar(255) DEFAULT NULL,
`buzhiBieming` varchar(255) DEFAULT NULL,
`userBieming` varchar(255) DEFAULT NULL COMMENT 'userBieming',
`uxtypeBieming` varchar(255) DEFAULT NULL,
`uxinxiBieming` varchar(255) DEFAULT NULL,
`uyijianBieming` varchar(255) DEFAULT NULL,
`roleBieming` varchar(255) DEFAULT NULL,
`byumenBieming` varchar(255) DEFAULT NULL,
`byuyuanBieming` varchar(255) DEFAULT NULL,
`byuzhiBieming` varchar(255) DEFAULT NULL,
`yonghuBieming` varchar(255) DEFAULT NULL COMMENT 'yonghuBieming',
`yxtypeBieming` varchar(255) DEFAULT NULL,
`yxinxiBieming` varchar(255) DEFAULT NULL,
`yyijianBieming` varchar(255) DEFAULT NULL,
`yhroleBieming` varchar(255) DEFAULT NULL,
`ggtypeBieming` varchar(255) DEFAULT NULL,
`gonggaoBieming` varchar(255) DEFAULT NULL,
`ggpinglunBieming` varchar(255) DEFAULT NULL,
`shujuBieming` varchar(255) DEFAULT NULL,
`sjduochuBieming` varchar(255) DEFAULT NULL,
`sjjianchuBieming` varchar(255) DEFAULT NULL,
`sjlaiyuanBieming` varchar(255) DEFAULT NULL,
`sjleixingBieming` varchar(255) DEFAULT NULL,
`sjpinglunBieming` varchar(255) DEFAULT NULL,
`sjqitaBieming` varchar(255) DEFAULT NULL,
`sjshaochuBieming` varchar(255) DEFAULT NULL,
`sjxingtaiBieming` varchar(255) DEFAULT NULL,
`jcpeizhiType` int(11) DEFAULT NULL,
`jcpeizhiType1` int(11) DEFAULT NULL,
`jcpeizhiType2` int(11) DEFAULT NULL,
PRIMARY KEY (`jcpeizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcpeizhi
-- ----------------------------
INSERT INTO `t_jcpeizhi` VALUES ('1', '服装连锁店管理系统', 'bdm012fuzhuangliansuo', 'bdm012fuzhuangliansuo', null, null, '门店', '员工', '类型', '信息', '意见', null, null, null, '类型', '客户', '类型', '信息', '反馈', null, '类型', '公告', null, '服装', '采购', '批发', '供应商', '类型', null, '门店', '销售', '品牌', null, null, null);

-- ----------------------------
-- Table structure for `t_rizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_rizhi`;
CREATE TABLE `t_rizhi` (
`rizhiId` int(11) NOT NULL AUTO_INCREMENT,
`rizhiName` varchar(255) NOT NULL,
`dengluIp` varchar(255) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`rizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_rizhi
-- ----------------------------
INSERT INTO `t_rizhi` VALUES ('1', 'admin', '127.0.0.1', '2020-12-10 21:44:12');
INSERT INTO `t_rizhi` VALUES ('2', 'user1', '127.0.0.1', '2020-12-10 21:46:20');
INSERT INTO `t_rizhi` VALUES ('3', 'admin', '127.0.0.1', '2020-12-10 21:48:02');
INSERT INTO `t_rizhi` VALUES ('4', 'admin', '127.0.0.1', '2020-12-10 21:49:01');

-- ----------------------------
-- Table structure for `t_shuju`
-- ----------------------------
DROP TABLE IF EXISTS `t_shuju`;
CREATE TABLE `t_shuju` (
`shujuId` int(11) NOT NULL AUTO_INCREMENT,
`shujuName` varchar(255) DEFAULT NULL,
`shujuMark` varchar(2550) DEFAULT NULL,
`shujuMark1` varchar(2550) DEFAULT NULL,
`shujuMark2` varchar(2550) DEFAULT NULL,
`shujuMark3` varchar(2550) DEFAULT NULL,
`shujuDate` datetime DEFAULT NULL,
`shujuDate1` datetime DEFAULT NULL,
`shujuZong` int(11) DEFAULT NULL,
`shujuZong1` int(11) DEFAULT NULL,
`shujuZong2` int(11) DEFAULT NULL,
`shujuDouble` double DEFAULT NULL,
`shujuDouble1` double DEFAULT NULL,
`shujuDouble2` double DEFAULT NULL,
`shujuDouble3` double DEFAULT NULL,
`shujuDouble4` double DEFAULT NULL,
`shujuType` int(11) DEFAULT NULL,
`shujuType1` int(11) DEFAULT NULL,
`shujuType2` int(11) DEFAULT NULL,
`shujuImg` varchar(255) DEFAULT NULL,
`shujuImgName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`shujuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_shuju
-- ----------------------------
INSERT INTO `t_shuju` VALUES ('1', '服装信息1', '服装信息', null, null, null, '2020-12-10 21:45:30', null, '145', null, null, '100', '2400', '200', '-2200', null, '0', null, null, null, null, '1', '上衣', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_shuju` VALUES ('2', '服装信息2', '服装信息', null, null, null, '2020-12-10 21:45:39', null, '115', null, null, '100', '2550', '600', '-1950', null, '0', null, null, null, null, '2', '裤子', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_shuju` VALUES ('3', '服装信息3', '服装信息', null, null, null, '2020-12-10 21:45:47', null, '81', null, null, '100', '600', '400', '-200', null, '0', null, null, null, null, '2', '裤子', '1', '品牌1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjduochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjduochu`;
CREATE TABLE `t_sjduochu` (
`sjduochuId` int(11) NOT NULL AUTO_INCREMENT,
`sjduochuName` varchar(255) DEFAULT NULL,
`sjduochuMark` varchar(2550) DEFAULT NULL,
`sjduochuMark1` varchar(2550) DEFAULT NULL,
`sjduochuMark2` varchar(2550) DEFAULT NULL,
`sjduochuMark3` varchar(2550) DEFAULT NULL,
`sjduochuDate` datetime DEFAULT NULL,
`sjduochuDate1` datetime DEFAULT NULL,
`sjduochuZong` int(11) DEFAULT NULL,
`sjduochuZong1` int(11) DEFAULT NULL,
`sjduochuZong2` int(11) DEFAULT NULL,
`sjduochuDouble` double DEFAULT NULL,
`sjduochuDouble1` double DEFAULT NULL,
`sjduochuDouble2` double DEFAULT NULL,
`sjduochuType` int(11) DEFAULT NULL,
`sjduochuType1` int(11) DEFAULT NULL,
`sjduochuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjduochuImg` varchar(255) DEFAULT NULL,
`sjduochuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjduochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjduochu
-- ----------------------------
INSERT INTO `t_sjduochu` VALUES ('1', null, null, null, null, null, '2020-12-10 21:47:14', null, '80', null, null, '30', '2400', null, '0', null, null, null, null, '1', '供应商1', null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjduochu` VALUES ('2', null, null, null, null, null, '2020-12-10 21:47:20', null, '85', null, null, '30', '2550', null, '0', null, null, null, null, '1', '供应商1', null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjduochu` VALUES ('3', null, null, null, null, null, '2020-12-10 21:47:26', null, '20', null, null, '30', '600', null, '0', null, null, null, null, '1', '供应商1', null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjjianchu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjjianchu`;
CREATE TABLE `t_sjjianchu` (
`sjjianchuId` int(11) NOT NULL AUTO_INCREMENT,
`sjjianchuName` varchar(255) DEFAULT NULL,
`sjjianchuMark` varchar(2550) DEFAULT NULL,
`sjjianchuMark1` varchar(2550) DEFAULT NULL,
`sjjianchuMark2` varchar(2550) DEFAULT NULL,
`sjjianchuMark3` varchar(2550) DEFAULT NULL,
`sjjianchuDate` datetime DEFAULT NULL,
`sjjianchuDate1` datetime DEFAULT NULL,
`sjjianchuZong` int(11) DEFAULT NULL,
`sjjianchuZong1` int(11) DEFAULT NULL,
`sjjianchuZong2` int(11) DEFAULT NULL,
`sjjianchuDouble` double DEFAULT NULL,
`sjjianchuDouble1` double DEFAULT NULL,
`sjjianchuDouble2` double DEFAULT NULL,
`sjjianchuType` int(11) DEFAULT NULL,
`sjjianchuType1` int(11) DEFAULT NULL,
`sjjianchuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjjianchuImg` varchar(255) DEFAULT NULL,
`sjjianchuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjjianchuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjjianchu
-- ----------------------------
INSERT INTO `t_sjjianchu` VALUES ('1', null, null, null, null, null, '2020-12-10 21:46:37', null, '33', null, null, '3', '99', null, '0', null, null, '1', '门店信息1', null, null, null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjjianchu` VALUES ('2', null, null, null, null, null, '2020-12-10 21:46:47', null, '44', null, null, '3', '132', null, '0', null, null, '2', '门店信息2', null, null, null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjjianchu` VALUES ('3', null, null, null, null, null, '2020-12-10 21:46:57', null, '55', null, null, '3', '165', null, '0', null, null, '2', '门店信息2', null, null, null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjlaiyuan`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjlaiyuan`;
CREATE TABLE `t_sjlaiyuan` (
`sjlaiyuanId` int(11) NOT NULL AUTO_INCREMENT,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjlaiyuanMark` varchar(255) DEFAULT NULL,
`sjlaiyuanMark1` varchar(255) DEFAULT NULL,
`sjlaiyuanMark2` varchar(255) DEFAULT NULL,
`sjlaiyuanPhone` varchar(255) DEFAULT NULL,
`sjlaiyuanDizhi` varchar(255) DEFAULT NULL,
`sjlaiyuanDate` datetime DEFAULT NULL,
`sjlaiyuanDate1` datetime DEFAULT NULL,
`sjlaiyuanType` int(11) DEFAULT NULL,
`sjlaiyuanType1` int(11) DEFAULT NULL,
`sjlaiyuanDouble` double DEFAULT NULL,
`sjlaiyuanDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjlaiyuanId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjlaiyuan
-- ----------------------------
INSERT INTO `t_sjlaiyuan` VALUES ('1', '供应商1', '供应商', null, null, '1301234578', '供应商', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjleixing`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjleixing`;
CREATE TABLE `t_sjleixing` (
`sjleixingId` int(11) NOT NULL AUTO_INCREMENT,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjleixingMark` varchar(255) DEFAULT NULL,
`sjleixingMark1` varchar(255) DEFAULT NULL,
`sjleixingMark2` varchar(255) DEFAULT NULL,
`sjleixingPhone` varchar(255) DEFAULT NULL,
`sjleixingDizhi` varchar(255) DEFAULT NULL,
`sjleixingDate` datetime DEFAULT NULL,
`sjleixingDate1` datetime DEFAULT NULL,
`sjleixingType` int(11) DEFAULT NULL,
`sjleixingType1` int(11) DEFAULT NULL,
`sjleixingDouble` double DEFAULT NULL,
`sjleixingDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjleixingId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjleixing
-- ----------------------------
INSERT INTO `t_sjleixing` VALUES ('1', '上衣', '上衣', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjleixing` VALUES ('2', '裤子', '裤子', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjqita`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjqita`;
CREATE TABLE `t_sjqita` (
`sjqitaId` int(11) NOT NULL AUTO_INCREMENT,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjqitaMark` varchar(255) DEFAULT NULL,
`sjqitaMark1` varchar(255) DEFAULT NULL,
`sjqitaMark2` varchar(255) DEFAULT NULL,
`sjqitaPhone` varchar(255) DEFAULT NULL,
`sjqitaDizhi` varchar(255) DEFAULT NULL,
`sjqitaDate` datetime DEFAULT NULL,
`sjqitaDate1` datetime DEFAULT NULL,
`sjqitaType` int(11) DEFAULT NULL,
`sjqitaType1` int(11) DEFAULT NULL,
`sjqitaDouble` double DEFAULT NULL,
`sjqitaDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjqitaId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjqita
-- ----------------------------
INSERT INTO `t_sjqita` VALUES ('1', '门店信息1', '门店信息', null, null, '13012345678', '门店信息', null, null, null, null, null, null);
INSERT INTO `t_sjqita` VALUES ('2', '门店信息2', '门店信息2', null, null, '13012345678', '门店信息2', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjshaochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjshaochu`;
CREATE TABLE `t_sjshaochu` (
`sjshaochuId` int(11) NOT NULL AUTO_INCREMENT,
`sjshaochuName` varchar(255) DEFAULT NULL,
`sjshaochuMark` varchar(2550) DEFAULT NULL,
`sjshaochuMark1` varchar(2550) DEFAULT NULL,
`sjshaochuMark2` varchar(2550) DEFAULT NULL,
`sjshaochuMark3` varchar(2550) DEFAULT NULL,
`sjshaochuDate` datetime DEFAULT NULL,
`sjshaochuDate1` datetime DEFAULT NULL,
`sjshaochuZong` int(11) DEFAULT NULL,
`sjshaochuZong1` int(11) DEFAULT NULL,
`sjshaochuZong2` int(11) DEFAULT NULL,
`sjshaochuDouble` double DEFAULT NULL,
`sjshaochuDouble1` double DEFAULT NULL,
`sjshaochuDouble2` double DEFAULT NULL,
`sjshaochuType` int(11) DEFAULT NULL,
`sjshaochuType1` int(11) DEFAULT NULL,
`sjshaochuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjshaochuImg` varchar(255) DEFAULT NULL,
`sjshaochuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjshaochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjshaochu
-- ----------------------------
INSERT INTO `t_sjshaochu` VALUES ('1', '第三方', null, null, null, null, '2020-12-10 21:47:39', null, '2', null, null, '100', '200', null, '0', null, null, null, null, null, null, null, null, '1', '服装信息1', '1', '上衣', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjshaochu` VALUES ('2', '第三方', null, null, null, null, '2020-12-10 21:47:46', null, '6', null, null, '100', '600', null, '0', null, null, null, null, null, null, null, null, '2', '服装信息2', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjshaochu` VALUES ('3', '第三方', null, null, null, null, '2020-12-10 21:47:52', null, '4', null, null, '100', '400', null, '0', null, null, null, null, null, null, null, null, '3', '服装信息3', '2', '裤子', '1', '品牌1', '1', 'user1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjxingtai`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjxingtai`;
CREATE TABLE `t_sjxingtai` (
`sjxingtaiId` int(11) NOT NULL AUTO_INCREMENT,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`sjxingtaiMark` varchar(255) DEFAULT NULL,
`sjxingtaiMark1` varchar(255) DEFAULT NULL,
`sjxingtaiMark2` varchar(255) DEFAULT NULL,
`sjxingtaiPhone` varchar(255) DEFAULT NULL,
`sjxingtaiDizhi` varchar(255) DEFAULT NULL,
`sjxingtaiDate` datetime DEFAULT NULL,
`sjxingtaiDate1` datetime DEFAULT NULL,
`sjxingtaiType` int(11) DEFAULT NULL,
`sjxingtaiType1` int(11) DEFAULT NULL,
`sjxingtaiDouble` double DEFAULT NULL,
`sjxingtaiDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjxingtaiId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjxingtai
-- ----------------------------
INSERT INTO `t_sjxingtai` VALUES ('1', '品牌1', '品牌', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) DEFAULT NULL,
`userPassword` varchar(255) DEFAULT NULL,
`userXingming` varchar(255) DEFAULT NULL,
`userSex` int(11) DEFAULT NULL,
`userAge` int(11) DEFAULT NULL,
`userMinzu` varchar(255) DEFAULT NULL,
`userPhone` varchar(255) DEFAULT NULL,
`userMark` varchar(2550) DEFAULT NULL,
`userMark1` varchar(255) DEFAULT NULL,
`userMark2` varchar(255) DEFAULT NULL,
`userMark3` varchar(255) DEFAULT NULL,
`userMark4` varchar(255) DEFAULT NULL,
`userDate` datetime DEFAULT NULL,
`userDate1` datetime DEFAULT NULL,
`userDate2` datetime DEFAULT NULL,
`userType` int(11) DEFAULT NULL,
`userType1` int(11) DEFAULT NULL,
`userType2` int(11) DEFAULT NULL,
`userDouble` double DEFAULT NULL,
`userDouble1` double DEFAULT NULL,
`userDouble2` double DEFAULT NULL,
`userZong` int(11) DEFAULT NULL,
`userZong1` int(11) DEFAULT NULL,
`userZong2` int(11) DEFAULT NULL,
`userImg` varchar(255) DEFAULT NULL,
`userImgName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'user1', 'user1', 'user1', '0', '22', null, '13012345678', null, null, null, null, null, '2020-12-10 21:44:24', null, null, '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

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