DROP DATABASE IF EXISTS jspjZZlC;
CREATE DATABASE jspjZZlC default character set utf8mb4 collate utf8mb4_general_ci;
USE jspjZZlC;
DROP TABLE IF EXISTS `maijia`;
CREATE TABLE `maijia` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`maijiazhanghao` varchar(200) UNIQUE COMMENT '卖家账号',
`mima` varchar(200) COMMENT '密码',
`maijiaxingming` varchar(200) COMMENT '卖家姓名',
`xingbie` varchar(200) COMMENT '性别',
`chushengnianyue` date COMMENT '出生年月',
`qqzhanghao` int COMMENT 'qq账号',
`lianxidianhua` varchar(200) COMMENT '联系电话',
`dianziyouxiang` varchar(200) COMMENT '电子邮箱',
`shenfenzhenghao` varchar(200) COMMENT '身份证号',
`jiatingdizhi` varchar(200) COMMENT '家庭地址',
`renzhengzhaopian` varchar(200) COMMENT '认证照片',
`sfsh` varchar(200) default '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='卖家';
INSERT INTO maijia(maijiazhanghao,mima,maijiaxingming,xingbie,chushengnianyue,qqzhanghao,lianxidianhua,dianziyouxiang,shenfenzhenghao,jiatingdizhi,renzhengzhaopian,sfsh,shhf) VALUES('卖家1','123456','卖家姓名1','男',CURRENT_TIMESTAMP,1,'020-89819991','773890001@qq.com','440300199101010001','家庭地址1','maijia_renzhengzhaopian1','否','');
INSERT INTO maijia(maijiazhanghao,mima,maijiaxingming,xingbie,chushengnianyue,qqzhanghao,lianxidianhua,dianziyouxiang,shenfenzhenghao,jiatingdizhi,renzhengzhaopian,sfsh,shhf) VALUES('卖家2','123456','卖家姓名2','男',CURRENT_TIMESTAMP,2,'020-89819992','773890002@qq.com','440300199202020002','家庭地址2','maijia_renzhengzhaopian2','否','');
INSERT INTO maijia(maijiazhanghao,mima,maijiaxingming,xingbie,chushengnianyue,qqzhanghao,lianxidianhua,dianziyouxiang,shenfenzhenghao,jiatingdizhi,renzhengzhaopian,sfsh,shhf) VALUES('卖家3','123456','卖家姓名3','男',CURRENT_TIMESTAMP,3,'020-89819993','773890003@qq.com','440300199303030003','家庭地址3','maijia_renzhengzhaopian3','否','');
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`yonghuming` varchar(200) UNIQUE COMMENT '用户名',
`mima` varchar(200) COMMENT '密码',
`xingming` varchar(200) COMMENT '姓名',
`nianling` int COMMENT '年龄',
`chushengnianyue` date COMMENT '出生年月',
`qqzhanghao` int COMMENT 'qq账号',
`dianhuahaoma` varchar(200) COMMENT '电话号码',
`youxianghaoma` varchar(200) COMMENT '邮箱号码',
`shenfenzhenghao` varchar(200) COMMENT '身份证号',
`jiatingdizhi` varchar(200) COMMENT '家庭地址',
`gerenzhaopian` varchar(200) COMMENT '个人照片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';
INSERT INTO yonghu(yonghuming,mima,xingming,nianling,chushengnianyue,qqzhanghao,dianhuahaoma,youxianghaoma,shenfenzhenghao,jiatingdizhi,gerenzhaopian) VALUES('用户1','123456','姓名1',1,CURRENT_TIMESTAMP,1,'020-89819991','773890001@qq.com','440300199101010001','家庭地址1','yonghu_gerenzhaopian1');
INSERT INTO yonghu(yonghuming,mima,xingming,nianling,chushengnianyue,qqzhanghao,dianhuahaoma,youxianghaoma,shenfenzhenghao,jiatingdizhi,gerenzhaopian) VALUES('用户2','123456','姓名2',2,CURRENT_TIMESTAMP,2,'020-89819992','773890002@qq.com','440300199202020002','家庭地址2','yonghu_gerenzhaopian2');
INSERT INTO yonghu(yonghuming,mima,xingming,nianling,chushengnianyue,qqzhanghao,dianhuahaoma,youxianghaoma,shenfenzhenghao,jiatingdizhi,gerenzhaopian) VALUES('用户3','123456','姓名3',3,CURRENT_TIMESTAMP,3,'020-89819993','773890003@qq.com','440300199303030003','家庭地址3','yonghu_gerenzhaopian3');
DROP TABLE IF EXISTS `youxileibie`;
CREATE TABLE `youxileibie` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`youxifenlei` varchar(200) COMMENT '游戏分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='游戏类别';
INSERT INTO youxileibie(youxifenlei) VALUES('游戏分类1');
INSERT INTO youxileibie(youxifenlei) VALUES('游戏分类2');
INSERT INTO youxileibie(youxifenlei) VALUES('游戏分类3');
DROP TABLE IF EXISTS `shouxufeiyong`;
CREATE TABLE `shouxufeiyong` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`jiagequjian` varchar(200) COMMENT '价格区间',
`shouxufei` int COMMENT '手续费',
`pingtaibaozhang` varchar(200) COMMENT '平台保障',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='手续费用';
INSERT INTO shouxufeiyong(jiagequjian,shouxufei,pingtaibaozhang) VALUES('价格区间1',1,'平台包赔');
INSERT INTO shouxufeiyong(jiagequjian,shouxufei,pingtaibaozhang) VALUES('价格区间2',2,'平台包赔');
INSERT INTO shouxufeiyong(jiagequjian,shouxufei,pingtaibaozhang) VALUES('价格区间3',3,'平台包赔');
DROP TABLE IF EXISTS `dixiachengyuyongshi`;
CREATE TABLE `dixiachengyuyongshi` (
`id` bigint NOT NULL AUTO_INCREMENT,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`maijiazhanghao` varchar(200) COMMENT '卖家账号',
`maijiaxingming` varchar(200) COMMENT '卖家姓名',
`shangpinbianhao` varchar(200) UNIQUE COMMENT '商品编号',
`zhanghaobiaoti` varchar(200) COMMENT '账号标题',
`youxiqufu` varchar(200) COMMENT '游戏区服',
`youxikuaqu` varchar(200) COMMENT '游戏跨区',
`jiaosedengji` varchar(200) COMMENT '角色等级',
`jiaosezhiye` varchar(200) COMMENT '角色职业',
`jiaosexingbie` varchar(200) COMMENT '角色性别',
`fenghaojilu` varchar(200) COMMENT '封号记录',
`qqdengji` varchar(200) COMMENT 'qq等级',
`qqhaoyou` varchar(200) COMMENT 'qq好友',
`fengmiantupian` varchar(200) COMMENT '封面图片',
`zhanghaojiage` int COMMENT '账号价格',
`jiagequjian` varchar(200) COMMENT '价格区间',
`shouxufei` varchar(200) COMMENT '手续费',
`pingtaibaozhang` varchar(200) COMMENT '平台保障',
`zhanghaojianjie` longtext COMMENT '账号简介',
`faburiqi` date COMMENT '发布日期',
`zhanghaoxiangqing` longtext COMMENT '账号详情',
`thumbsupnum` int default '0' COMMENT '赞',
`crazilynum` int default '0' COMMENT '踩',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地下城与勇士';
INSERT INTO dixiachengyuyongshi(maijiazhanghao,maijiaxingming,shangpinbianhao,zhanghaobiaoti,youxiqufu,youxikuaqu,jiaosedengji,jiaosezhiye,jiaosexingbie,fenghaojilu,qqdengji,qqhaoyou,fengmiantupian,zhanghaojiage,jiagequjian,shouxufei,pingtaibaozhang,zhanghaojianjie,faburiqi,zhanghaoxiangqing,thumbsupnum,crazilynum) VALUES('卖家账号1','卖家姓名1','商品编号1','账号标题1','游戏区服1','游戏跨区1','角色等级1','男鬼剑','男','存在五天封号记录','qq等级1','无QQ好友','dixiachengyuyongshi_fengmiantupian1',1,'价格区间1','手续费1','平台保障1','账号简介1',CURRENT_TIMESTAMP,'账号详情1',1,1);
INSERT INTO dixiachengyuyongshi(maijiazhanghao,maijiaxingming,shangpinbianhao,zhanghaobiaoti,youxiqufu,youxikuaqu,jiaosedengji,jiaosezhiye,jiaosexingbie,fenghaojilu,qqdengji,qqhaoyou,fengmiantupian,zhanghaojiage,jiagequjian,shouxufei,pingtaibaozhang,zhanghaojianjie,faburiqi,zhanghaoxiangqing,thumbsupnum,crazilynum) VALUES('卖家账号2','卖家姓名2','商品编号2','账号标题2','游戏区服2','游戏跨区2','角色等级2','男鬼剑','男','存在五天封号记录','qq等级2','无QQ好友','dixiachengyuyongshi_fengmiantupian2',2,'价格区间2','手续费2','平台保障2','账号简介2',CURRENT_TIMESTAMP,'账号详情2',2,2);
INSERT INTO dixiachengyuyongshi(maijiazhanghao,maijiaxingming,shangpinbianhao,zhanghaobiaoti,youxiquf
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经过本地编译可运行的,下载完成之后配置相应环境即可使用。源码功能都是经过老师肯定的,都能满足要求,有需要放心下载即可。源码是经
资源推荐
资源详情
资源评论
收起资源包目录
基于JSP的游戏账号售卖系统源码.zip (3962个子文件)
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
ZhanghaojiaoyijiluController.class 8KB
SixinliaotianhuifuController.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
共 3962 条
- 1
- 2
- 3
- 4
- 5
- 6
- 40
资源评论
知一NN
- 粉丝: 31
- 资源: 3830
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功