Spring Boot(5)一个极简且完整的后台框架
2017-04-29 本文已影响7558人
面皮大师
一个完整的极简后台框架,方便做小项目的时候可以快速开发。
这里面多贴图片和代码,做个参考吧,代码可以下载下来自己看看,里面这套后台模板不错,喜欢的拿去。
先放几张图
后台登录页面 后台主页面 列表页项目介绍
SpringBoot,我也是第一次用,实现了一个极简单的后台框架,希望有不太合理的地方大家给个建议。
基础架构 项目结构
项目配置
maven配置pox.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.moxi</groupId>
<artifactId>moxi</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>moxi</name>
<description>mox</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.2.RELEASE</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.2.0</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--thymeleaf -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!--commons-io -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
项目配置文件application.properties
#DataBase start
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/moxi?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=Shu1shu2
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#DataBase end
#thymeleaf start
spring.thymeleaf.mode=HTML5
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.content-type=text/html
#开发时关闭缓存,不然没法看到实时页面
spring.thymeleaf.cache=false
#thymeleaf end
#uploadFileSize start
spring.http.multipart.maxFileSize=10Mb
spring.http.multipart.maxRequestSize=100Mb
#uploadFileSize end
项目分层
Controller层,追求极简,分页自己进行了一个简单封装
package com.moxi.controller;
import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpSession;
import org.apache.commons.io.FileUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
import com.moxi.model.NewsCategory;
import com.moxi.service.NewsCategoryService;
import com.moxi.util.PageUtil;
@Controller
@RequestMapping("/admin")
public class NewsController {
@Autowired
private NewsCategoryService newsCategoryService;
@RequestMapping("/newsManage_{pageCurrent}_{pageSize}_{pageCount}")
public String newsManage(@PathVariable Integer pageCurrent,@PathVariable Integer pageSize,@PathVariable Integer pageCount, Model model) {
return "/news/newsManage";
}
/**
* 文章分类列表
* @param newsCategory
* @param pageCurrent
* @param pageSize
* @param pageCount
* @param model
* @return
*/
@RequestMapping("/newsCategoryManage_{pageCurrent}_{pageSize}_{pageCount}")
public String newsCategoryManage(NewsCategory newsCategory,@PathVariable Integer pageCurrent,@PathVariable Integer pageSize,@PathVariable Integer pageCount, Model model) {
//判断
if(pageSize == 0) pageSize = 10;
if(pageCurrent == 0) pageCurrent = 1;
int rows = newsCategoryService.count(newsCategory);
if(pageCount == 0) pageCount = rows%pageSize == 0 ? (rows/pageSize) : (rows/pageSize) + 1;
//查询
newsCategory.setStart((pageCurrent - 1)*pageSize);
newsCategory.setEnd(pageSize);
List<NewsCategory> list = newsCategoryService.list(newsCategory);
//输出
model.addAttribute("list", list);
String pageHTML = PageUtil.getPageContent("newsCategoryManage_{pageCurrent}_{pageSize}_{pageCount}?name="+newsCategory.getName(), pageCurrent, pageSize, pageCount);
model.addAttribute("pageHTML",pageHTML);
model.addAttribute("newsCategory",newsCategory);
return "/news/newsCategoryManage";
}
/**
* 文章分类新增、修改跳转
* @param model
* @param newsCategory
* @return
*/
@GetMapping("newsCategoryEdit")
public String newsCategoryEditGet(Model model,NewsCategory newsCategory) {
if(newsCategory.getId()!=0){
NewsCategory newsCategoryT = newsCategoryService.findById(newsCategory);
model.addAttribute("newsCategory",newsCategoryT);
}
return "/news/newsCategoryEdit";
}
/**
* 文章分类新增、修改提交
* @param model
* @param newsCategory
* @param imageFile
* @param httpSession
* @return
*/
@PostMapping("newsCategoryEdit")
public String newsCategoryEditPost(Model model,NewsCategory newsCategory, @RequestParam MultipartFile[] imageFile,HttpSession httpSession) {
for (MultipartFile file : imageFile) {
if (file.isEmpty()) {
System.out.println("文件未上传");
} else {
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
Date date = new java.util.Date();
String strDate = sdf.format(date);
String fileName = strDate + file.getOriginalFilename().substring(
file.getOriginalFilename().indexOf("."),
file.getOriginalFilename().length());
String realPath = httpSession.getServletContext().getRealPath("/userfiles");
System.out.println("realPath : "+realPath);
try {
FileUtils.copyInputStreamToFile(file.getInputStream(),new File(realPath, fileName));
newsCategory.setImage("/userfiles/"+fileName);
} catch (IOException e) {
e.printStackTrace();
}
}
}
if(newsCategory.getId()!=0){
newsCategoryService.update(newsCategory);
} else {
newsCategoryService.insert(newsCategory);
}
return "redirect:newsCategoryManage_0_0_0";
}
}
Model层(pure类)
package com.moxi.model;
import java.sql.Date;
public class NewsCategory extends BaseObject {
private long id;
private String name;
private String description;
private String image;
private Date addDate;
private int state;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
public Date getAddDate() {
return addDate;
}
public void setAddDate(Date addDate) {
this.addDate = addDate;
}
public int getState() {
return state;
}
public void setState(int state) {
this.state = state;
}
}
Service层,一切追求极简,所以这里Mybatis用得是注解,我觉得注解也挺好用的。
package com.moxi.service;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.moxi.model.NewsCategory;
@Mapper
public interface NewsCategoryService {
@Select("SELECT * FROM `moxi`.`news_category` where id = #{id};")
NewsCategory findById(NewsCategory newsCategory);
@Select({
"<script>",
"SELECT * FROM `moxi`.`news_category`",
"WHERE state = 0",
"<when test='name!=null'>",
"AND name LIKE CONCAT('%',#{name},'%')",
"</when>",
"order by addDate desc limit #{start},#{end}",
"</script>"
})
List<NewsCategory> list(NewsCategory newsCategory);
@Select({
"<script>",
"SELECT count(*) FROM `moxi`.`news_category`",
"WHERE state = 0",
"<when test='name!=null'>",
"AND name LIKE CONCAT('%',#{name},'%')",
"</when>",
"</script>"
})
int count(NewsCategory newsCategory);
@Insert("INSERT INTO `moxi`.`news_category` (`id`, `name`, `description`, `image`, `addDate`, `state`) VALUES (null, #{name}, #{description}, #{image}, now(), 0);")
int insert(NewsCategory newsCategory);
@Update("UPDATE `moxi`.`news_category`SET `name` = #{name}, `description` = #{description}, `image` = #{image}, `state` = #{state} WHERE `id` = #{id};")
int update(NewsCategory newsCategory);
}
View层,使用的thymeleaf的标签,挺好用的,本来打算全站用ajax,不过开发效率稍微慢了些。
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>MOXI</title>
<link th:href="@{/css/bootstrap.min.css}" rel="stylesheet" />
<link th:href="@{/font-awesome/css/font-awesome.css}" rel="stylesheet" />
<link th:href="@{/css/style.css}" rel="stylesheet" />
<link th:href="@{/css/plugins/iCheck/custom.css}" rel="stylesheet"/>
<link th:href="@{/css/plugins/footable/footable.core.css}" rel="stylesheet"/>
</head>
<body>
<div id="wrapper">
<nav class="navbar-default navbar-static-side" role="navigation" th:include="nav :: navigation"></nav>
<div id="page-wrapper" class="gray-bg">
<div class="border-bottom" th:include="header :: headerTop"></div>
<div class="row wrapper border-bottom white-bg page-heading" th:fragment="headerNav">
<div class="col-lg-10">
<h2>文章分类</h2>
<ol class="breadcrumb">
<li>
<a href="#">首页</a>
</li>
<li>
<a>内容管理</a>
</li>
<li class="active">
<strong>文章分类</strong>
</li>
</ol>
</div>
<div class="col-lg-2">
</div>
</div>
<div class="wrapper wrapper-content animated fadeInRight">
<div class="row">
<div class="col-lg-12">
<div class="ibox float-e-margins">
<div class="ibox-title">
<h5>搜索</h5>
<div class="ibox-tools">
<a class="collapse-link">
<i class="fa fa-chevron-up"></i>
</a>
</div>
</div>
<div class="ibox-content" style="display: block;">
<form action="newsCategoryManage_0_0_0">
<div class="row">
<div class="col-sm-3 m-b-xs">
<input name="name" value="" th:value="${newsCategory.name}" placeholder="分类名称" class="form-control" type="text"/>
</div>
<div class="col-sm-1 m-b-xs">
<button id="submitButton" class="btn btn-primary btn-block" type="submit"><i class="fa fa-search"></i> <strong>搜索</strong></button>
</div>
</div>
</form>
<div class="row">
<div class="col-sm-6 m-b-xs">
<a th:href="@{newsCategoryEdit}" class="btn btn-white btn-sm" data-toggle="tooltip" data-placement="left" title="" data-original-title="Refresh inbox"><i class="fa fa-plus"></i> 新增分类 </a>
</div>
<div class="col-sm-6 m-b-xs"></div>
</div>
</div>
</div>
</div>
<div class="col-lg-12">
<div class="ibox float-e-margins">
<div class="ibox-title">
<h5>文章列表</h5>
<div class="ibox-tools">
<a class="collapse-link">
<i class="fa fa-chevron-up"></i>
</a>
</div>
</div>
<div class="ibox-content">
<div class="table-responsive">
<table class=" table table-hover" data-page-size="10">
<thead>
<tr>
<th width="5%">ID</th>
<th width="30%">名称 </th>
<th width="40%">描述 </th>
<th width="10%">添加时间</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<tr th:each="nc : ${list}">
<td th:text="${nc.id}">Onions</td>
<td th:text="${nc.name}">Onions</td>
<td th:text="${nc.description}">Onions</td>
<td th:text="${nc.addDate}">Onions</td>
<td>
<a th:href="@{'newsCategoryEdit?id='+${nc.id}}" title="修改"><i class="fa fa-edit text-navy"></i></a>
<a th:href="@{'newsCategoryEdit?id='+${nc.id}}" title="修改"><i class="fa fa-trash-o text-navy"></i></a>
</td>
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="7">
<ul id="pageHTML" class="pagination pull-right"></ul>
</td>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="footer" th:include="footer :: copyright"></div>
</div>
</div>
<!-- Mainly scripts -->
<script th:src="@{/js/jquery-2.1.1.js}"></script>
<script th:src="@{/js/bootstrap.min.js}"></script>
<script th:src="@{/js/plugins/metisMenu/jquery.metisMenu.js}"></script>
<script th:src="@{/js/plugins/slimscroll/jquery.slimscroll.min.js}"></script>
<!-- Peity -->
<script th:src="@{/js/plugins/peity/jquery.peity.min.js}"></script>
<!-- Custom and plugin javascript -->
<script th:src="@{/js/inspinia.js}"></script>
<script th:src="@{/js/plugins/pace/pace.min.js}"></script>
<!-- iCheck -->
<script th:src="@{/js/plugins/iCheck/icheck.min.js}"></script>
<!-- Peity -->
<script th:src="@{/js/demo/peity-demo.js}"></script>
<!-- FooTable -->
<script th:src="@{/js/plugins/footable/footable.all.min.js}"></script>
<!-- common -->
<script th:src="@{/js/common.js}"></script>
<script th:inline="javascript">
var pageHTML = [[${pageHTML}]];
$(document).ready(function () {
$("#pageHTML").html(pageHTML);
});
</script>
</body>
</html>
分页封装,一切为了极简,做了个util类
package com.moxi.util;
public class PageUtil {
public static String getPageContent(String url,int pageCurrent,int pageSize,int pageCount){
if (pageCount == 0) {
return "";
}
String urlNew = url.replace("{pageSize}", pageSize+"").replace("{pageCount}", pageCount+"");
String first = urlNew.replace("{pageCurrent}", 1+"");
String prev = urlNew.replace("{pageCurrent}", (pageCurrent - 1)+"");
String next = urlNew.replace("{pageCurrent}", (pageCurrent + 1)+"");
String last = urlNew.replace("{pageCurrent}", pageCount+"");
StringBuffer html = new StringBuffer();
html.append("<li class=\"footable-page-arrow"+(pageCurrent<=1?" disabled":"")+"\"><a href=\""+(pageCurrent<=1?"#":first)+"\">«</a></li>");
html.append("<li class=\"footable-page-arrow"+(pageCurrent<=1?" disabled":"")+"\"><a href=\""+(pageCurrent<=1?"#":prev)+"\">‹</a></li>");
for(int i = 0 ;i < pageCount; i++){
String urlItem = urlNew.replace("{pageCurrent}", (i+1)+"");
html.append("<li class=\"footable-page"+(((i+1) == pageCurrent)?" active":"")+"\"><a href=\""+urlItem+"\">"+(i+1)+"</a></li>");
}
html.append("<li class=\"footable-page-arrow"+(pageCurrent==pageCount?" disabled":"")+"\"><a href=\""+(pageCurrent==pageCount?"#":next)+"\">›</a></li>");
html.append("<li class=\"footable-page-arrow"+(pageCurrent==pageCount?" disabled":"")+"\"><a href=\""+(pageCurrent==pageCount?"#":last)+"\">»</a></li>");
return html.toString().replaceAll("null", "");
}
}
项目下载地址
https://github.com/daleiwang/moxi
就这些,足够简单。包含登录、列表、分页、新增、修改、上传文件等……接下来会不断进行完善。
sql语句放到项目里面了。
Spring Boot(1)工具安装:
http://www.jianshu.com/p/fb6ed37c90eb
Spring Boot(2)新建Spring Boot工程
http://www.jianshu.com/p/00fd73f515f6
Spring Boot(3)整合Mybatis
http://www.jianshu.com/p/8401e9304fa0
Spring Boot(4)整合thymeleaf
http://www.jianshu.com/p/8d2cc7207fb2
Spring Boot(5)一个极简且完整的后台框架
http://www.jianshu.com/p/923d26d705ed
Spring Boot(6)jar方式打包发布
http://www.jianshu.com/p/9cf6faa8595e
Spring Boot(7)war方式打包发布
http://www.jianshu.com/p/ae170a58f88c
SQL语句
-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost Database: moxi
-- ------------------------------------------------------
-- Server version 5.7.17-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admin`
--
DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
`realName` varchar(45) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`phoneNumber` varchar(45) DEFAULT NULL,
`headPicture` varchar(45) DEFAULT NULL,
`addDate` date DEFAULT NULL,
`updateDate` date DEFAULT NULL,
`state` int(11) DEFAULT '0' COMMENT '1:正常\n2:冻结\n3:删除',
PRIMARY KEY (`id`),
UNIQUE KEY `name_UNIQUE` (`userName`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin`
--
LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'admin','admin','面皮大师',28,'17788886666','','2017-06-15','2017-06-15',1);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(45) NOT NULL,
`description` varchar(45) DEFAULT NULL,
`category` int(11) DEFAULT NULL,
`image` varchar(45) DEFAULT NULL,
`content` mediumtext,
`addDate` datetime DEFAULT NULL,
`updateDate` datetime DEFAULT NULL,
`state` int(11) DEFAULT NULL COMMENT '1,正常\n2,删除',
`commendState` int(11) DEFAULT NULL COMMENT '1,正常\n2,推荐',
`browses` int(11) DEFAULT NULL COMMENT '浏览数',
`likes` int(11) DEFAULT NULL COMMENT '喜欢数',
`comments` int(11) DEFAULT NULL COMMENT '回复数',
`score` int(11) DEFAULT NULL COMMENT '分数,用于排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
--
LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'科技是第一生产力1','科技是第一生产力',2,NULL,'<p>科技是第一生产力<br></p>','2017-06-15 19:15:04','2017-06-15 19:15:04',1,1,0,0,0,0),(2,'科技是第一生产力2','科技是第一生产力2',2,'','科技是第一生产力2','2017-06-15 19:17:10','2017-06-15 19:17:10',1,1,0,0,0,0),(3,'科技是第一生产力3','科技是第一生产力3',2,'','科技是第一生产力3','2017-06-15 19:17:31','2017-06-15 19:17:31',1,1,0,0,0,0),(4,'科技是第一生产力4','科技是第一生产力4',2,'','科技是第一生产力4','2017-06-15 19:17:50','2017-06-15 19:17:50',1,1,0,0,0,0),(5,'科技是第一生产力5','科技是第一生产力5',2,'','科技是第一生产力5','2017-06-15 19:17:57','2017-06-15 19:17:57',1,1,0,0,0,0),(6,'科技是第一生产力6','科技是第一生产力6',2,'','科技是第一生产力6','2017-06-15 19:18:02','2017-06-15 19:18:02',1,1,0,0,0,0),(7,'科技是第一生产力7','科技是第一生产力7',2,'','科技是第一生产力7','2017-06-15 19:18:06','2017-06-15 19:18:06',1,1,0,0,0,0),(8,'科技是第一生产力8','科技是第一生产力8',2,'','科技是第一生产力8','2017-06-15 19:18:10','2017-06-15 19:18:10',1,1,0,0,0,0),(9,'科技是第一生产力9','科技是第一生产力9',2,'','科技是第一生产力9','2017-06-15 19:18:21','2017-06-15 19:18:21',1,1,0,0,0,0),(10,'科技是第一生产力10','科技是第一生产力10',2,'','科技是第一生产力10','2017-06-15 19:18:30','2017-06-15 19:18:30',1,1,0,0,0,0),(11,'财经天下1','财经天下1',1,'','财经天下1','2017-06-15 19:19:13','2017-06-15 19:19:13',1,1,0,0,0,0),(12,'财经天下2','财经天下2',1,'','财经天下2','2017-06-15 19:19:19','2017-06-15 19:19:19',1,1,0,0,0,0),(13,'财经天下3','财经天下3',1,'','财经天下3','2017-06-15 19:19:23','2017-06-15 19:19:23',1,2,0,0,0,0),(14,'财经天下4','财经天下4',1,'','财经天下4','2017-06-15 19:19:27','2017-06-15 19:19:27',1,1,0,0,0,0),(15,'财经天下5','财经天下5',1,'','财经天下5','2017-06-15 19:19:31','2017-06-15 19:19:31',1,1,0,0,0,0),(16,'财经天下6','财经天下6',1,'','财经天下6','2017-06-15 19:19:34','2017-06-15 19:19:34',1,1,0,0,0,0),(17,'财经天下7','财经天下7',1,'','财经天下7','2017-06-15 19:19:38','2017-06-15 19:19:38',2,2,0,0,0,0),(18,'财经天下8','财经天下8',1,'','财经天下8','2017-06-15 19:19:42','2017-06-15 19:19:42',1,1,0,0,0,0),(19,'财经天下9','财经天下9',1,'','财经天下9','2017-06-15 19:19:45','2017-06-15 19:19:45',1,1,0,0,0,0),(20,'财经天下10','财经天下10',1,'','财经天下10','2017-06-15 19:19:53','2017-06-15 19:19:53',1,2,0,0,0,0),(21,'体育人生1','体育人生1',3,'','体育人生1','2017-06-15 19:20:55','2017-06-15 19:20:55',1,2,0,0,0,0),(22,'体育人生2','体育人生2',3,'','体育人生2','2017-06-15 19:21:03','2017-06-15 19:21:03',2,1,0,0,0,0),(23,'体育人生3','体育人生3',3,'','体育人生3','2017-06-15 19:21:07','2017-06-15 19:21:07',2,2,0,0,0,0),(24,'体育人生4','体育人生4',3,'','体育人生4','2017-06-15 19:21:11','2017-06-15 19:21:11',2,1,0,0,0,0),(25,'体育人生5','体育人生5',3,'','体育人生5','2017-06-15 19:21:14','2017-06-15 19:21:14',2,2,0,0,0,0),(26,'特泰尼克号update','一个美好的故事update',3,'/userfiles/20170704160534_351.png','<p>一个美好的故事update<br></p>','2017-07-04 11:11:18','2017-07-04 16:05:34',2,2,11,12,15,111),(27,'张学友芜湖演唱会','张学友芜湖演唱会一票难求',5,'/userfiles/20170704143344_119.png','<div class=\"container content\"> <h3 class=\"text-center\">云堆微软文分发介绍</h3> <p class=\"text-center\">自媒体真实流量分发 · 品效合一</p> <img src=\"http://www.yunduimedia.com/imgs/weixin/weixin01_89df947.png\" width=\"992\" height=\"369\"> </div> <h3>云堆投放优势</h3> <img src=\"http://www.yunduimedia.com/imgs/weixin/weixin02_ed2c3a3.png\" width=\"992\" height=\"340\">','2017-07-04 14:33:44','2017-07-04 14:33:44',2,1,0,0,0,0),(28,'','',0,'','','2017-07-05 11:35:19','2017-07-05 11:35:19',2,1,0,0,0,0),(29,'标题','',1,'','<p><br></p>','2017-07-05 11:46:14','2017-07-05 14:03:27',1,1,0,0,0,0);
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_category`
--
DROP TABLE IF EXISTS `news_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`description` varchar(45) DEFAULT NULL,
`image` varchar(45) DEFAULT NULL,
`addDate` datetime DEFAULT NULL,
`state` int(11) DEFAULT NULL COMMENT '1,正常\n2,删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_category`
--
LOCK TABLES `news_category` WRITE;
/*!40000 ALTER TABLE `news_category` DISABLE KEYS */;
INSERT INTO `news_category` VALUES (1,'财经','财经','','2017-06-15 18:59:37',1),(2,'科技','科技','','2017-06-15 18:59:46',1),(3,'体育','体育','','2017-06-15 18:59:55',1),(4,'人文','人文','','2017-06-15 19:00:06',2),(5,'娱乐','娱乐八卦','/userfiles/20170704110957.png','2017-07-04 11:09:57',2),(6,'历史','历史文学','/userfiles/20170705113505.png','2017-07-05 11:34:31',1);
/*!40000 ALTER TABLE `news_category` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-07-05 14:23:39