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

Source: Internet
Author: User

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.


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.