This is the 24th day of my participation in the August More Text Challenge

  Subscribe to download the source code  

Main functional module design:

The administrator role has the following functions: administrator login, bulletin, modify information, view new posts, view elite post requests, block users, create discussion areas, and so on. User roles include the following functions: View by category, user login, view details of posts, view my posts, submit posts, modify information, view application records and other functions.

Technical Framework:

HTML + CSS + JavaScript + JSP + mysql + Spring + hibernate, etc

Suitable for:

This procedure is not large, can be used for course design, graduation design study demonstration

Function screenshots:

System home page functions:

Login and registration:

 <ul class="nav navbar-nav navbar-right user">
               <li><a href="/ssh_zaixianxx_bbs/login.jsp">landing</a></li>
                <li><a href="/ssh_zaixianxx_bbs/regist.jsp">registered</a></li>
                 <li><a target="_blank" href="/ssh_zaixianxx_bbs/manage/admin.jsp">Forum Administrator Login</a></li>
            </ul>
            <p class="navbar-text navbar-right">Dear visitors,</p>
            
                <form class="navbar-form navbar-right" role="search" action="/ssh_zaixianxx_bbs/search.action">
		       <div class="input-group">
	         <input type="text" class="form-control" name="keywords" placeholder="search">
	        <span class="input-group-addon"><span class="glyphicon glyphicon-search"></span> </span>
	     		 </div>
      		</form> 
            </nav>
  
  </body>
</html>

 <div class="login">

    <form id="form1" role="form" action="/ssh_zaixianxx_bbs/login.action" method="post">
            <! --<label for="name">
            <input id="username" required type="text" class="form-control" name="username" style="height: 55px; margin-top: 30px;"
                   placeholder="Please enter user name">
            <! --<label for="name"></label>-->
            <input type="password" required class="form-control" name="password" style="height: 55px; margin-top: 30px;"
                   placeholder="Please enter your password">
        <div style="height: 100px; width: 100%; margin-top: 30px;">
            <div style="float:left; width: 50%; padding: 20px;">
                <input type="submit" class="btn btn-primary" value="Login"
                   style="margin:auto; width: 80%; height: 50px; padding: 13px;"></input>
            </div>
            <div style="float:right; width: 50%; padding: 20px;">
                <a href="/ssh_zaixianxx_bbs/regist.jsp" type="button" class="btn btn-primary"
                   style="margin:auto; width: 80%; height: 50px; padding: 13px;">registered</a>
            </div>

        </div>

    </form>

</div>
  
  <div class="bottom" style="position:absolute; bottom:0px; margin-top: 20px; Background - color: rgba (0,0,0,0.8); width:100%; height: 100px; color: darkgray">
    <div style="width: 400px; padding-top: 35px; padding-left:40px; padding-right: 40px; margin:auto;">
        <div>           
            
        </div>

    </div>
  </body>
  <script type="text/javascript" src="js/jquery.validate.min.js"></script>
  <script type="text/javascript">
  	$(function(){$("#signupForm").validate();
  	});
  </script>
</html>
Copy the code

Post:

Details:

Comment on:

Post:

Background management:

 

Database design:

The users table:

CREATE TABLE `NewTable` (
`user_id`  int(11) NOT NULL AUTO_INCREMENT ,
`head_portrait`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`lately_login_time`  datetime NULL DEFAULT NULL ,
`nickname`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`registration_date`  datetime NULL DEFAULT NULL ,
`sex`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`open_id`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`username`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`article_ids`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`birthday`  date NULL DEFAULT NULL ,
`momo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`phone`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`user_ids`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`user_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=20
ROW_FORMAT=COMPACT
;
Copy the code

Comments list:


CREATE TABLE `NewTable` (
`comment_id`  int(11) NOT NULL AUTO_INCREMENT ,
`comment_date`  datetime NULL DEFAULT NULL ,
`content`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ,
`article_id`  int(11) NULL DEFAULT NULL ,
`user_id`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`comment_id`),
FOREIGN KEY (`article_id`) REFERENCES `t_article` (`article_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `t_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `FKlsvvc2ob8lxg2m9qqry15ru0y` (`article_id`) USING BTREE ,
INDEX `FKtamaoacctq4qpko6bvtv0ke1p` (`user_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
AUTO_INCREMENT=15
ROW_FORMAT=COMPACT
;
Copy the code

Conclusion:

Well, that’s all for today.This procedure is not large, can be used for course design, graduation design study demonstration.

In addition, we need white piao Java learning materials including “JVM, Netty, Mysql, Mybatis, Redis, Dubbo, Nginx, design mode” and other 10G information package, you can see my home page or private blog.

Punch Java updates 15/100 days

You can like, like, follow, comment on me,