一、前言
首先,论文一开始便是清楚地论述了系统的研究内容。其次,剖析系统需求分析,弄明白“做什么”,分析包括业务分析和业务流程的分析以及用例分析,更进一步明确系统的需求。然后在明白了系统的需求基础上需要进一步设计系统,主要包括软件架构模式、整体功能模块、数据库设计。本项目软件架构选择B/S模式,总体功能模块运用自顶向下的分层思想。再然后就是实现系统并进行代码编写实现功能。论文的最后章节总结一下自己完成本论文和开发本项目的心得和总结。通过学校小卖部收银系统将会使学校小卖部收银各个方面的工作效率带来实质性的提升。
二、开发环境
开发语言:Java
框架:ssm
技术:JSP
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
后台路径地址:localhost:8080/项目名称/jsp/login.jsp
前台路径地址:localhost:8080/项目名称/front/index.jsp (无前台不需要输入)
管理员账号:abo
管理员密码:abo
三、系统功能效果
四、核心代码
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: jspmuwf3w
-- ------------------------------------------------------
-- 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 */;
--
-- Current Database: `jspmuwf3w`
--
/*!40000 DROP DATABASE IF EXISTS `jspmuwf3w`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspmuwf3w` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `jspmuwf3w`;
--
-- Table structure for table `address`
--
DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`address` varchar(200) NOT NULL COMMENT '地址',
`name` varchar(200) NOT NULL COMMENT '收货人',
`phone` varchar(200) NOT NULL COMMENT '电话',
`isdefault` varchar(200) NOT 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 `address`
--
LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,'2022-05-10 01:45:50',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-05-10 01:45:50',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-05-10 01:45:50',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-05-10 01:45:50',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-05-10 01:45:50',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-05-10 01:45:50',16,'宇宙银河系月球1号','月某','13823888886','是');
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cart`
--
DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`goodid` bigint(20) NOT NULL COMMENT '商品id',
`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
`picture` varchar(200) DEFAULT NULL COMMENT '图片',
`buynumber` int(11) NOT NULL COMMENT '购买数量',
`price` float DEFAULT NULL COMMENT '单价',
`discountprice` float DEFAULT NULL COMMENT '会员价',
`goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cart`
--
LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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=4 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','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` 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 '创建时间',
`gongyingshangbianhao` varchar(200) DEFAULT NULL COMMENT '供应商编号',
`gongyingshangmingcheng` varchar(200) NOT NULL COMMENT '供应商名称',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`fuzerenxingming` varchar(200) NOT NULL COMMENT '负责人姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`gongyingshangpin` longtext COMMENT '供应商品',
PRIMARY KEY (`id`),
UNIQUE KEY `gongyingshangbianhao` (`gongyingshangbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 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 (51,'2022-05-10 01:45:50','1111111111','供应商名称1','地址1','负责人姓名1','13823888881','供应商品1'),(52,'2022-05-10 01:45:50','2222222222','供应商名称2','地址2','负责人姓名2','13823888882','供应商品2'),(53,'2022-05-10 01:45:50','3333333333','供应商名称3','地址3','负责人姓名3','13823888883','供应商品3'),(54,'2022-05-10 01:45:50','4444444444','供应商名称4','地址4','负责人姓名4','13823888884','供应商品4'),(55,'2022-05-10 01:45:50','5555555555','供应商名称5','地址5','负责人姓名5','13823888885','供应商品5'),(56,'2022-05-10 01:45:50','6666666666','供应商名称6','地址6','负责人姓名6','13823888886','供应商品6');
/*!40000 ALTER TABLE `gongyingshang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`orderid` varchar(200) NOT NULL COMMENT '订单编号',
`tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`goodid` bigint(20) NOT NULL COMMENT '商品id',
`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
`picture` varchar(200) DEFAULT NULL COMMENT '商品图片',
`buynumber` int(11) NOT NULL COMMENT '购买数量',
`price` float NOT NULL DEFAULT '0' COMMENT '价格',
`discountprice` float DEFAULT '0' COMMENT '折扣价格',
`total` float NOT NULL DEFAULT '0' COMMENT '总价格',
`discounttotal` float DEFAULT '0' COMMENT '折扣总价格',
`type` int(11) DEFAULT '1' COMMENT '支付类型',
`status` varchar(200) DEFAULT NULL COMMENT '状态',
`address` varchar(200) DEFAULT NULL COMMENT '地址',
`tel` varchar(200) DEFAULT NULL COMMENT '电话',
`consignee` varchar(200) DEFAULT NULL COMMENT '收货人',
`logistics` longtext COMMENT '物流',
`goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型',
PRIMARY KEY (`id`),
UNIQUE KEY `orderid` (`orderid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpinfenlei`
--
DROP TABLE IF EXISTS `shangpinfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpinfenlei`
--
LOCK TABLES `shangpinfenlei` WRITE;
/*!40000 ALTER TABLE `shangpinfenlei` DISABLE KEYS */;
INSERT INTO `shangpinfenlei` VALUES (31,'2022-05-10 01:45:50','商品分类1'),(32,'2022-05-10 01:45:50','商品分类2'),(33,'2022-05-10 01:45:50','商品分类3'),(34,'2022-05-10 01:45:50','商品分类4'),(35,'2022-05-10 01:45:50','商品分类5'),(36,'2022-05-10 01:45:50','商品分类6');
/*!40000 ALTER TABLE `shangpinfenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpinjinhuo`
--
DROP TABLE IF EXISTS `shangpinjinhuo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinjinhuo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`jinhuojia` float DEFAULT NULL COMMENT '进货价',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`jinhuojine` float DEFAULT NULL COMMENT '进货金额',
`jinhuoshijian` datetime DEFAULT NULL COMMENT '进货时间',
`gongyingshangmingcheng` varchar(200) DEFAULT NULL COMMENT '供应商名称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='商品进货';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpinjinhuo`
--
LOCK TABLES `shangpinjinhuo` WRITE;
/*!40000 ALTER TABLE `shangpinjinhuo` DISABLE KEYS */;
INSERT INTO `shangpinjinhuo` VALUES (61,'2022-05-10 01:45:50','商品编号1','商品名称1','品牌1','规格1',1,1,1,'2022-05-10 09:45:50','供应商名称1','联系电话1'),(62,'2022-05-10 01:45:50','商品编号2','商品名称2','品牌2','规格2',2,2,2,'2022-05-10 09:45:50','供应商名称2','联系电话2'),(63,'2022-05-10 01:45:50','商品编号3','商品名称3','品牌3','规格3',3,3,3,'2022-05-10 09:45:50','供应商名称3','联系电话3'),(64,'2022-05-10 01:45:50','商品编号4','商品名称4','品牌4','规格4',4,4,4,'2022-05-10 09:45:50','供应商名称4','联系电话4'),(65,'2022-05-10 01:45:50','商品编号5','商品名称5','品牌5','规格5',5,5,5,'2022-05-10 09:45:50','供应商名称5','联系电话5'),(66,'2022-05-10 01:45:50','商品编号6','商品名称6','品牌6','规格6',6,6,6,'2022-05-10 09:45:50','供应商名称6','联系电话6');
/*!40000 ALTER TABLE `shangpinjinhuo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpinxinxi`
--
DROP TABLE IF EXISTS `shangpinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`shangpinmingcheng` varchar(200) NOT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) NOT NULL COMMENT '商品分类',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`tupian` varchar(200) NOT NULL COMMENT '图片',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shangpinxiangqing` longtext COMMENT '商品详情',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`price` float DEFAULT NULL COMMENT '价格',
`vipprice` float DEFAULT '-1' COMMENT '会员价',
`onelimittimes` int(11) DEFAULT '-1' COMMENT '单限',
`alllimittimes` int(11) DEFAULT '-1' COMMENT '库存',
PRIMARY KEY (`id`),
UNIQUE KEY `shangpinbianhao` (`shangpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='商品信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpinxinxi`
--
LOCK TABLES `shangpinxinxi` WRITE;
/*!40000 ALTER TABLE `shangpinxinxi` DISABLE KEYS */;
INSERT INTO `shangpinxinxi` VALUES (41,'2022-05-10 01:45:50','1111111111','商品名称1','商品分类1','品牌1','upload/shangpinxinxi_tupian1.jpg','规格1','商品详情1','2022-05-10 09:47:41',3,99.9,1,1,99),(42,'2022-05-10 01:45:50','2222222222','商品名称2','商品分类2','品牌2','upload/shangpinxinxi_tupian2.jpg','规格2','商品详情2','2022-05-10 09:45:50',2,99.9,2,2,99),(43,'2022-05-10 01:45:50','3333333333','商品名称3','商品分类3','品牌3','upload/shangpinxinxi_tupian3.jpg','规格3','商品详情3','2022-05-10 09:45:50',3,99.9,3,3,99),(44,'2022-05-10 01:45:50','4444444444','商品名称4','商品分类4','品牌4','upload/shangpinxinxi_tupian4.jpg','规格4','商品详情4','2022-05-10 09:45:50',4,99.9,4,4,99),(45,'2022-05-10 01:45:50','5555555555','商品名称5','商品分类5','品牌5','upload/shangpinxinxi_tupian5.jpg','规格5','商品详情5','2022-05-10 09:45:50',5,99.9,5,5,99),(46,'2022-05-10 01:45:50','6666666666','商品名称6','商品分类6','品牌6','upload/shangpinxinxi_tupian6.jpg','规格6','商品详情6','2022-05-10 09:45:50',6,99.9,6,6,99);
/*!40000 ALTER TABLE `shangpinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,11,'用户账号1','yonghu','用户','g7yepdsd0w3lev08z4vajgyhfumm73g5','2022-05-10 01:47:40','2022-05-10 02:47:40');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-05-10 01:45:50');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`money` float DEFAULT '0' COMMENT '余额',
`vip` varchar(200) DEFAULT '否' COMMENT '是否会员',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghu`
--
LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2022-05-10 01:45:50','用户账号1','123456','用户姓名1','upload/yonghu_touxiang1.jpg','男','13823888881',100,'否'),(12,'2022-05-10 01:45:50','用户账号2','123456','用户姓名2','upload/yonghu_touxiang2.jpg','男','13823888882',100,'否'),(13,'2022-05-10 01:45:50','用户账号3','123456','用户姓名3','upload/yonghu_touxiang3.jpg','男','13823888883',100,'否'),(14,'2022-05-10 01:45:50','用户账号4','123456','用户姓名4','upload/yonghu_touxiang4.jpg','男','13823888884',100,'否'),(15,'2022-05-10 01:45:50','用户账号5','123456','用户姓名5','upload/yonghu_touxiang5.jpg','男','13823888885',100,'否'),(16,'2022-05-10 01:45:50','用户账号6','123456','用户姓名6','upload/yonghu_touxiang6.jpg','男','13823888886',100,'否');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yuangong`
--
DROP TABLE IF EXISTS `yuangong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuangong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuangongzhanghao` varchar(200) NOT NULL COMMENT '员工账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yuangongxingming` varchar(200) NOT NULL COMMENT '员工姓名',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
`shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
`zhiwei` varchar(200) DEFAULT NULL COMMENT '职位',
`money` float DEFAULT '0' COMMENT '余额',
`vip` varchar(200) DEFAULT '否' COMMENT '是否会员',
PRIMARY KEY (`id`),
UNIQUE KEY `yuangongzhanghao` (`yuangongzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='员工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yuangong`
--
LOCK TABLES `yuangong` WRITE;
/*!40000 ALTER TABLE `yuangong` DISABLE KEYS */;
INSERT INTO `yuangong` VALUES (21,'2022-05-10 01:45:50','员工账号1','123456','员工姓名1','upload/yuangong_touxiang1.jpg','男','13823888881','440300199101010001','职位1',100,'否'),(22,'2022-05-10 01:45:50','员工账号2','123456','员工姓名2','upload/yuangong_touxiang2.jpg','男','13823888882','440300199202020002','职位2',100,'否'),(23,'2022-05-10 01:45:50','员工账号3','123456','员工姓名3','upload/yuangong_touxiang3.jpg','男','13823888883','440300199303030003','职位3',100,'否'),(24,'2022-05-10 01:45:50','员工账号4','123456','员工姓名4','upload/yuangong_touxiang4.jpg','男','13823888884','440300199404040004','职位4',100,'否'),(25,'2022-05-10 01:45:50','员工账号5','123456','员工姓名5','upload/yuangong_touxiang5.jpg','男','13823888885','440300199505050005','职位5',100,'否'),(26,'2022-05-10 01:45:50','员工账号6','123456','员工姓名6','upload/yuangong_touxiang6.jpg','男','13823888886','440300199606060006','职位6',100,'否');
/*!40000 ALTER TABLE `yuangong` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-05-10 13:10:22