JavaWeb技术开发，后端采用Jsp+Servlet。前端使用的是Bootstrap的一个网站模板。通过3种角色使用,实现了包括了球员信息管理、球队信息管理、赛事信息发布、赛事订阅等多个不同的模块。

项目类型：JavaWeb源码 

用户类型：3个角色（管理员+球粉+球员账号）

主要技术：Jsp+Servlet+MySQL+Bootstrap

开发工具：Eclipse/Idea均可使用，有两个不同的版本

数据库：MySQL

数据库表：10张

项目介绍：

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

00完整的程序目录

01球粉端功能介绍

1.0用户注册登录

1.1系统首页

1.2球队信息详情页面（展示对应的球员及球队介绍）

1.3球员信息介绍页面

1.4球员信息详情页面（粉丝登录以后，可以在底部评论留言）

1.5赛事订阅

1.6新闻阅读

02管理员端功能介绍

2.1 后台首页

2.2球员信息管理

2.3球迷信息管理

2.4新闻发布

2.5球队信息管理

2.6赛事信息发布

03球员账号端功能介绍

3.1粉丝留言回复

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

06演示视频

---

00完整的程序目录

01球粉端功能介绍

1.0用户注册登录

1.1系统首页

1.2球队信息详情页面（展示对应的球员及球队介绍）

1.3球员信息介绍页面

1.4球员信息详情页面（粉丝登录以后，可以在底部评论留言）

1.5赛事订阅

​

1.6新闻阅读

02管理员端功能介绍

2.1 后台首页

2.2球员信息管理

2.3球迷信息管理

2.4新闻发布

2.5球队信息管理

2.6赛事信息发布

03球员账号端功能介绍

3.1粉丝留言回复

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

06演示视频

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for com
-- ----------------------------
DROP TABLE IF EXISTS `com`;
CREATE TABLE `com`  (`id` int(11) NOT NULL AUTO_INCREMENT,`cid` int(11) DEFAULT NULL,`uid` int(11) DEFAULT NULL,`uimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (`id` int(11) NOT NULL AUTO_INCREMENT,`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`uid` int(11) DEFAULT NULL,`fid` int(11) DEFAULT NULL,`fname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`times` datetime(0) DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for fan
-- ----------------------------
DROP TABLE IF EXISTS `fan`;
CREATE TABLE `fan`  (`id` int(11) NOT NULL AUTO_INCREMENT,`names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0',`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for game
-- ----------------------------
DROP TABLE IF EXISTS `game`;
CREATE TABLE `game`  (`id` int(11) NOT NULL AUTO_INCREMENT,`gname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`tid1` int(11) DEFAULT NULL,`tid2` int(11) DEFAULT NULL,`starttime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`endtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message`  (`id` int(11) NOT NULL AUTO_INCREMENT,`gid` int(11) DEFAULT NULL,`fid` int(11) DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`content` text CHARACTER SET utf8 COLLATE utf8_general_ci,`editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for team
-- ----------------------------
DROP TABLE IF EXISTS `team`;
CREATE TABLE `team`  (`id` int(11) NOT NULL AUTO_INCREMENT,`tname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`tno` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for team_user
-- ----------------------------
DROP TABLE IF EXISTS `team_user`;
CREATE TABLE `team_user`  (`id` int(11) NOT NULL AUTO_INCREMENT,`tid` int(11) DEFAULT NULL,`uid` int(11) DEFAULT NULL,`times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (`id` int(11) NOT NULL AUTO_INCREMENT,`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1' COMMENT '1未入队 2已入队',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;