基于JSP的企业仓储管理系统源码.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm75274 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','http://localhost:8080/jspm75274/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspm75274/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspm75274/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gonggaoxinxi` -- DROP TABLE IF EXISTS `gonggaoxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gonggaoxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `gonggaobiaoti` varchar(200) NOT NULL COMMENT '公告标题', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `neirong` longtext COMMENT '内容', `faburiqi` date DEFAULT NULL COMMENT '发布日期', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='公告信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gonggaoxinxi` -- LOCK TABLES `gonggaoxinxi` WRITE; /*!40000 ALTER TABLE `gonggaoxinxi` DISABLE KEYS */; INSERT INTO `gonggaoxinxi` VALUES (11,'2022-04-04 06:50:03','公告标题1','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian1.jpg','内容1','2022-04-04'),(12,'2022-04-04 06:50:03','公告标题2','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian2.jpg','内容2','2022-04-04'),(13,'2022-04-04 06:50:03','公告标题3','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian3.jpg','内容3','2022-04-04'),(14,'2022-04-04 06:50:03','公告标题4','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian4.jpg','内容4','2022-04-04'),(15,'2022-04-04 06:50:03','公告标题5','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian5.jpg','内容5','2022-04-04'),(16,'2022-04-04 06:50:03','公告标题6','http://localhost:8080/jspm75274/upload/gonggaoxinxi_tupian6.jpg','内容6','2022-04-04'); /*!40000 ALTER TABLE `gonggaoxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gongyingshang` -- DROP TABLE IF EXISTS `gongyingshang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gongyingshang` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `gongyingshangzhanghao` varchar(200) NOT NULL COMMENT '供应商账号', `mima` varchar(200) NOT NULL COMMENT '密码', `gongyingshangmingcheng` varchar(200) NOT NULL COMMENT '供应商名称', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `lianxiren` varchar(200) NOT NULL COMMENT '联系人', `zhiwu` varchar(200) DEFAULT NULL COMMENT '职务', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', `lianxidizhi` varchar(200) DEFAULT NULL COMMENT '联系地址', PRIMARY KEY (`id`), UNIQUE KEY `gongyingshangzhanghao` (`gongyingshangzhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='供应商'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gongyingshang` -- LOCK TABLES `gongyingshang` WRITE; /*!40000 ALTER TABLE `gongyingshang` DISABLE KEYS */; INSERT INTO `gongyingshang` VALUES (31,'2022-04-04 06:50:03','供应商1','123456','供应商名称1','http://localhost:8080/jspm75274/upload/gongyingshang_tupian1.jpg','联系人1','职务1','13823888881','联系地址1'),(32,'2022-04-04 06:50:03','供应商2','123456','供应商名称2','http://localhost:8080/jspm75274/upload/gongyingshang_tupian2.jpg','联系人2','职务2','13823888882','联系地址2'),(33,'2022-04-04 06:50:03','供应商3','123456','供应商名称3','http://localhost:8080/jspm75274/upload/gongyingshang_tupian3.jpg','联系人3','职务3','13823888883','联系地址3'),(34,'2022-04-04 06:50:03','供应商4','123456','供应商名称4','http://localhost:8080/jspm75274/upload/gongyingshang_tupian4.jpg','联系人4','职务4','13823888884','联系地址4'),(35,'2022-04-04 06:50:03','供应商5','123456','供应商名称5','http://localhost:8080/jspm75274/upload/gongyingshang_tupian5.jpg','联系人5','职务5','13823888885','联系地址5'),(36,'2022-04-04 06:50:03','供应商6','123456','供应商名称6','http://localhost:8080/jspm75274/upload/gongyingshang_tupian6.jpg','联系人6','职务6','13823888886','联系地址6'); /*!40000 ALTER TABLE `gongyingshang` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gongyingshanghuowu` -- DROP TABLE IF EXISTS `gongyingshanghuowu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gongyingshanghuowu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称', `fenlei` varchar(200) DEFAULT NULL COMMENT '分类', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `guige` varchar(200) DEFAULT NULL COMMENT '规格', `danjia` int(11) DEFAULT NULL COMMENT '单价', `shuliang` int(11) DEFAULT NULL COMMENT '数量', `gongyingshangzhanghao` varchar(200) DEFAULT NULL COMMENT '供应商账号', `gongyingshangmingcheng` varchar(200) DEFAULT NULL COMMENT '供应商名称', `lianxiren` varchar(200) DEFAULT NULL COMMENT '联系人', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='供应商货物'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gongyingshanghuowu` -- LOCK TABLES `gongyingshanghuowu` WRITE; /*!40000 ALTER TABLE `gongyingshanghuowu` DISABLE KEYS */; INSERT INTO `gongyingshanghuowu` VALUES (51,'2022-04-04 06:50:03','商品名称1','分类1','http://localhost:8080/jspm75274/upload/gongyingshanghuowu_tupian1.jpg','规格1',1,1,'供应商账号1','供应商名称1','联系人1','联系电话1'),(52,'2022-04-04 06:50:03','商品名称2','分类2','http://localhost:8080/jspm75274/upload/gongyingshanghuowu_tupian2.jpg','规格2',2,2,'供应商账号2','供应商名称2','联系人2','联系电话2'),(53,'2022-04-04 06:50:03','商品名称3','分类3','http://localhost:8080/jspm75274/upload/gongyingshanghuowu_tupian3.jpg','规格3',3,3,'供应商账号3','供应商名称3','联系人3','联系电话3'),(54,'2022-04-04 06:50:03',