Jsp+servlet+javabean Learning Phase Case-message board (messageboard)

A case summary of the Jsp+servlet+javabean learning phase

• Name: Message board (messageboard)
• Development technology: Jsp+servlet+javabean
• Database: Mysql
• Development tools: IntelliJ idea 2016.1.3
• Server: Tomcat 8.0.36

function Description
Normal User: Add delete change message
Administrator: Add delete modify message information, manage users, set user post message rights

Database structure

Tb_user table

Field	type	name	Description
Id	Int	Id
Name	nvarchar	Name
Password	nvarchar	Password
Limit	Int	Permissions	0: Allowed to speak 1: Prohibition of speeches
Tag	Int	Label	0: User 1: Administrator

Tb_message table

Field	type	name	Description
Id	Int	Id
Author	nvarchar	Author
Context	nvarchar	Message content
Msgdate	Datetime	Message time

structure
Overall structure

SRC structure

Web Structure

website Source code
Github:messageboard

Jsp+servlet+javabean Learning Phase Case-message board (messageboard)