Niu Yun news system (I)-UML, database design, and news system uml

Niu Yun news system (I)-UML, database design, and news system uml


Niu Yun news system (I)-UML and database design


I. Initial Knowledge of the niuyun System

Niu Yun (Brisket)That is, the beef abdomen and soft muscles close to the beef ribs refer to meat with tendon, meat, and oil

Block. The meat in many places on the oX can be called the ox's meat.

The point is that there are more meat, less oil, and even lean meat. It seems that this system has been learned. Niu Yu's news system is excellent in B/S.

China, classic! Let's start tasting it together.

2. Learning the software required by Niu Yi

1. Installation of VS and Database SQL

2. Other software:

Dreamweaver Flash PhotoShop

3. Browsers: IE, opera, chroma, and 360 browsers (released in these places must be enabled)

4. UML drawing tools: EA or JUDE

 


Iii. UML diagram

The news publishing system is mainly composed of two runners, the viewer and the background administrator. Therefore, the UML diagram of the news publishing system is as follows:

1. Use Case map "Viewer ":

2. Use Case Chart "backend manager ":

3. Class diagram:

Iii. database creation

Create three tables based on the previous object and class diagrams and create a new project. The SQL source code is as follows:

-- Create database newssystem -- 1. create table category (id int identity (1, 1) primary key, [name] varchar (20) not null) -- 2. create a news table create table news (id int identity (100) primary key, title varchar () not null, [content] text not null, createTime datetime not null, caId int) -- 3. create table comment (id int identity (1,1) primary key, [content] text not null, createTime datetime not null, userIp varchar (15) not null, newsId int)

The effect is as follows:


1. Category Table


 


2. News table:


 


3. Comment table:


 


Summary:

These are mainly some basic knowledge, but I still need to make a small summary for myself.

A real record of learning and growth. Niu Yu is a B/S project after the C/S project, the first B/S system,

The above mainly involves some reviews or reviews before C/S, drawing UML diagrams, and creating databases. "Niu

The highlights of the ghost news system are still coming soon. Stay tuned and give some advice.