/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 5.7.28-log : Database - jspjzzlc
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jspjzzlc` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `jspjzzlc`;
/*Table structure for table `chat` */
DROP TABLE IF EXISTS `chat`;
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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1603250489063 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='客服聊天表';
/*Data for the table `chat` */
insert into `chat`(`id`,`addtime`,`userid`,`adminid`,`ask`,`reply`,`isreply`) values
(1,'2022-03-22 08:54:27',1,1,'提问1','回复1',1),
(2,'2022-03-22 08:54:27',2,2,'提问2','回复2',2),
(3,'2022-03-22 08:54:27',3,3,'提问3','回复3',3),
(1603250020351,'2022-03-22 08:54:27',1603244734231,NULL,'客服功能忘记演示了 不好意思\r\n','嘿嘿\r\n',0),
(1603250489062,'2022-03-22 08:54:27',1603244734231,NULL,'嘿嘿',NULL,1);
/*Table structure for table `config` */
DROP TABLE IF EXISTS `config`;
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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='配置文件';
/*Data for the table `config` */
insert into `config`(`id`,`name`,`value`) values
(7,'首页轮播图','http://localhost:8080/jspjZZlC/upload/1603244320863.jpg'),
(8,'首页轮播图','http://localhost:8080/jspjZZlC/upload/1603244337794.jpg'),
(9,'首页轮播图','http://localhost:8080/jspjZZlC/upload/1603244351559.jpg'),
(10,'首页轮播图','http://localhost:8080/jspjZZlC/upload/1603250401188.jpg');
/*Table structure for table `discussdixiachengyuyongshi` */
DROP TABLE IF EXISTS `discussdixiachengyuyongshi`;
CREATE TABLE `discussdixiachengyuyongshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1603249564409 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='地下城与勇士评论表';
/*Data for the table `discussdixiachengyuyongshi` */
insert into `discussdixiachengyuyongshi`(`id`,`addtime`,`refid`,`content`,`userid`) values
(1,'2022-03-22 08:54:27',1,'评论内容1',1),
(2,'2022-03-22 08:54:27',2,'评论内容2',2),
(3,'2022-03-22 08:54:27',3,'评论内容3',3),
(1603249564408,'2022-03-22 08:54:27',1603244913224,'这个账号很棒啊',1603244734231);
/*Table structure for table `discussyingxionglianmeng` */
DROP TABLE IF EXISTS `discussyingxionglianmeng`;
CREATE TABLE `discussyingxionglianmeng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='英雄联盟评论表';
/*Data for the table `discussyingxionglianmeng` */
insert into `discussyingxionglianmeng`(`id`,`addtime`,`refid`,`content`,`userid`) values
(1,'2022-03-22 08:54:27',1,'评论内容1',1),
(2,'2022-03-22 08:54:27',2,'评论内容2',2),
(3,'2022-03-22 08:54:27',3,'评论内容3',3);
/*Table structure for table `discussyouxizhanghao` */
DROP TABLE IF EXISTS `discussyouxizhanghao`;
CREATE TABLE `discussyouxizhanghao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`content` varchar(200) NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='游戏账号评论表';
/*Data for the table `discussyouxizhanghao` */
insert into `discussyouxizhanghao`(`id`,`addtime`,`refid`,`content`,`userid`) values
(1,'2022-03-22 08:54:27',1,'评论内容1',1),
(2,'2022-03-22 08:54:27',2,'评论内容2',2),
(3,'2022-03-22 08:54:27',3,'评论内容3',3);
/*Table structure for table `dixiachengsixinhuifu` */
DROP TABLE IF EXISTS `dixiachengsixinhuifu`;
CREATE TABLE `dixiachengsixinhuifu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`maijiahuifu` longtext COMMENT '卖家回复',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`yonghuhuifu` longtext COMMENT '用户回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1603249917931 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='地下城私信回复';
/*Data for the table `dixiachengsixinhuifu` */
insert into `dixiachengsixinhuifu`(`id`,`addtime`,`shangpinbianhao`,`maijiazhanghao`,`maijiahuifu`,`yonghuming`,`yonghuhuifu`) values
(1603249255265,'2022-03-22 08:54:27','1603244813','01','好的','001',''),
(1603249917930,'2022-03-22 08:54:27','1603244813','01','爪巴','001','');
/*Table structure for table `dixiachengsixinliaotian` */
DROP TABLE IF EXISTS `dixiachengsixinliaotian`;
CREATE TABLE `dixiachengsixinliaotian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`maijiaxingming` varchar(200) DEFAULT NULL COMMENT '卖家姓名',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`zhanghaobiaoti` varchar(200) DEFAULT NULL COMMENT '账号标题',
`zhanghaojiage` varchar(200) DEFAULT NULL COMMENT '账号价格',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`sixinneirong` longtext COMMENT '私信内容',
`sixinshijian` datetime DEFAULT NULL COMMENT '私信时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1603249548685 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='地下城私信聊天';
/*Data for the table `dixiachengsixinliaotian` */
insert into `dixiachengsixinliaotian`(`id`,`addtime`,`maijiazhanghao`,`maijiaxingming`,`shangpinbianhao`,`zhanghaobiaoti`,`zhanghaojiage`,`yonghuming`,`xingming`,`sixinneirong`,`sixinshijian`) values
(1603248980964,'2022-03-22 08:54:27','01','张三','1603244813','三个完美细节双至尊版本一线C','1500','001','张三','在吗','2022-03-22 08:54:27'),
(1603249548684,'2022-03-22 08:54:27','01','张三','1603244813','三个完美细节双至尊版本一线C','1500','001','张三','我想买你的号能便宜点吗','2022-03-22 08:54:27');
/*Table structure for table `dixiachengyuyongshi` */
DROP TABLE IF EXISTS `dixiachengyuyongshi`;
CREATE TABLE `dixiachengyuyongshi` (
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
JSP+SSM项目-游戏售卖网站的Java毕业设计(源码+说明+演示视频+数据库).rar 【项目技术】 开发语言:Java 框架:ssm 架构:B/S 数据库:mysql 【实现功能】 管理员;首页、个人中心、游戏分类管理、游戏信息管理、游戏攻略管理、游戏补丁管理、用户管理、订单信息管理、我的收藏管理、系统管理, 用户前台;首页、游戏信息、游戏攻略、游戏补丁、新闻资讯、我的、转跳到后台、客服, 用户后台;首页、个人中心、订单信息管理、我的收藏管理等。
资源推荐
资源详情
资源评论
收起资源包目录
JSP+SSM项目-游戏售卖网站的Java毕业设计(源码+说明+演示视频+数据库).rar (2000个子文件)
MaijiaController.class 10KB
MaijiaController.class 10KB
YonghuController.class 10KB
YonghuController.class 10KB
CommonController.class 10KB
CommonController.class 10KB
ForumController.class 9KB
ForumController.class 9KB
DixiachengyuyongshiController.class 9KB
DixiachengyuyongshiController.class 9KB
YingxionglianmengController.class 9KB
YingxionglianmengController.class 9KB
ChatController.class 9KB
ChatController.class 9KB
YouxizhanghaoController.class 9KB
YouxizhanghaoController.class 9KB
DixiachengzhanghaohuanbangController.class 8KB
DixiachengzhanghaohuanbangController.class 8KB
YingxionglianmenghuanbangController.class 8KB
YingxionglianmenghuanbangController.class 8KB
DixiachengzhanghaogoumaiController.class 8KB
DixiachengzhanghaogoumaiController.class 8KB
DixiachengsixinliaotianController.class 8KB
DixiachengsixinliaotianController.class 8KB
YingxionglianmenggoumaiController.class 8KB
YingxionglianmenggoumaiController.class 8KB
YingxionglianmenghuifuController.class 8KB
YingxionglianmengsixinController.class 8KB
YingxionglianmenghuifuController.class 8KB
YingxionglianmengsixinController.class 8KB
YouxizhanghaohuanbangController.class 8KB
YouxizhanghaohuanbangController.class 8KB
DixiachengsixinhuifuController.class 8KB
DixiachengsixinhuifuController.class 8KB
SixinliaotianhuifuController.class 8KB
ZhanghaojiaoyijiluController.class 8KB
ZhanghaojiaoyijiluController.class 8KB
SixinliaotianhuifuController.class 8KB
SixinliaotianjiluController.class 8KB
SixinliaotianjiluController.class 8KB
DixiachengzhanghaoshensuController.class 8KB
DixiachengzhanghaoshensuController.class 8KB
YingxionglianmengshensuController.class 8KB
YingxionglianmengshensuController.class 8KB
YingxionglianmengEntity.class 8KB
YingxionglianmengEntity.class 8KB
YouxizhanghaoshensuController.class 8KB
YouxizhanghaoshensuController.class 8KB
DiscussdixiachengyuyongshiController.class 8KB
DiscussdixiachengyuyongshiController.class 8KB
StoreupController.class 8KB
StoreupController.class 8KB
MessagesController.class 8KB
MessagesController.class 8KB
DiscussyingxionglianmengController.class 8KB
DiscussyingxionglianmengController.class 8KB
DiscussyouxizhanghaoController.class 8KB
DiscussyouxizhanghaoController.class 8KB
ShouxufeiyongController.class 8KB
ShouxufeiyongController.class 8KB
YouxileibieController.class 8KB
YouxileibieController.class 8KB
DixiachengyuyongshiEntity.class 7KB
DixiachengyuyongshiEntity.class 7KB
NewsController.class 7KB
NewsController.class 7KB
YouxizhanghaoEntity.class 7KB
YouxizhanghaoEntity.class 7KB
YingxionglianmenggoumaiEntity.class 7KB
YingxionglianmenggoumaiEntity.class 7KB
MPUtil.class 7KB
MPUtil.class 7KB
YingxionglianmenghuanbangEntity.class 7KB
YingxionglianmenghuanbangEntity.class 7KB
YouxizhanghaohuanbangEntity.class 6KB
YouxizhanghaohuanbangEntity.class 6KB
DixiachengzhanghaogoumaiEntity.class 6KB
DixiachengzhanghaogoumaiEntity.class 6KB
DixiachengzhanghaohuanbangEntity.class 6KB
DixiachengzhanghaohuanbangEntity.class 6KB
UserController.class 6KB
UserController.class 6KB
ZhanghaojiaoyijiluEntity.class 6KB
ZhanghaojiaoyijiluEntity.class 6KB
YouxizhanghaoshensuEntity.class 6KB
YouxizhanghaoshensuEntity.class 6KB
YingxionglianmengModel.class 6KB
YingxionglianmengModel.class 6KB
YingxionglianmengVO.class 6KB
YingxionglianmengVO.class 6KB
DixiachengzhanghaoshensuEntity.class 5KB
DixiachengzhanghaoshensuEntity.class 5KB
YingxionglianmengshensuEntity.class 5KB
YingxionglianmengshensuEntity.class 5KB
MaijiaEntity.class 5KB
MaijiaEntity.class 5KB
DixiachengyuyongshiModel.class 5KB
DixiachengyuyongshiModel.class 5KB
DixiachengyuyongshiVO.class 5KB
DixiachengyuyongshiVO.class 5KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
岛上程序猿
- 粉丝: 2305
- 资源: 4154
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功