Java实现论坛系统

ゝ一世哀愁。 2022-02-02 02:43 268阅读 0赞

***学习Java实现论坛系统，本文实现该系统的功能截图，和数据库设计SQL语句供大家参考***

## 1.论坛管理系统背景 ##

随着现在科技的发展，论坛系统越来越多，本系统仿照CSDN做一个java学习论坛系统。

## 2.后台管理功能 ##

***后台功能简单介绍和功能展示***  
2.1用户管理功能，可以给用户授予管理员高级管理员权限，可以禁止或者解禁用户功能。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]  
2.2用户信息![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]  
2.3 板块信息维护  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]  
2.4公告信息维护  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]  
2.5帮助信息维护  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]

## 3.前台功能 ##

***前台功能简单介绍和功能展示***  
3.1前台首页信息  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]  
3.2论坛帖子查看页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 6]  
3.3论坛公告显示页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 7]  
3.4 帮助信息显示页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 8]  
3.5登录页面显示![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 9]  
3.6个人信息中心，在个人信息中心可以查看收到的消息，自己发布的帖子，查看自己评论的内容，修改个人信息，修改密码等功能  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 10]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 11]  
3.7 帖子查看页面，可以根据热门和精品帖子查看  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 12]  
3.8根据板块查询帖子功能  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 13]  
3.9帮助查看页面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 14]

## 3.数据库设计功能 ##

CREATE TABLE `t_announce` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `announcement` longtext,
      `title` varchar(100) DEFAULT NULL,
      `newtime` datetime DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_category` (
      `id` int(11) NOT NULL,
      `name` varchar(30) DEFAULT NULL,
      `count_topics` int(11) DEFAULT '0',
      `count_comments` int(11) DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_comment` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `content` longtext,
      `floor` int(11) DEFAULT NULL,
      `comment_time` datetime DEFAULT NULL,
      `comments_user_id` int(11) NOT NULL,
      `comments_topic_id` int(11) NOT NULL,
      `integral` int(11) DEFAULT '0',
      `status` int(11) DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `comments_topic_id` (`comments_topic_id`) USING BTREE,
      KEY `comments_user_id` (`comments_user_id`),
      CONSTRAINT `comments_topic_id` FOREIGN KEY (`comments_topic_id`) REFERENCES `t_topic` (`id`),
      CONSTRAINT `comments_user_id` FOREIGN KEY (`comments_user_id`) REFERENCES `t_user` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_grade` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `honor` varchar(30) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_help` (
      `id` int(11) NOT NULL,
      `title` varchar(100) DEFAULT NULL,
      `content` longtext,
      `newtime` datetime DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_new` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `new_time` datetime DEFAULT NULL,
      `news_comment_user_id` int(11) NOT NULL,
      `news_topic_id` int(11) NOT NULL,
      `status` int(11) DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `news_comment_user_id` (`news_comment_user_id`),
      KEY `news_topic_id` (`news_topic_id`),
      CONSTRAINT `news_comment_user_id` FOREIGN KEY (`news_comment_user_id`) REFERENCES `t_user` (`id`),
      CONSTRAINT `news_topic_id` FOREIGN KEY (`news_topic_id`) REFERENCES `t_topic` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_topic` (
      `id` int(11) NOT NULL,
      `title` varchar(50) DEFAULT NULL,
      `content` longtext,
      `comment_count` int(11) DEFAULT '0',
      `status` int(11) DEFAULT '0',
      `topic_time` datetime DEFAULT NULL,
      `topics_user_id` int(11) NOT NULL,
      `topics_type_id` int(11) NOT NULL,
      `nice_topic` int(11) DEFAULT '0',
      `integral` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `topics_user_id` (`topics_user_id`),
      KEY `topics_type_id` (`topics_type_id`),
      CONSTRAINT `topics_type_id` FOREIGN KEY (`topics_type_id`) REFERENCES `t_type` (`id`),
      CONSTRAINT `topics_user_id` FOREIGN KEY (`topics_user_id`) REFERENCES `t_user` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_type` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(30) DEFAULT NULL,
      `count_topics` int(11) DEFAULT '0',
      `count_comments` int(11) DEFAULT '0',
      `is_admin_type` int(11) DEFAULT '0',
      `types_category_id` int(11) NOT NULL,
      PRIMARY KEY (`id`),
      KEY `types_category_id` (`types_category_id`),
      CONSTRAINT `types_category_id` FOREIGN KEY (`types_category_id`) REFERENCES `t_category` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
    
    CREATE TABLE `t_user` (
      `id` int(11) NOT NULL,
      `username` varchar(20) DEFAULT NULL,
      `password` varchar(20) DEFAULT NULL,
      `nickname` varchar(32) DEFAULT NULL,
      `sex` varchar(2) DEFAULT NULL,
      `picture` varchar(255) DEFAULT NULL,
      `email` varchar(20) DEFAULT NULL,
      `come_from` varchar(200) DEFAULT NULL,
      `introduction` longtext,
      `profession` varchar(40) DEFAULT NULL,
      `grade_integal` int(11) DEFAULT '0',
      `integral` int(11) DEFAULT NULL,
      `clock` int(11) DEFAULT NULL,
      `topic_count` int(11) DEFAULT NULL,
      `comment_count` int(11) DEFAULT NULL,
      `role_id` int(11) DEFAULT '0',
      `users_grade_id` int(11) NOT NULL,
      `register_time` datetime DEFAULT NULL,
      `status` int(11) DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `usersGrade_id` (`users_grade_id`),
      CONSTRAINT `usersGrade_id` FOREIGN KEY (`users_grade_id`) REFERENCES `t_grade` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]: /images/20220202/d4205da7bd7e4b718fa3c11d3ac641ef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]: /images/20220202/8d6900378d55494c95bdd72058774676.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]: /images/20220202/c766bdd8f7f54889944c7041ceaa9828.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]: /images/20220202/5f196b46c0e54469a2bb26dfce785430.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]: /images/20220202/1201040aaa2c4a7d8f5c78542a3eeea9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]: /images/20220202/630ef4f32e1649179b3b4e91bd9debfb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 6]: /images/20220202/c2bb66ab210c4818aeaeefc550a5e9d9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 7]: /images/20220202/4e4952c85db84ae2aea2b586eea4b5d4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 8]: /images/20220202/4f48bd96fa05444f85d315366c6eb307.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 9]: /images/20220202/02bb37abc050499085a84bad95729603.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 10]: /images/20220202/2c4c0a3632954ab79444acea545b1d0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 11]: /images/20220202/a943912fed004ab9997a111a0282550e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 12]: /images/20220202/df2989b0a6944ccd885bee6e07cbe074.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 13]: /images/20220202/9248b16c3798456695b53b73430bd307.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 14]: /images/20220202/598a7fc598204a4f9e8d12500ab8bb20.png