Shulou(Shulou.com)06/02 Report--

This article shows you what the SSM news management system is, which is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1.JaveWeb News Management system

This project is based on SSM architecture and includes general functions of press release system. At the same time, this project includes front-end, back-end and mobile applications.

It is equivalent to a simple and comprehensive collection of projects at all ends.

two。 Project address:

Press release system (wcdog): https://github.com/xandone/wcdog

Android side (wcdog-app): https://github.com/xandone/wcdog-app

Web side (wcdog-web): https://github.com/xandone/wcdog-web

Administrative backend (wcdog-manager): https://github.com/xandone/wcdog-manager

3. Function introduction

Mobile app (Android)

Based on MVP architecture, technology stack: MVP+Material+retrofit2+Rx..

Main modules:

a. Login / Registration

b. Post

c. Reply / like

d. Search function

e. Personal center

f. Version update

g. Collection

h. Other

Preview:

Web front-end project

Based on vue.js, technology stack: vue+vuex+vue Router+scss

Main modules:

a. Login / Registration

b. Post

c. Reply / like

d. Search

e. Announcement panel

f. Send a message.

g. Personal center

h. Other

Preview:

Manage the backend

Based on vue.js, technology stack: vue+vuex+vue Router+element

Main modules:

a. User management

b. Post management

c. Comment management

d. Bulletin panel / talk about management

E. Banner management

F forbidden function

g. Picture management

h. User permissions

i. Administrator permissions

j. Other

Preview:

4. Project deployment

Version

* * IED** IntelliJ IDEA

* * tomcat** 7.0.91

* * maven** 3.5.4

* * jdk** 1.8.0

* * mysql** 5.7.19

* * spring** 4.1.3

* * mybatis** 3.2.8

* * os** CentOs 6.5

* * nginx** 1.12.2

5. Description

For 1.mysql database, please see the project root directory wcdog.sql. You need to import it manually and add data by yourself.

two。 Note that the tomcat port, the management system and the H5 front-end baseUrl are all port 8081, which can also be modified by yourself.

3. When using the administrative backend (wcdog-manager) to add joke, note that you are using the user_id in the y _ user table, so you need to

There is a user with the same user_id as y_admin in the y _ user table. Of course, you can also add addJoke party to adminMapper.

Law (I'm too lazy to write, a shared one-_!)

6. Db

`

# # User Table

Create table y_user (

Id int (11) unsigned not null auto_increment

User_id varchar (18) not null

Name varchar (20) not null unique

Password varchar (20) not null

Nickname varchar (20) not null

User_icon varchar (255) DEFAULT NULL

Talk varchar (300)

Address varchar (100)

Token varchar (100)

Regist_time datetime

Last_login_time datetime

Banned tinyint (1) DEFAULT 0

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # joke Table

Create table y_joke (

Id int (11) unsigned not null auto_increment

Joke_id varchar (18) not null

Joke_user_id varchar (18) not null

Title varchar (255) not null

Content mediumtext

ContentHtml mediumtext

Cover_img varchar (255) DEFAULT NULL

Post_time datetime DEFAULT NULL

Art_like_count int (5) DEFAULT'0'

Art_comment_count int (5) DEFAULT'0'

Category varchar (4) DEFAULT NULL

Tags varchar (100) DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # joke praise form

Create table y_joke_like (

Id int (11) unsigned not null auto_increment

Joke_id varchar (18) not null

Joke_user_id varchar (18)

Approval_time datetime DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # joke comment form

Create table y_joke_comment (

Id int (11) unsigned not null auto_increment

Comment_id varchar (18) not null

Joke_id varchar (18)

Comment_user_id varchar (18)

Comment_details mediumtext

Comment_date datetime DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # Images

Create table y_image (

Id int (11) unsigned not null auto_increment

User_id varchar (18) not null

ImgId varchar (18)

ImgUrl varchar (255)

PageViews int (6)

Size_type int (1)

UpTime datetime DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # Home rotational broadcast

Create table y_banner (

Id int (11) unsigned not null auto_increment

User_id varchar (18) not null

Articel_id varchar (18) not null

Title varchar (255)

Img_url varchar (255)

Article_url varchar (255)

PageViews int (6)

Up_time datetime DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # Traffic Statistics

Create table y_wcdog_flow (

Id int (11) unsigned not null auto_increment

Classic_count int (5) DEFAULT'0'

Yellow_count int (5) DEFAULT'0'

Mind_count int (5) DEFAULT'0'

Shite_count int (5) DEFAULT'0'

Cold_count int (5) DEFAULT'0'

All_user_count int (5) DEFAULT'0'

All_admin_count int (5) DEFAULT'0'

All_joke_count int (5) DEFAULT'0'

All_comment_count int (5) DEFAULT'0'

All_thumb_count int (5) DEFAULT'0'

Post_time datetime DEFAULT NULL

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # Admin Table

Create table y_admin (

Id int (11) unsigned not null auto_increment

Name varchar (20) not null unique

Password varchar (20) not null

Nickname varchar (20) not null

Admin_id varchar (18) not null

Admin_icon varchar (255) DEFAULT NULL

Permisson varchar (255) DEFAULT NULL

Token varchar (100)

Regist_time datetime

Last_login_time datetime

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # statement list

Create table y_talk_list (

Id int (11) unsigned not null auto_increment

Talk_id varchar (18) not null

User_id varchar (18) DEFAULT NULL

Talk varchar (100)

Send_time datetime

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # list of announcement columns

Create table y_plank (

Id int (11) unsigned not null auto_increment

Plank_id varchar (18) not null

Content varchar (300) DEFAULT NULL

Send_time datetime

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

# # apk version

Create table y_apk (

Id int (11) unsigned not null auto_increment

Apk_id varchar (18) not null

Apk_version varchar (20) not null

Apk_url varchar (255) not null

Apk_code int (5) not null

Content varchar (300) not null

Send_time datetime

Primary key (id)

) ENGINE=InnoDB DEFAULT CHARSET=UTF8

`

The above content is what the SSM news management system is, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.