小型企业网站有哪些,景泰县做网站,苏州网址,律师手机网站模板末尾获取源码 开发语言#xff1a;Java Java开发工具#xff1a;JDK1.8 后端框架#xff1a;SSM 前端#xff1a;采用Vue技术开发 数据库#xff1a;MySQL5.7和Navicat管理工具结合 服务器#xff1a;Tomcat8.5 开发软件#xff1a;IDEA / Eclipse 是否Maven项目#x… 末尾获取源码 开发语言Java Java开发工具JDK1.8 后端框架SSM 前端采用Vue技术开发 数据库MySQL5.7和Navicat管理工具结合 服务器Tomcat8.5 开发软件IDEA / Eclipse 是否Maven项目是 目录
一、项目简介
二、论文截图
三、系统项目截图
3.1管理员功能实现
3.2用户功能实现
四、核心代码
4.1登录相关
4.2文件上传
4.3封装
4.4sql语句 一、项目简介
网络技术和计算机技术发展至今已经拥有了深厚的理论基础并在现实中进行了充分运用尤其是基于计算机运行的软件更是受到各界的关注。加上现在人们已经步入信息时代所以对于信息的宣传和管理就很关键。因此鲜花销售信息的管理计算机化系统化是必要的。设计开发网上花店不仅会节约人力和管理成本还会安全保存庞大的数据量对于鲜花销售信息的维护和检索也不需要花费很多时间非常的便利。
网上花店是在MySQL中建立数据表保存信息运用SSMVue框架和Java语言编写。并按照软件设计开发流程进行设计实现。系统具备友好性且功能完善。管理员登录进入本人后台之后主要完成花材选择管理用户管理鲜花管理鲜花出入库管理鲜花订单管理等。用户联系客服咨询问题查看鲜花可以收藏购买评论鲜花支付订单管理个人订单等。
网上花店在让鲜花销售信息规范化的同时也能及时通过数据输入的有效性规则检测出错误数据让数据的录入达到准确性的目的进而提升网上花店提供的数据的可靠性让系统数据的错误率降至最低。 二、论文截图 三、系统项目截图
3.1管理员功能实现
管理员权限中的花材选择管理其运行效果见下图。花材选择管理需要管理员登记花材删除修改花材查询花材等。 管理员权限中的鲜花信息管理其运行效果见下图。管理员在本模块登记鲜花信息修改删除鲜花信息对鲜花进行出入库管理查看鲜花评论等。 管理员权限中的鲜花入库管理其运行效果见下图。已经入库的鲜花信息管理员可以管理也能查看其中的管理包括对入库的鲜花修改删除查询等。 管理员权限中的鲜花出库管理其运行效果见下图。已经出库的鲜花信息管理员可以管理也能查看其中的管理包括对出库的鲜花修改删除查询等。 管理员权限中的已完成订单其运行效果见下图。已完成订单只是订单管理的一部分功能订单管理包括了已支付订单未支付订单取消的订单已发货订单已退款订单的管理。在已完成订单页面上管理员能够直接查看订单详细查询订单。 3.2用户功能实现
用户权限中的联系客服其运行效果见下图。用户在操作过程中可以联系客服咨询鲜花相关信息客服会指引用户购买鲜花解答用户疑问。 用户权限中的鲜花信息其运行效果见下图。用户在本页面可以操作的功能比较多可以购买收藏评论鲜花可以添加鲜花至购物车。 用户权限中的购买鲜花其运行效果见下图。用户直接购买鲜花就会进入下面的操作页面用户选择地址进行支付即可。 用户权限中的我的订单其运行效果见下图。用户已支付订单可以在我的订单模块中在已支付栏下面查看订单也能进行订单退款。 四、核心代码
4.1登录相关 package com.controller;import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;/*** 登录相关*/
RequestMapping(users)
RestController
public class UserController{Autowiredprivate UserService userService;Autowiredprivate TokenService tokenService;/*** 登录*/IgnoreAuthPostMapping(value /login)public R login(String username, String password, String captcha, HttpServletRequest request) {UserEntity user userService.selectOne(new EntityWrapperUserEntity().eq(username, username));if(usernull || !user.getPassword().equals(password)) {return R.error(账号或密码不正确);}String token tokenService.generateToken(user.getId(),username, users, user.getRole());return R.ok().put(token, token);}/*** 注册*/IgnoreAuthPostMapping(value /register)public R register(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapperUserEntity().eq(username, user.getUsername())) !null) {return R.error(用户已存在);}userService.insert(user);return R.ok();}/*** 退出*/GetMapping(value logout)public R logout(HttpServletRequest request) {request.getSession().invalidate();return R.ok(退出成功);}/*** 密码重置*/IgnoreAuthRequestMapping(value /resetPass)public R resetPass(String username, HttpServletRequest request){UserEntity user userService.selectOne(new EntityWrapperUserEntity().eq(username, username));if(usernull) {return R.error(账号不存在);}user.setPassword(123456);userService.update(user,null);return R.ok(密码已重置为123456);}/*** 列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params,UserEntity user){EntityWrapperUserEntity ew new EntityWrapperUserEntity();PageUtils page userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));return R.ok().put(data, page);}/*** 列表*/RequestMapping(/list)public R list( UserEntity user){EntityWrapperUserEntity ew new EntityWrapperUserEntity();ew.allEq(MPUtil.allEQMapPre( user, user)); return R.ok().put(data, userService.selectListView(ew));}/*** 信息*/RequestMapping(/info/{id})public R info(PathVariable(id) String id){UserEntity user userService.selectById(id);return R.ok().put(data, user);}/*** 获取用户的session用户信息*/RequestMapping(/session)public R getCurrUser(HttpServletRequest request){Long id (Long)request.getSession().getAttribute(userId);UserEntity user userService.selectById(id);return R.ok().put(data, user);}/*** 保存*/PostMapping(/save)public R save(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapperUserEntity().eq(username, user.getUsername())) !null) {return R.error(用户已存在);}userService.insert(user);return R.ok();}/*** 修改*/RequestMapping(/update)public R update(RequestBody UserEntity user){
// ValidatorUtils.validateEntity(user);userService.updateById(user);//全部更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Long[] ids){userService.deleteBatchIds(Arrays.asList(ids));return R.ok();}
}4.2文件上传
package com.controller;import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Arrays;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import java.util.UUID;import org.apache.commons.io.FileUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.util.ResourceUtils;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.ConfigEntity;
import com.entity.EIException;
import com.service.ConfigService;
import com.utils.R;/*** 上传文件映射表*/
RestController
RequestMapping(file)
SuppressWarnings({unchecked,rawtypes})
public class FileController{Autowiredprivate ConfigService configService;/*** 上传文件*/RequestMapping(/upload)public R upload(RequestParam(file) MultipartFile file,String type) throws Exception {if (file.isEmpty()) {throw new EIException(上传文件不能为空);}String fileExt file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(.)1);File path new File(ResourceUtils.getURL(classpath:static).getPath());if(!path.exists()) {path new File();}File upload new File(path.getAbsolutePath(),/upload/);if(!upload.exists()) {upload.mkdirs();}String fileName new Date().getTime().fileExt;File dest new File(upload.getAbsolutePath()/fileName);file.transferTo(dest);FileUtils.copyFile(dest, new File(C:\\Users\\Desktop\\jiadian\\springbootl7own\\src\\main\\resources\\static\\upload/fileName));if(StringUtils.isNotBlank(type) type.equals(1)) {ConfigEntity configEntity configService.selectOne(new EntityWrapperConfigEntity().eq(name, faceFile));if(configEntitynull) {configEntity new ConfigEntity();configEntity.setName(faceFile);configEntity.setValue(fileName);} else {configEntity.setValue(fileName);}configService.insertOrUpdate(configEntity);}return R.ok().put(file, fileName);}/*** 下载文件*/IgnoreAuthRequestMapping(/download)public ResponseEntitybyte[] download(RequestParam String fileName) {try {File path new File(ResourceUtils.getURL(classpath:static).getPath());if(!path.exists()) {path new File();}File upload new File(path.getAbsolutePath(),/upload/);if(!upload.exists()) {upload.mkdirs();}File file new File(upload.getAbsolutePath()/fileName);if(file.exists()){/*if(!fileService.canRead(file, SessionManager.getSessionUser())){getResponse().sendError(403);}*/HttpHeaders headers new HttpHeaders();headers.setContentType(MediaType.APPLICATION_OCTET_STREAM); headers.setContentDispositionFormData(attachment, fileName); return new ResponseEntitybyte[](FileUtils.readFileToByteArray(file),headers, HttpStatus.CREATED);}} catch (IOException e) {e.printStackTrace();}return new ResponseEntitybyte[](HttpStatus.INTERNAL_SERVER_ERROR);}}4.3封装
package com.utils;import java.util.HashMap;
import java.util.Map;/*** 返回数据*/
public class R extends HashMapString, Object {private static final long serialVersionUID 1L;public R() {put(code, 0);}public static R error() {return error(500, 未知异常请联系管理员);}public static R error(String msg) {return error(500, msg);}public static R error(int code, String msg) {R r new R();r.put(code, code);r.put(msg, msg);return r;}public static R ok(String msg) {R r new R();r.put(msg, msg);return r;}public static R ok(MapString, Object map) {R r new R();r.putAll(map);return r;}public static R ok() {return new R();}public R put(String key, Object value) {super.put(key, value);return this;}
}4.4sql语句
/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - ssm5n2mk
*********************************************************************
*//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE*/;/*!40014 SET OLD_UNIQUE_CHECKSUNIQUE_CHECKS, UNIQUE_CHECKS0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS0 */;
/*!40101 SET OLD_SQL_MODESQL_MODE, SQL_MODENO_AUTO_VALUE_ON_ZERO */;
/*!40111 SET OLD_SQL_NOTESSQL_NOTES, SQL_NOTES0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ssm5n2mk /*!40100 DEFAULT CHARACTER SET utf8 */;USE ssm5n2mk;/*Table structure for table address */DROP TABLE IF EXISTS address;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)
) ENGINEInnoDB AUTO_INCREMENT1611546786897 DEFAULT CHARSETutf8 COMMENT地址;/*Data for the table address */insert into address(id,addtime,userid,address,name,phone,isdefault) values (1,2021-01-25 11:42:19,1,宇宙银河系金星1号,金某,13823888881,是),(2,2021-01-25 11:42:19,2,宇宙银河系木星1号,木某,13823888882,是),(3,2021-01-25 11:42:19,3,宇宙银河系水星1号,水某,13823888883,是),(4,2021-01-25 11:42:19,4,宇宙银河系火星1号,火某,13823888884,是),(5,2021-01-25 11:42:19,5,宇宙银河系土星1号,土某,13823888885,是),(6,2021-01-25 11:42:19,6,宇宙银河系月球1号,月某,13823888886,是),(1611546786896,2021-01-25 11:53:06,1611546730956,广东省梅州市梅县区新城街道丽景湾(嘉应西二巷),1,12312312312,是);/*Table structure for table cart */DROP TABLE IF EXISTS cart;CREATE TABLE cart (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,tablename varchar(200) DEFAULT xianhuaxinxi 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 会员价,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546903462 DEFAULT CHARSETutf8 COMMENT购物车表;/*Data for the table cart *//*Table structure for table chat */DROP TABLE IF EXISTS chat;CREATE TABLE chat (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,adminid bigint(20) DEFAULT NULL COMMENT 管理员id,ask longtext COMMENT 提问,reply longtext COMMENT 回复,isreply int(11) DEFAULT NULL COMMENT 是否回复,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611547021005 DEFAULT CHARSETutf8 COMMENT客服聊天表;/*Data for the table chat */insert into chat(id,addtime,userid,adminid,ask,reply,isreply) values (61,2021-01-25 11:42:19,1,1,提问1,回复1,1),(62,2021-01-25 11:42:19,2,2,提问2,回复2,2),(63,2021-01-25 11:42:19,3,3,提问3,回复3,3),(64,2021-01-25 11:42:19,4,4,提问4,回复4,4),(65,2021-01-25 11:42:19,5,5,提问5,回复5,5),(66,2021-01-25 11:42:19,6,6,提问6,回复6,6),(1611546951493,2021-01-25 11:55:51,1611546730956,NULL,在吗,NULL,0),(1611546961573,2021-01-25 11:56:01,1611546730956,NULL,优惠券怎么领,NULL,0),(1611547021004,2021-01-25 11:57:00,1611546730956,1,NULL,HJRTRY,NULL);/*Table structure for table config */DROP TABLE IF EXISTS config;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)
) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8 COMMENT配置文件;/*Data for the table config */insert into config(id,name,value) values (1,picture1,http://localhost:8080/ssm5n2mk/upload/1611546428898.jpg),(2,picture2,http://localhost:8080/ssm5n2mk/upload/1611546438599.jpg),(3,picture3,http://localhost:8080/ssm5n2mk/upload/1611546701884.jpg),(6,homepage,NULL);/*Table structure for table discussxianhuaxinxi */DROP TABLE IF EXISTS discussxianhuaxinxi;CREATE TABLE discussxianhuaxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611547054321 DEFAULT CHARSETutf8 COMMENT鲜花信息评论表;/*Data for the table discussxianhuaxinxi */insert into discussxianhuaxinxi(id,addtime,refid,userid,content,reply) values (121,2021-01-25 11:42:20,1,1,评论内容1,回复内容1),(122,2021-01-25 11:42:20,2,2,评论内容2,回复内容2),(123,2021-01-25 11:42:20,3,3,评论内容3,回复内容3),(124,2021-01-25 11:42:20,4,4,评论内容4,回复内容4),(125,2021-01-25 11:42:20,5,5,评论内容5,回复内容5),(126,2021-01-25 11:42:20,6,6,评论内容6,回复内容6),(1611547054320,2021-01-25 11:57:34,1611546568410,1611546730956,很不错的花,NULL);/*Table structure for table huacaixuanze */DROP TABLE IF EXISTS huacaixuanze;CREATE TABLE huacaixuanze (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,huacaixuanze varchar(200) NOT NULL COMMENT 花材选择,PRIMARY KEY (id),UNIQUE KEY huacaixuanze (huacaixuanze)
) ENGINEInnoDB AUTO_INCREMENT1611546509818 DEFAULT CHARSETutf8 COMMENT花材选择;/*Data for the table huacaixuanze */insert into huacaixuanze(id,addtime,huacaixuanze) values (21,2021-01-25 11:42:19,花材选择1),(22,2021-01-25 11:42:19,花材选择2),(23,2021-01-25 11:42:19,花材选择3),(24,2021-01-25 11:42:19,花材选择4),(26,2021-01-25 11:42:19,蓝色妖姬),(1611546509817,2021-01-25 11:48:28,白玫瑰);/*Table structure for table news */DROP TABLE IF EXISTS news;CREATE TABLE news (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,introduction longtext COMMENT 简介,picture varchar(200) NOT NULL COMMENT 图片,content longtext NOT NULL COMMENT 内容,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546692085 DEFAULT CHARSETutf8 COMMENT鲜花资讯;/*Data for the table news */insert into news(id,addtime,title,introduction,picture,content) values (111,2021-01-25 11:42:19,标题1,简介1,http://localhost:8080/ssm5n2mk/upload/1611546379920.jpg,p内容1/p),(112,2021-01-25 11:42:19,标题2,简介2,http://localhost:8080/ssm5n2mk/upload/1611546390190.jpg,p内容2/p),(113,2021-01-25 11:42:19,标题3,简介3,http://localhost:8080/ssm5n2mk/upload/news_picture3.jpg,内容3),(114,2021-01-25 11:42:19,标题4,简介4,http://localhost:8080/ssm5n2mk/upload/1611546402088.jpg,p内容4/p),(115,2021-01-25 11:42:19,标题5,简介5,http://localhost:8080/ssm5n2mk/upload/1611546418617.jpg,p内容5/p),(116,2021-01-25 11:42:19,标题6,简介6,http://localhost:8080/ssm5n2mk/upload/news_picture6.jpg,内容6),(1611546692084,2021-01-25 11:51:31,优惠资讯,优惠活动,http://localhost:8080/ssm5n2mk/upload/1611546678641.jpg,p活动内容/ppimg src\http://localhost:8080/ssm5n2mk/upload/1611546690489.jpg\/p);/*Table structure for table orders */DROP TABLE IF EXISTS orders;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 xianhuaxinxi 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 地址,PRIMARY KEY (id),UNIQUE KEY orderid (orderid)
) ENGINEInnoDB AUTO_INCREMENT1611546932996 DEFAULT CHARSETutf8 COMMENT订单;/*Data for the table orders */insert into orders(id,addtime,orderid,tablename,userid,goodid,goodname,picture,buynumber,price,discountprice,total,discounttotal,type,status,address) values (1611546932995,2021-01-25 11:55:32,20211251155275163926,xianhuaxinxi,1611546730956,1611546568410,白玫瑰花束,http://localhost:8080/ssm5n2mk/upload/1611546536278.jpg,1,520,520,520,520,1,已完成,广东省梅州市梅县区新城街道丽景湾(嘉应西二巷));/*Table structure for table storeup */DROP TABLE IF EXISTS storeup;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 收藏图片,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546915119 DEFAULT CHARSETutf8 COMMENT收藏表;/*Data for the table storeup */insert into storeup(id,addtime,userid,refid,tablename,name,picture) values (1611546871926,2021-01-25 11:54:31,1611546730956,1611546568410,xianhuaxinxi,白玫瑰花束,http://localhost:8080/ssm5n2mk/upload/1611546536278.jpg),(1611546915118,2021-01-25 11:55:14,1611546730956,36,xianhuaxinxi,鲜花名称6,http://localhost:8080/ssm5n2mk/upload/1611546364108.jpg);/*Table structure for table token */DROP TABLE IF EXISTS token;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)
) ENGINEInnoDB AUTO_INCREMENT3 DEFAULT CHARSETutf8 COMMENTtoken表;/*Data for the table token */insert into token(id,userid,username,tablename,role,token,addtime,expiratedtime) values (1,1,abo,users,管理员,28d1e6lymklwwdglv7r3rgckkormj6c2,2021-01-25 11:44:06,2021-01-25 12:56:13),(2,1611546730956,1,yonghu,用户,ccbp71gdyn9y2unb0yj8338zspj3duqk,2021-01-25 11:52:16,2021-01-25 12:57:10);/*Table structure for table users */DROP TABLE IF EXISTS users;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)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT用户表;/*Data for the table users */insert into users(id,username,password,role,addtime) values (1,abo,aboo,管理员,2021-01-25 11:42:20);/*Table structure for table xianhuachuku */DROP TABLE IF EXISTS xianhuachuku;CREATE TABLE xianhuachuku (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,xianhuamingcheng varchar(200) DEFAULT NULL COMMENT 鲜花名称,huacaixuanze varchar(200) DEFAULT NULL COMMENT 花材选择,shuliang int(11) DEFAULT NULL COMMENT 数量,dengjishijian date DEFAULT NULL COMMENT 登记时间,beizhu varchar(200) DEFAULT NULL COMMENT 备注,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546996676 DEFAULT CHARSETutf8 COMMENT鲜花出库;/*Data for the table xianhuachuku */insert into xianhuachuku(id,addtime,xianhuamingcheng,huacaixuanze,shuliang,dengjishijian,beizhu) values (51,2021-01-25 11:42:19,鲜花名称1,花材选择1,1,2021-01-25,备注1),(52,2021-01-25 11:42:19,鲜花名称2,花材选择2,2,2021-01-25,备注2),(53,2021-01-25 11:42:19,鲜花名称3,花材选择3,3,2021-01-25,备注3),(54,2021-01-25 11:42:19,鲜花名称4,花材选择4,4,2021-01-25,备注4),(55,2021-01-25 11:42:19,鲜花名称5,花材选择5,5,2021-01-25,备注5),(56,2021-01-25 11:42:19,鲜花名称6,花材选择6,6,2021-01-25,备注6),(1611546590764,2021-01-25 11:49:50,白玫瑰花束,白玫瑰,2,2021-01-25,销售出库gfr),(1611546996675,2021-01-25 11:56:36,白玫瑰花束,白玫瑰,1,2021-01-30,);/*Table structure for table xianhuaruku */DROP TABLE IF EXISTS xianhuaruku;CREATE TABLE xianhuaruku (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,xianhuamingcheng varchar(200) DEFAULT NULL COMMENT 鲜花名称,huacaixuanze varchar(200) DEFAULT NULL COMMENT 花材选择,shuliang int(11) DEFAULT NULL COMMENT 数量,dengjishijian date DEFAULT NULL COMMENT 登记时间,beizhu varchar(200) DEFAULT NULL COMMENT 备注,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546579672 DEFAULT CHARSETutf8 COMMENT鲜花入库;/*Data for the table xianhuaruku */insert into xianhuaruku(id,addtime,xianhuamingcheng,huacaixuanze,shuliang,dengjishijian,beizhu) values (41,2021-01-25 11:42:19,鲜花名称1,花材选择1,1,2021-01-25,备注1),(42,2021-01-25 11:42:19,鲜花名称2,花材选择2,2,2021-01-25,备注2),(43,2021-01-25 11:42:19,鲜花名称3,花材选择3,3,2021-01-25,备注3),(44,2021-01-25 11:42:19,鲜花名称4,花材选择4,4,2021-01-25,备注4),(45,2021-01-25 11:42:19,鲜花名称5,花材选择5,5,2021-01-25,备注5),(46,2021-01-25 11:42:19,鲜花名称6,花材选择6,6,2021-01-25,备注6),(1611546579671,2021-01-25 11:49:38,白玫瑰花束,白玫瑰,50,2021-01-25,);/*Table structure for table xianhuaxinxi */DROP TABLE IF EXISTS xianhuaxinxi;CREATE TABLE xianhuaxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,xianhuamingcheng varchar(200) NOT NULL COMMENT 鲜花名称,huacaixuanze varchar(200) NOT NULL COMMENT 花材选择,tupian varchar(200) DEFAULT NULL COMMENT 图片,cailiao varchar(200) DEFAULT NULL COMMENT 材料,huayu varchar(200) DEFAULT NULL COMMENT 花语,xianhuayongtu varchar(200) DEFAULT NULL COMMENT 鲜花用途,zengsongduixiang varchar(200) DEFAULT NULL COMMENT 赠送对象,shuliang int(11) DEFAULT NULL COMMENT 数量,xianhuaxiangqing longtext COMMENT 鲜花详情,clicktime datetime DEFAULT NULL COMMENT 最近点击时间,clicknum int(11) DEFAULT 0 COMMENT 点击次数,price float NOT NULL COMMENT 价格,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT1611546568411 DEFAULT CHARSETutf8 COMMENT鲜花信息;/*Data for the table xianhuaxinxi */insert into xianhuaxinxi(id,addtime,xianhuamingcheng,huacaixuanze,tupian,cailiao,huayu,xianhuayongtu,zengsongduixiang,shuliang,xianhuaxiangqing,clicktime,clicknum,price) values (31,2021-01-25 11:42:19,鲜花名称1,花材选择1,http://localhost:8080/ssm5n2mk/upload/xianhuaxinxi_tupian1.jpg,材料1,花语1,爱情,恋人,1,鲜花详情1,2021-01-25 11:44:11,2,99.9),(32,2021-01-25 11:42:19,鲜花名称2,花材选择2,http://localhost:8080/ssm5n2mk/upload/1611546319379.jpg,材料2,花语2,爱情,恋人,2,p鲜花详情2/p,2021-01-25 11:47:40,4,99.9),(33,2021-01-25 11:42:19,鲜花名称3,花材选择3,http://localhost:8080/ssm5n2mk/upload/1611546329249.jpg,材料3,花语3,爱情,恋人,3,p鲜花详情3/p,2021-01-25 11:45:23,4,99.9),(34,2021-01-25 11:42:19,鲜花名称4,花材选择4,http://localhost:8080/ssm5n2mk/upload/1611546340405.jpg,材料4,花语4,爱情,恋人,4,p鲜花详情4/p,2021-01-25 11:45:34,5,99.9),(35,2021-01-25 11:42:19,鲜花名称5,花材选择5,http://localhost:8080/ssm5n2mk/upload/1611546351657.jpg,材料5,花语5,爱情,恋人,5,p鲜花详情5/p,2021-01-25 11:53:47,10,99.9),(36,2021-01-25 11:42:19,鲜花名称6,花材选择6,http://localhost:8080/ssm5n2mk/upload/1611546364108.jpg,材料6,花语6,爱情,恋人,6,p鲜花详情6/p,2021-01-25 11:55:13,9,99.9),(1611546568410,2021-01-25 11:49:28,白玫瑰花束,白玫瑰,http://localhost:8080/ssm5n2mk/upload/1611546536278.jpg,白玫瑰33支尤加利点缀,相恋一生,爱情,恋人,147,p鲜花详情/ppimg src\http://localhost:8080/ssm5n2mk/upload/1611546566625.jpg\/p,2021-01-25 13:14:48,6,520);/*Table structure for table yonghu */DROP TABLE IF EXISTS yonghu;CREATE TABLE yonghu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,yonghuming varchar(200) NOT NULL COMMENT 用户名,mima varchar(200) NOT NULL COMMENT 密码,xingming varchar(200) DEFAULT NULL COMMENT 姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,touxiang varchar(200) DEFAULT NULL COMMENT 头像,lianxidianhua varchar(200) DEFAULT NULL COMMENT 联系电话,dizhi varchar(200) DEFAULT NULL COMMENT 地址,money float DEFAULT 0 COMMENT 余额,PRIMARY KEY (id),UNIQUE KEY yonghuming (yonghuming)
) ENGINEInnoDB AUTO_INCREMENT1611546730957 DEFAULT CHARSETutf8 COMMENT用户;/*Data for the table yonghu */insert into yonghu(id,addtime,yonghuming,mima,xingming,xingbie,touxiang,lianxidianhua,dizhi,money) values (11,2021-01-25 11:42:19,用户1,123456,姓名1,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang1.jpg,13823888881,地址1,100),(12,2021-01-25 11:42:19,用户2,123456,姓名2,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang2.jpg,13823888882,地址2,100),(13,2021-01-25 11:42:19,用户3,123456,姓名3,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang3.jpg,13823888883,地址3,100),(14,2021-01-25 11:42:19,用户4,123456,姓名4,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang4.jpg,13823888884,地址4,100),(15,2021-01-25 11:42:19,用户5,123456,姓名5,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang5.jpg,13823888885,地址5,100),(16,2021-01-25 11:42:19,用户6,123456,姓名6,男,http://localhost:8080/ssm5n2mk/upload/yonghu_touxiang6.jpg,13823888886,地址6,100),(1611546730956,2021-01-25 11:52:10,1,1,陈一,男,http://localhost:8080/ssm5n2mk/upload/1611546753317.jpg,12312312312,HJFHDJTFYG,1480);/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;
