开发语言:Java
框架:springboot
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql 5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
主要功能:登录和注册有两种权限商家以及消费者,
商家功能,管理订单,将外出工作的工作人员设置外出(司仪,摄影团队,车队),其他服务如果已经使用则设置为使用中(礼服,影楼,婚庆场地),以及使用实时通讯,与客户交流。设置时间安排提醒通过邮件发送给消费者。
消费者层面,注册,登录。选择服务(司仪,婚车,场地,影楼,礼服,摄影团队),下订单,实时与商家联系。
网站首页要有前端展示,展示一些婚庆的视频,图片
设置服务的价格时要有低价格,普通价格,以及高价格
前端
后端
数据库表设计
CREATE TABLE chat
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
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
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669907600 DEFAULT CHARSET=utf8 COMMENT=‘客服聊天表’;
CREATE TABLE config
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
name
varchar(100) NOT NULL COMMENT ‘配置参数名称’,
value
varchar(100) DEFAULT NULL COMMENT ‘配置参数值’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT=‘配置文件’;
CREATE TABLE dingdanxinxi
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
sheyingzhuti
varchar(200) NOT NULL COMMENT ‘摄影主题’,
tuanduibianhao
varchar(200) DEFAULT NULL COMMENT ‘团队编号’,
tuanduimingcheng
varchar(200) DEFAULT NULL COMMENT ‘团队名称’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
siyi
varchar(200) DEFAULT NULL COMMENT ‘司仪’,
chedui
varchar(200) DEFAULT NULL COMMENT ‘车队’,
yuepaijiage
varchar(200) DEFAULT NULL COMMENT ‘约拍价格’,
lifumingcheng
varchar(200) DEFAULT NULL COMMENT ‘礼服名称’,
lifujiage
varchar(200) DEFAULT NULL COMMENT ‘礼服价格’,
zongjiage
varchar(200) DEFAULT NULL COMMENT ‘总价格’,
xiadanriqi
date DEFAULT NULL COMMENT ‘下单日期’,
yuyueshijian
date DEFAULT NULL COMMENT ‘预约时间’,
paishedizhi
varchar(200) NOT NULL COMMENT ‘拍摄地址’,
yonghuming
varchar(200) DEFAULT NULL COMMENT ‘用户名’,
xingming
varchar(200) DEFAULT NULL COMMENT ‘姓名’,
shouji
varchar(200) DEFAULT NULL COMMENT ‘手机’,
sfsh
varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
shhf
longtext COMMENT ‘审核回复’,
ispay
varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669852795 DEFAULT CHARSET=utf8 COMMENT=‘订单信息’;
CREATE TABLE lifuleixing
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
leixing
varchar(200) NOT NULL COMMENT ‘类型’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669557861 DEFAULT CHARSET=utf8 COMMENT=‘礼服类型’;
CREATE TABLE lifuxinxi
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
lifubianhao
varchar(200) DEFAULT NULL COMMENT ‘礼服编号’,
lifumingcheng
varchar(200) DEFAULT NULL COMMENT ‘礼服名称’,
leixing
varchar(200) DEFAULT NULL COMMENT ‘类型’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
caizhi
varchar(200) DEFAULT NULL COMMENT ‘材质’,
jieshao
longtext COMMENT ‘介绍’,
lifujiage
int(11) NOT NULL COMMENT ‘礼服价格’,
beizhu
varchar(200) DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id
),
UNIQUE KEY lifubianhao
(lifubianhao
)
) ENGINE=InnoDB AUTO_INCREMENT=1600668453283 DEFAULT CHARSET=utf8 COMMENT=‘礼服信息’;
CREATE TABLE news
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
title
varchar(200) NOT NULL COMMENT ‘标题’,
picture
varchar(200) NOT NULL COMMENT ‘图片’,
content
longtext NOT NULL COMMENT ‘内容’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669253948 DEFAULT CHARSET=utf8 COMMENT=‘新闻资讯’;
CREATE TABLE sheyingtuandui
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
tuanduibianhao
varchar(200) DEFAULT NULL COMMENT ‘团队编号’,
tuanduimingcheng
varchar(200) NOT NULL COMMENT ‘团队名称’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
siyi
varchar(200) DEFAULT NULL COMMENT ‘司仪’,
chedui
varchar(200) DEFAULT NULL COMMENT ‘车队’,
lianxiren
varchar(200) DEFAULT NULL COMMENT ‘联系人’,
lianxidianhua
varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
tuanduizhuangtai
varchar(200) DEFAULT NULL COMMENT ‘团队状态’,
tuanduidengji
varchar(200) DEFAULT NULL COMMENT ‘团队等级’,
tuanduitese
varchar(200) DEFAULT NULL COMMENT ‘团队特色’,
yuepaijiage
int(11) NOT NULL COMMENT ‘约拍价格’,
tuanduijieshao
longtext COMMENT ‘团队介绍’,
PRIMARY KEY (id
),
UNIQUE KEY tuanduibianhao
(tuanduibianhao
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669379709 DEFAULT CHARSET=utf8 COMMENT=‘摄影团队’;
CREATE TABLE storeup
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
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
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669826253 DEFAULT CHARSET=utf8 COMMENT=‘收藏表’;
CREATE TABLE token
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
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 ‘0000-00-00 00:00:00’ COMMENT ‘过期时间’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=‘token表’;
CREATE TABLE users
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
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=‘用户表’;
CREATE TABLE xinxi
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
sheyingzhuti
varchar(200) DEFAULT NULL COMMENT ‘摄影主题’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
zongjiage
varchar(200) DEFAULT NULL COMMENT ‘总价格’,
yuyueshijian
varchar(200) DEFAULT NULL COMMENT ‘预约时间’,
yonghuming
varchar(200) DEFAULT NULL COMMENT ‘用户名’,
xingming
varchar(200) DEFAULT NULL COMMENT ‘姓名’,
shouji
varchar(200) DEFAULT NULL COMMENT ‘手机’,
tixingneirong
longtext NOT NULL COMMENT ‘提醒内容’,
beizhu
varchar(200) DEFAULT NULL COMMENT ‘备注’,
tixingshijian
date DEFAULT NULL COMMENT ‘提醒时间’,
sfsh
varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
shhf
longtext COMMENT ‘审核回复’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1600669786421 DEFAULT CHARSET=utf8 COMMENT=‘信息’;
CREATE TABLE yangpinzhanshi
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
chengpinbianhao
varchar(200) DEFAULT NULL COMMENT ‘成品编号’,
mingcheng
varchar(200) DEFAULT NULL COMMENT ‘名称’,
leixing
varchar(200) DEFAULT NULL COMMENT ‘类型’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
shipinxuanchuan
varchar(200) DEFAULT NULL COMMENT ‘视频宣传’,
neirongxiangqing
longtext COMMENT ‘内容详情’,
PRIMARY KEY (id
),
UNIQUE KEY chengpinbianhao
(chengpinbianhao
)
) ENGINE=InnoDB AUTO_INCREMENT=1600668770101 DEFAULT CHARSET=utf8 COMMENT=‘样品展示’;
DROP TABLE IF EXISTS yinglouxinxi
;
CREATE TABLE yinglouxinxi
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
yingloubianhao
varchar(200) DEFAULT NULL COMMENT ‘影楼编号’,
yingloumingcheng
varchar(200) DEFAULT NULL COMMENT ‘影楼名称’,
tupian
varchar(200) DEFAULT NULL COMMENT ‘图片’,
lianxiren
varchar(200) DEFAULT NULL COMMENT ‘联系人’,
lianxidianhua
varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
dizhi
varchar(200) DEFAULT NULL COMMENT ‘地址’,
yingloujieshao
longtext COMMENT ‘影楼介绍’,
PRIMARY KEY (id
),
UNIQUE KEY yingloubianhao
(yingloubianhao
)
) ENGINE=InnoDB AUTO_INCREMENT=1600668526603 DEFAULT CHARSET=utf8 COMMENT=‘影楼信息’;
CREATE TABLE yonghu
(
id
bigint(20) NOT NULL AUTO_INCREMENT,
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
yonghuming
varchar(200) NOT NULL COMMENT ‘用户名’,
mima
varchar(200) NOT NULL COMMENT ‘密码’,
xingming
varchar(200) NOT NULL COMMENT ‘姓名’,
xingbie
varchar(200) DEFAULT NULL COMMENT ‘性别’,
touxiang
varchar(200) DEFAULT NULL COMMENT ‘头像’,
shouji
varchar(200) DEFAULT NULL COMMENT ‘手机’,
PRIMARY KEY (id
),
UNIQUE KEY yonghuming
(yonghuming
)
) ENGINE=InnoDB AUTO_INCREMENT=1600668360728 DEFAULT CHARSET=utf8 COMMENT=‘用户’;