基于ssm+jsp+vue的库存管理系统

/* Navicat MySQL Data Transfer Source Server : admin Source Server Version : 80011 Source Host : localhost:3306 Source Database : storehouse Target Server Type : MYSQL Target Server Version : 80011 File Encoding : 65001 Date: 2022-06-17 09:39:14 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `id` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pwd` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `sex` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `phone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admins -- ---------------------------- INSERT INTO `admins` VALUES ('10001', '111111', '张三丰', '女', '12345678911'); INSERT INTO `admins` VALUES ('10002', '222222', '李四', '女', '12345678902'); -- ---------------------------- -- Table structure for client -- ---------------------------- DROP TABLE IF EXISTS `client`; CREATE TABLE `client` ( `clientid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `clientname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `address` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `credit` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `contact` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`clientid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of client -- ---------------------------- INSERT INTO `client` VALUES ('0000003', 'jay有限公司', '广州航海学院', 'AA', '李世权', '07065794352'); INSERT INTO `client` VALUES ('000004576', 'jay有限公司', '广州航海学院', 'A', '李世权', '07065794352'); INSERT INTO `client` VALUES ('34', '踏地制鞋股份公司', '广州航海学院', 'A', '李世权', '07065794352'); INSERT INTO `client` VALUES ('46345', '踏地制鞋股份公司', '广州航海学院', 'A', '李世权', '07065794352'); INSERT INTO `client` VALUES ('6574', '一文文具公司', '广州航海学院', 'A', '李世权', '07065794352'); INSERT INTO `client` VALUES ('745', '踏地制鞋股份公司', '广州航海学院', 'A', '李世权', '07065794352'); -- ---------------------------- -- Table structure for employee -- ---------------------------- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `id` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pwd` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `name` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of employee -- ---------------------------- INSERT INTO `employee` VALUES ('2010010', '123456', '丁瑰绮', '女', '83876426'); INSERT INTO `employee` VALUES ('2010012', '123456', '杜兹明', '男', '63657489'); INSERT INTO `employee` VALUES ('2020007', '123456', '林二木', '女', '87809821'); INSERT INTO `employee` VALUES ('3060008', '123456', '张小芳', '女', '84561324'); INSERT INTO `employee` VALUES ('3060102', '123456', '李西飞', '男', '89863576'); INSERT INTO `employee` VALUES ('3060303', '123456', '陈应琳', '女', '68908742'); -- ---------------------------- -- Table structure for fgoods -- ---------------------------- DROP TABLE IF EXISTS `fgoods`; CREATE TABLE `fgoods` ( `goodsid` varchar(12) NOT NULL, `goodsname` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `unit` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `num` int(11) DEFAULT NULL, `price` double(10,2) DEFAULT NULL, `weight` double(10,2) DEFAULT NULL, `smalltotal` double(10,2) DEFAULT NULL, PRIMARY KEY (`goodsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fgoods -- ---------------------------- INSERT INTO `fgoods` VALUES ('7', '球鞋', 'A', '1kg/双', '200', '1.00', '200000.00', '1000.00'); INSERT INTO `fgoods` VALUES ('8888', '37', 'A', '1kg/双', '100', '100.00', '200000.00', '1000.00'); -- ---------------------------- -- Table structure for fig -- ---------------------------- DROP TABLE IF EXISTS `fig`; CREATE TABLE `fig` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `inorderid` varchar(10) DEFAULT NULL, `goodsid` int(12) DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fig -- ---------------------------- INSERT INTO `fig` VALUES ('14', '0000006787', '423'); INSERT INTO `fig` VALUES ('15', '4351221', '8888'); INSERT INTO `fig` VALUES ('16', '145676', '7'); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `goodsid` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `goodsname` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `unit` varchar(11) DEFAULT NULL, `num` int(11) DEFAULT NULL, `price` double(10,2) DEFAULT NULL, `weight` double(10,2) DEFAULT NULL, `smalltotal` double(10,2) DEFAULT NULL, PRIMARY KEY (`goodsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '33', 'A', '1kg/双', '100', '100.00', '100.00', '100.00'); INSERT INTO `goods` VALUES ('2', '猪皮童鞋', 'C', '1kg/双', '187878435', '10.00', '2334.00', '1000045.00'); INSERT INTO `goods` VALUES ('8', '猪皮童鞋', 'B', '1kg/双', '1100', '30.00', '4452.00', '10132.00'); INSERT INTO `goods` VALUES ('88', '14', 'B', '1kg/双', '1013', '1.00', '113.00', '2000.00'); INSERT INTO `goods` VALUES ('99', '67', 'A', '1kg/双', '1100', '1.00', '23523.00', '2000.00'); -- ---------------------------- -- Table structure for ig -- ---------------------------- DROP TABLE IF EXISTS `ig`; CREATE TABLE `ig` ( `igid` int(11) NOT NULL AUTO_INCREMENT, `inorderid` varchar(10) DEFAULT NULL, `goodsid` varchar(12) DEFAULT NULL, PRIMARY KEY (`igid`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of ig -- ---------------------------- INSERT INTO `ig` VALUES ('33', '1332', '1'); INSERT INTO `ig` VALUES ('34', '1332', '2'); INSERT INTO `ig` VALUES ('35', '145676', '8'); INSERT INTO `ig` VALUES ('36', '100000000', '99'); INSERT INTO `ig` VALUES ('37', '100000000', '88'); -- ---------------------------- -- Table structure for inorder -- ---------------------------- DROP TABLE IF EXISTS `inorder`; CREATE TABLE `inorder` ( `inorderid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `id` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `clientid` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sum` double(10,0) DEFAULT NULL, `indate` date DEFAULT NULL, PRIMARY KEY (`inorderid`), KEY `oclientid` (`clientid`), KEY `oid` (`id`), CONSTRAINT `oclientid` FOREIGN KEY (`clientid`) REFERENCES `client` (`clientid`) ON UPDATE CAS