Spring Boot&Spring CloudspringbootSpring

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

上一篇下一篇

猜你喜欢

热点阅读