基于JSP的游戏账号售卖系统源码.zip

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