# cms

**Repository Path**: wishwzp/cms

## Basic Information

- **Project Name**: cms
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-05-17
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#cms                 
模仿DeDeCMS的Java CMS系统                      
CMS系统设计分为"文章分类","文章内容","友情链接","后台登录管理"              
系统采用：maven+spring+springMVC+mybatis+shiro技术                   
运用百度的ueditor工具在发表后台的编辑之中                               
开发工具：eclipse         
数据库：mysql             


----------
                  
数据字典：         
数据库为：db_cms
一共有四张表：             
文章分类：t_arctype               
文章内容：t_article              
友情链接：t_link          
管理员：t_manager                   
 
表：t_arctype
CREATE TABLE `t_arctype` (   
  `id` int(11) NOT NULL AUTO_INCREMENT,

  `typeName` varchar(100) DEFAULT NULL,

  `sortNo` int(11) DEFAULT NULL,

  `keywords` varchar(400) DEFAULT NULL,

  `description` varchar(1000) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

 表t_article

 CREATE TABLE `t_article` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(100) DEFAULT NULL,

  `publishDate` datetime DEFAULT NULL,

  `content` text,

  `summary` varchar(500) DEFAULT NULL,

  `titleColor` varchar(100) DEFAULT NULL,

  `click` int(11) DEFAULT NULL,

  `isRecommend` tinyint(4) DEFAULT NULL,

  `isSlide` int(11) DEFAULT NULL,

  `slideImage` varchar(100) DEFAULT NULL,

  `typeId` int(11) DEFAULT NULL,

  `keyWords` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `typeId` (`typeId`),

  CONSTRAINT `t_article_ibfk_1` FOREIGN KEY (`typeId`) REFERENCES `t_arctype` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;