(基于mysql的Java毕业设计)游戏账号交易系统(源码+演示视频)

/* 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` (