开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS `bisaibaoming`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bisaibaoming` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`baomingbianhao` varchar(200) DEFAULT NULL COMMENT ‘报名编号’,
`xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT ‘项目名称’,
`xiangmuleixing` varchar(200) DEFAULT NULL COMMENT ‘项目类型’,
`tupian` varchar(200) DEFAULT NULL COMMENT ‘图片’,
`baomingshijian` datetime DEFAULT NULL COMMENT ‘报名时间’,
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT ‘用户账号’,
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT ‘用户姓名’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`),
UNIQUE KEY `baomingbianhao` (`baomingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT=’比赛报名’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `bisaibaoming`
—
LOCK TABLES `bisaibaoming` WRITE;
/*!40000 ALTER TABLE `bisaibaoming` DISABLE KEYS */;
INSERT INTO `bisaibaoming` VALUES (41,’2022-05-19 06:30:58′,’1111111111′,’项目名称1′,’项目类型1′,’upload/bisaibaoming_tupian1.jpg’,’2022-05-19 14:30:58′,’用户账号1′,’用户姓名1′,’是’,”),(42,’2022-05-19 06:30:58′,’2222222222′,’项目名称2′,’项目类型2′,’upload/bisaibaoming_tupian2.jpg’,’2022-05-19 14:30:58′,’用户账号2′,’用户姓名2′,’是’,”),(43,’2022-05-19 06:30:58′,’3333333333′,’项目名称3′,’项目类型3′,’upload/bisaibaoming_tupian3.jpg’,’2022-05-19 14:30:58′,’用户账号3′,’用户姓名3′,’是’,”),(44,’2022-05-19 06:30:58′,’4444444444′,’项目名称4′,’项目类型4′,’upload/bisaibaoming_tupian4.jpg’,’2022-05-19 14:30:58′,’用户账号4′,’用户姓名4′,’是’,”),(45,’2022-05-19 06:30:58′,’5555555555′,’项目名称5′,’项目类型5′,’upload/bisaibaoming_tupian5.jpg’,’2022-05-19 14:30:58′,’用户账号5′,’用户姓名5′,’是’,”),(46,’2022-05-19 06:30:58′,’6666666666′,’项目名称6′,’项目类型6′,’upload/bisaibaoming_tupian6.jpg’,’2022-05-19 14:30:58′,’用户账号6′,’用户姓名6′,’是’,”);
/*!40000 ALTER TABLE `bisaibaoming` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `chengjixinxi`
—
DROP TABLE IF EXISTS `chengjixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chengjixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`chengjibianhao` varchar(200) DEFAULT NULL COMMENT ‘成绩编号’,
`xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT ‘项目名称’,
`xiangmuleixing` varchar(200) DEFAULT NULL COMMENT ‘项目类型’,
`tupian` varchar(200) DEFAULT NULL COMMENT ‘图片’,
`fabushijian` datetime DEFAULT NULL COMMENT ‘发布时间’,
`bisaichengji` float DEFAULT NULL COMMENT ‘比赛成绩’,
`xiangqing` longtext COMMENT ‘详情’,
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT ‘用户账号’,
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT ‘用户姓名’,
`userid` bigint(20) DEFAULT NULL COMMENT ‘用户id’,
PRIMARY KEY (`id`),
UNIQUE KEY `chengjibianhao` (`chengjibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’成绩信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `chengjixinxi`
—
LOCK TABLES `chengjixinxi` WRITE;
/*!40000 ALTER TABLE `chengjixinxi` DISABLE KEYS */;
INSERT INTO `chengjixinxi` VALUES (51,’2022-05-19 06:30:58′,’1111111111′,’项目名称1′,’项目类型1′,’upload/1652942004223.png’,’2022-05-19 14:30:58′,1,'<p>详情1</p>’,’用户账号1′,’用户姓名1′,1),(52,’2022-05-19 06:30:58′,’2222222222′,’项目名称2′,’项目类型2′,’upload/chengjixinxi_tupian2.jpg’,’2022-05-19 14:30:58′,2,’详情2′,’用户账号2′,’用户姓名2′,2),(53,’2022-05-19 06:30:58′,’3333333333′,’项目名称3′,’项目类型3′,’upload/chengjixinxi_tupian3.jpg’,’2022-05-19 14:30:58′,3,’详情3′,’用户账号3′,’用户姓名3′,3),(54,’2022-05-19 06:30:58′,’4444444444′,’项目名称4′,’项目类型4′,’upload/chengjixinxi_tupian4.jpg’,’2022-05-19 14:30:58′,4,’详情4′,’用户账号4′,’用户姓名4′,4),(55,’2022-05-19 06:30:58′,’5555555555′,’项目名称5′,’项目类型5′,’upload/chengjixinxi_tupian5.jpg’,’2022-05-19 14:30:58′,5,’详情5′,’用户账号5′,’用户姓名5′,5),(56,’2022-05-19 06:30:58′,’6666666666′,’项目名称6′,’项目类型6′,’upload/chengjixinxi_tupian6.jpg’,’2022-05-19 14:30:58′,6,’详情6′,’用户账号6′,’用户姓名6′,6);
/*!40000 ALTER TABLE `chengjixinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `config`
—
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`name` varchar(100) NOT NULL COMMENT ‘配置参数名称’,
`value` varchar(100) DEFAULT NULL COMMENT ‘配置参数值’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=’配置文件’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `config`
—
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,’picture1′,’upload/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `news`
—
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`title` varchar(200) NOT NULL COMMENT ‘标题’,
`introduction` longtext COMMENT ‘简介’,
`picture` varchar(200) NOT NULL COMMENT ‘图片’,
`content` longtext NOT NULL COMMENT ‘内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT=’广播信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `news`
前台登录代码：
// 登陆
login() {
if (!this.rulesForm.username) {
this.$message.error(“请输入用户名”);
return;
}
if (!this.rulesForm.password) {
this.$message.error(“请输入密码”);
return;
}
if(this.roles.length>1) {
if (!this.rulesForm.role) {
this.$message.error(“请选择角色”);
return;
}
let menus = this.menus;
for (let i = 0; i < menus.length; i++) {
if (menus[i].roleName == this.rulesForm.role) {
this.tableName = menus[i].tableName;
}
}
} else {
this.tableName = this.roles[0].tableName;
this.rulesForm.role = this.roles[0].roleName;
}
this.$http({
url: `${this.tableName}/login?username=${this.rulesForm.username}&password=${this.rulesForm.password}`,
method: “post”
}).then(({ data }) => {
if (data && data.code === 0) {
this.$storage.set(“Token”, data.token);
this.$storage.set(“role”, this.rulesForm.role);
this.$storage.set(“sessionTable”, this.tableName);
this.$storage.set(“adminName”, this.rulesForm.username);
this.$router.replace({ path: “/index/” });
} else {
this.$message.error(data.msg);
}
});
},
getRandCode(len = 4){
this.randomString(len)
},
randomString(len = 4) {
let chars = [
“a”, “b”, “c”, “d”, “e”, “f”, “g”, “h”, “i”, “j”, “k”,
“l”, “m”, “n”, “o”, “p”, “q”, “r”, “s”, “t”, “u”, “v”,
“w”, “x”, “y”, “z”, “A”, “B”, “C”, “D”, “E”, “F”, “G”,
“H”, “I”, “J”, “K”, “L”, “M”, “N”, “O”, “P”, “Q”, “R”,
“S”, “T”, “U”, “V”, “W”, “X”, “Y”, “Z”, “0”, “1”, “2”,
“3”, “4”, “5”, “6”, “7”, “8”, “9”
]
let colors = [“0”, “1”, “2”,”3″, “4”, “5”, “6”, “7”, “8”, “9”, “a”, “b”, “c”, “d”, “e”, “f”]
let sizes = [’14’, ’15’, ’16’, ’17’, ’18’]
let output = [];
for (let i = 0; i < len; i++) {
// 随机验证码
let key = Math.floor(Math.random()*chars.length)
this.codes[i].num = chars[key]
// 随机验证码颜色
let code = ‘#’
for (let j = 0; j < 6; j++) {
let key = Math.floor(Math.random()*colors.length)
code += colors[key]
}
this.codes[i].color = code
// 随机验证码方向
let rotate = Math.floor(Math.random()*60)
let plus = Math.floor(Math.random()*2)
if(plus == 1) rotate = ‘-‘+rotate
this.codes[i].rotate = ‘rotate(‘+rotate+’deg)’
// 随机验证码字体大小
let size = Math.floor(Math.random()*sizes.length)
this.codes[i].size = sizes[size]+’px’
}
},
}
};
</script>