/*
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,
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
基于JSP的游戏账号交易系统源码.zip (2000个子文件)
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
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
YingxionglianmenggoumaiEntity.class 7KB
MPUtil.class 7KB
YouxizhanghaohuanbangEntity.class 6KB
DixiachengzhanghaogoumaiEntity.class 6KB
DixiachengzhanghaohuanbangEntity.class 6KB
UserController.class 6KB
YouxizhanghaoshensuEntity.class 6KB
DixiachengzhanghaoshensuEntity.class 5KB
MaijiaEntity.class 5KB
YonghuEntity.class 5KB
TokenServiceImpl.class 4KB
FileController.class 4KB
DixiachengsixinliaotianEntity.class 4KB
YingxionglianmengsixinEntity.class 4KB
BaiduUtil.class 4KB
DiscussdixiachengyuyongshiServiceImpl.class 4KB
DixiachengzhanghaohuanbangServiceImpl.class 4KB
YingxionglianmenghuanbangServiceImpl.class 4KB
DiscussyingxionglianmengServiceImpl.class 4KB
DixiachengzhanghaogoumaiServiceImpl.class 4KB
DixiachengzhanghaoshensuServiceImpl.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
YouxizhanghaoshensuServiceImpl.class 4KB
DixiachengyuyongshiServiceImpl.class 4KB
ZhanghaojiaoyijiluServiceImpl.class 4KB
SixinliaotianhuifuServiceImpl.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
ConfigController.class 4KB
ChatServiceImpl.class 4KB
NewsServiceImpl.class 4KB
SixinliaotianhuifuEntity.class 4KB
YingxionglianmenghuifuEntity.class 3KB
DixiachengsixinhuifuEntity.class 3KB
Query.class 3KB
DiscussdixiachengyuyongshiEntity.class 3KB
DiscussyingxionglianmengEntity.class 3KB
DiscussyouxizhanghaoEntity.class 3KB
UserServiceImpl.class 3KB
PageUtils.class 3KB
CommonServiceImpl.class 2KB
DiscussdixiachengyuyongshiService.class 2KB
DixiachengzhanghaohuanbangService.class 2KB
YingxionglianmenghuanbangService.class 2KB
DixiachengzhanghaohuanbangDao.class 2KB
DiscussdixiachengyuyongshiDao.class 2KB
DixiachengzhanghaoshensuService.class 2KB
DixiachengzhanghaogoumaiService.class 2KB
DiscussyingxionglianmengService.class 2KB
YingxionglianmenghuanbangDao.class 2KB
R.class 2KB
YingxionglianmenggoumaiService.class 2KB
YingxionglianmengshensuService.class 2KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
入伍击寇
- 粉丝: 129
- 资源: 4706
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功