/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50553
Source Host : localhost:3306
Source Schema : jspjzzlc
Target Server Type : MySQL
Target Server Version : 50553
File Encoding : 65001
Date: 21/10/2020 11:24:37
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for 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) NULL DEFAULT NULL COMMENT '管理员id',
`ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复',
`isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1603250489063 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服聊天表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (1, '2020-10-21 08:54:27', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (2, '2020-10-21 08:54:28', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (3, '2020-10-21 08:54:28', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (1603250020351, '2020-10-21 11:13:39', 1603244734231, NULL, '客服功能忘记演示了 不好意思\r\n', '嘿嘿\r\n', 0);
INSERT INTO `chat` VALUES (1603250489062, '2020-10-21 11:21:28', 1603244734231, NULL, '嘿嘿', NULL, 1);
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
`value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (7, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244320863.jpg');
INSERT INTO `config` VALUES (8, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244337794.jpg');
INSERT INTO `config` VALUES (9, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244351559.jpg');
INSERT INTO `config` VALUES (10, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603250401188.jpg');
-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1603249564409 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地下城与勇士评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussdixiachengyuyongshi
-- ----------------------------
INSERT INTO `discussdixiachengyuyongshi` VALUES (1, '2020-10-21 08:54:28', 1, '评论内容1', 1);
INSERT INTO `discussdixiachengyuyongshi` VALUES (2, '2020-10-21 08:54:28', 2, '评论内容2', 2);
INSERT INTO `discussdixiachengyuyongshi` VALUES (3, '2020-10-21 08:54:28', 3, '评论内容3', 3);
INSERT INTO `discussdixiachengyuyongshi` VALUES (1603249564408, '2020-10-21 11:06:04', 1603244913224, '这个账号很棒啊', 1603244734231);
-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '英雄联盟评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussyingxionglianmeng
-- ----------------------------
INSERT INTO `discussyingxionglianmeng` VALUES (1, '2020-10-21 08:54:28', 1, '评论内容1', 1);
INSERT INTO `discussyingxionglianmeng` VALUES (2, '2020-10-21 08:54:28', 2, '评论内容2', 2);
INSERT INTO `discussyingxionglianmeng` VALUES (3, '2020-10-21 08:54:28', 3, '评论内容3', 3);
-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`userid` bigint(20) NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '游戏账号评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of discussyouxizhanghao
-- ----------------------------
INSERT INTO `discussyouxizhanghao` VALUES (1, '2020-10-21 08:54:29', 1, '评论内容1', 1);
INSERT INTO `discussyouxizhanghao` VALUES (2, '2020-10-21 08:54:29', 2, '评论内容2', 2);
INSERT INTO `discussyouxizhanghao` VALUES (3, '2020-10-21 08:54:29', 3, '评论内容3', 3);
-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编号',
`maijiazhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '卖家账号',
`maijiahuifu` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '卖家回复',
`yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`yonghuhuifu` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用户回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1603249917931 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地下城私信回复' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of dixiachengsixinhuifu
-- ----------------------------
INSERT INTO `dixiachengsixinhuifu` VALUES (1603249255265, '2020-10-21 11:00:55', '1603244813', '01', '好的', '001', '');
INSERT INTO `dixiachengsixinhuifu` VALUES (1603249917930, '2020-10-21 11:11:57', '1603244813', '01', '爪巴', '001', '');
-- ----------------------------
-- Table structure for dixiachengsixinliaotian
-- ----------------------------
DROP TABLE IF EXISTS `dixiachengsixinliaotian`;
CREATE TABLE `dixiachengsixinliaotian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
基于mysql的java毕业设计-游戏账号交易系统(源码+演示视频)
版权申诉
110 浏览量
2023-05-18
22:44:31
上传
评论 1
收藏 101.77MB ZIP 举报
基于mysql的java毕业设计-游戏账号交易系统(源码+演示视频) （2106个子文件） 
MaijiaController.class 10KB YonghuController.class 10KB CommonController.class 10KB ForumController.class 9KB DixiachengyuyongshiController.class 9KB YingxionglianmengController.class 9KB ChatController.class 9KB YouxizhanghaoController.class 9KB DixiachengzhanghaohuanbangController.class 8KB YingxionglianmenghuanbangController.class 8KB DixiachengzhanghaogoumaiController.class 8KB DixiachengsixinliaotianController.class 8KB YingxionglianmenggoumaiController.class 8KB YingxionglianmenghuifuController.class 8KB YingxionglianmengsixinController.class 8KB YouxizhanghaohuanbangController.class 8KB DixiachengsixinhuifuController.class 8KB ZhanghaojiaoyijiluController.class 8KB SixinliaotianhuifuController.class 8KB SixinliaotianjiluController.class 8KB DixiachengzhanghaoshensuController.class 8KB YingxionglianmengshensuController.class 8KB YingxionglianmengEntity.class 8KB YouxizhanghaoshensuController.class 8KB DiscussdixiachengyuyongshiController.class 8KB StoreupController.class 8KB MessagesController.class 8KB DiscussyingxionglianmengController.class 8KB DiscussyouxizhanghaoController.class 8KB ShouxufeiyongController.class 8KB YouxileibieController.class 8KB NewsController.class 7KB DixiachengyuyongshiEntity.class 7KB YouxizhanghaoEntity.class 7KB YingxionglianmenggoumaiEntity.class 7KB MPUtil.class 7KB YingxionglianmenghuanbangEntity.class 7KB YouxizhanghaohuanbangEntity.class 6KB DixiachengzhanghaogoumaiEntity.class 6KB DixiachengzhanghaohuanbangEntity.class 6KB UserController.class 6KB ZhanghaojiaoyijiluEntity.class 6KB YouxizhanghaoshensuEntity.class 6KB YingxionglianmengModel.class 6KB YingxionglianmengVO.class 6KB DixiachengzhanghaoshensuEntity.class 5KB YingxionglianmengshensuEntity.class 5KB MaijiaEntity.class 5KB DixiachengyuyongshiModel.class 5KB DixiachengyuyongshiVO.class 5KB YonghuEntity.class 5KB YouxizhanghaoModel.class 5KB YouxizhanghaoVO.class 5KB SixinliaotianjiluEntity.class 5KB YingxionglianmenggoumaiModel.class 5KB YingxionglianmenggoumaiVO.class 5KB TokenServiceImpl.class 4KB FileController.class 4KB DixiachengsixinliaotianEntity.class 4KB YingxionglianmengsixinEntity.class 4KB YingxionglianmenghuanbangModel.class 4KB YingxionglianmenghuanbangVO.class 4KB YouxizhanghaohuanbangModel.class 4KB YouxizhanghaohuanbangVO.class 4KB DixiachengzhanghaogoumaiModel.class 4KB DixiachengzhanghaogoumaiVO.class 4KB BaiduUtil.class 4KB DiscussdixiachengyuyongshiServiceImpl.class 4KB DixiachengzhanghaohuanbangServiceImpl.class 4KB YingxionglianmenghuanbangServiceImpl.class 4KB DixiachengzhanghaohuanbangModel.class 4KB DiscussyingxionglianmengServiceImpl.class 4KB DixiachengzhanghaogoumaiServiceImpl.class 4KB DixiachengzhanghaoshensuServiceImpl.class 4KB DixiachengzhanghaohuanbangVO.class 4KB YingxionglianmenggoumaiServiceImpl.class 4KB YingxionglianmengshensuServiceImpl.class 4KB DixiachengsixinliaotianServiceImpl.class 4KB YingxionglianmengsixinServiceImpl.class 4KB YingxionglianmenghuifuServiceImpl.class 4KB YouxizhanghaohuanbangServiceImpl.class 4KB DiscussyouxizhanghaoServiceImpl.class 4KB DixiachengsixinhuifuServiceImpl.class 4KB ForumEntity.class 4KB YouxizhanghaoshensuServiceImpl.class 4KB DixiachengyuyongshiServiceImpl.class 4KB ZhanghaojiaoyijiluServiceImpl.class 4KB SixinliaotianhuifuServiceImpl.class 4KB ZhanghaojiaoyijiluModel.class 4KB ZhanghaojiaoyijiluVO.class 4KB YingxionglianmengServiceImpl.class 4KB SixinliaotianjiluServiceImpl.class 4KB YouxizhanghaoServiceImpl.class 4KB ShouxufeiyongServiceImpl.class 4KB YouxileibieServiceImpl.class 4KB MessagesServiceImpl.class 4KB StoreupServiceImpl.class 4KB MaijiaServiceImpl.class 4KB YonghuServiceImpl.class 4KB ForumServiceImpl.class 4KB共 2106 条
- 1
- 2
- 3
- 4
- 5
- 6
- 22
资源评论
