CREATE DATABASE IF NOT EXISTS `blog` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `blog`;
-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost Database: blog
-- ------------------------------------------------------
-- Server version5.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 `about`
--
DROP TABLE IF EXISTS `about`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `about` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(80) NOT NULL,
`content` mediumtext NOT NULL,
`time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`amountOfReading` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `about`
--
LOCK TABLES `about` WRITE;
/*!40000 ALTER TABLE `about` DISABLE KEYS */;
INSERT INTO `about` VALUES (1,'关于','诸葛亮于汉灵帝光和四年(181年)出生在琅琊郡阳都县的一个官吏之家,诸葛氏是琅琊的望族,先祖诸葛丰曾在西汉元帝时做过司隶校尉,诸葛亮的父亲诸葛珪在东汉末年做过泰山郡丞; [2] 诸葛亮3岁时母亲章氏病逝,诸葛亮8岁时丧父,与弟弟诸葛均一起跟随由袁术任命为豫章太守的叔父诸葛玄到豫章(今江西南昌)赴任,东汉朝廷派朱皓取代了诸葛玄职务,诸葛玄就去投奔荆州刘表。','2020-02-20 07:09:51',3),(3,'关于','这是一个简单的个人博客。\r\n该博客是基于spring boot框架开发。整合了themeleaf模板引擎和mybatis。\r\n该博客系统本人会公开代码供各位学习。\r\n作者:唔冇名','2020-07-01 01:16:05',40),(4,'20180407430125 廖嘉华','20180407430125 廖嘉华','2020-06-29 14:39:37',7);
/*!40000 ALTER TABLE `about` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `blog`
--
DROP TABLE IF EXISTS `blog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog` (
`blogId` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(80) NOT NULL,
`edits` mediumtext NOT NULL,
`blogStatus` int(11) NOT NULL,
`time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`amountOfReading` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`blogId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `blog`
--
LOCK TABLES `blog` WRITE;
/*!40000 ALTER TABLE `blog` DISABLE KEYS */;
INSERT INTO `blog` VALUES (1,'SSM框架整合笔记','# SSM框架学习笔记\r\n\r\nSSM(Spring+SpringMVC+MyBatis)框架集由Spring、MyBatis两个开源框架整合而成(SpringMVC是Spring中的部分内容)。常作为数据源较简单的web项目的框架。\r\n\r\n## SSM框架配置过程\r\n 1. 新建Maven项目,添加依赖和资源过滤,添加web支持\r\n 2. 搭建项目的基本结构:\r\n com.\\*\\*.contorller\r\n com.\\*\\*.service\r\n com.\\*\\*.pojo\r\n com.\\*\\*.dao\r\n com.\\*\\*.interceptor(拦截器层)\r\n 3. 配置mybatis-config.xml\r\n 4. 配置applicationContext.xml\r\n 5. 配置database.properties\r\n 6. IDEA关联database\r\n 7. 配置database.properties\r\n 8. 新建实体类\r\n 9. 编写dao层的mapper接口\r\n 10. 编写dao层的mapper.xml文件\r\n 11. 编写service的接口并实现\r\n 12. 配置spring-dao.xml\r\n 13. 配置spring-service.xml\r\n 14. 配置spring-mvc.xml\r\n 15. 配置web.xml\r\n 16. 编写contorller层的代码和一些jsp文件\r\n \r\n\r\n\r\nPS:要在Project Structure中的WEB-INF新建一个lib文件夹,在文件中添加相关jar包(不然会报错)\r\n\r\n## mybatis-config.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\nr\n PUBLIC \"-//mybatis.org//DTD Config 3.0//EN\"\r\n \"http://mybatis.org/dtd/mybatis-3-config.dtd\">\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n```\r\n## **Mapper.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\nr\n PUBLIC \"-//mybatis.org//DTD Config 3.0//EN\"\r\n \"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n```\r\n\r\n## database.properties\r\n\r\n```\r\njdbc.driver=com.mysql.jdbc.Driver\r\njdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT\r\njdbc.username=***\r\njdbc.password=***\r\n```\r\n\r\n## spring-dao.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n```\r\n\r\n## spring-service.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n```\r\n\r\n## spring-mvc.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n```\r\n## applicationContext.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n\r\n \r\n \r\n \r\n\r\n```\r\n## web.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n\r\n \r\n \r\n dispatcherServlet\r\n org.springframework.web.servlet.DispatcherServlet\r\n \r\n contextConfigLocation\r\n classpath:applicationContext.xml\r\n \r\n 1\r\n \r\n \r\n dispatcherServlet\r\n /\r\n \r\n\r\n \r\n \r\n encodingFilter\r\n \r\n org.springframework.web.filter.CharacterEncodingFilter\r\n \r\n \r\n encoding\r\n utf-8\r\n \r\n \r\n \r\n encodingFilter\r\n /*\r\n \r\n\r\n \r\n \r\n 15\r\n \r\n\r\n\r\n```\r\n## 相关的pom依赖以及Maven资源过滤设置\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n 4.0.0\r\n\r\n com.kuang\r\n ssmbuild\r\n 1.0-SNAPSHOT\r\n\r\n \r\n \r\n \r\n junit\r\n junit\r\n 4.12\r\n \r\n \r\n \r\n mysql\r\n mysql-connector-java\r\n 5.1.47\r\n \r\n \r\n \r\n com.mchange\r\n c3p0\r\n 0.9.5.2\r\n \r\n\r\n \r\n \r\n javax.servlet\r\n servlet-api\r\n 2.5\r\n \r\n \r\n javax.servlet.jsp\r\n jsp-api\r\n 2.2\r\n \r\n \r\n javax.servlet\r\n jstl\r\n 1.2\r\n \r\n\r\n \r\n \r\n org.mybatis\r\n mybatis\r\n 3.5.2\r\n \r\n \r\n org.mybatis\r\n mybatis-spring\r\n 2.0.2\r\n \r\n\r\n \r\n \r\n org.springframework\r\n spring-webmvc\r\n 5.1.9.RELEASE\r\n \r\n \r\n org.springframework\r\n spring-jdbc\r\n 5.1.9.RELEASE\r\n \r\n\r\n\r\n \r\n org.projectlombok\r\n lombok\r\n 1.16.10\r\n \r\n \r\n \r\n com.google.code.gson\r\n gson\r\n 2.8.6\r\n \r\n \r\n\r\n \r\n \r\n \r\n src/main/java\r\n \r\n **/*.properties\r\n **/*.xml\r\n \r\n false\r\n \r\n \r\n src/main/resources\r\n \r\n **/*.properties\r\n **/*.xml\r\n \r\n false\r\n \r\n \r\n \r\n\r\n\r\n\r\n```\r\n## 一些小问题\r\n\r\n - 静态资源要放在web/stastics文件夹下\r\n - jsp文件要放在WEB-INF/jsp文件夹下,index.jsp除外\r\n - **记住一定要为WEB-INF下的lib添加相关的jar包**\r\n - 如果修改或添加静态资源后确定静态资源的加载路径没有错的情况下还出现静态资源加载出错,就尝试重启一下IDEA\r\n - ajax的中文返回值乱码问题可以尝试用@RequestMapping(value = \"**\",produces = \"text/html;charset=UTF-8\")注解解决\r\n - 常用注解有:@Controller、@RequestMapping、@ResponseBody、@Autowired、@Qualifier\r\n - 新建的jsp文件记得添加\r\n - lombok需要下载插件才能使用\r\n \r\n\r\n参考至https://blog.kuangstudy.com/index.php/archives/487/',1,'2020-02-20 08:45:32',34),(3,'Tools','[TOC]\r\n\r\n#### Disabled options\r\n\r\n- TeX (Based on KaTeX);\r\n- Emoji;\r\n- Task lists;\r\n- HTML tags decode;\r\n- Flowchart and Sequence Diagram;\r\n\r\n#### Editor.md directory\r\n\r\n editor.md/\r\n lib/\r\n css/\r\n scss/\r\n tests/\r\n fonts/\r\n images/\r\n plugins/\r\n examples/\r\n languages/ \r\n editormd.js\r\n ...\r\n\r\n```html\r\n<!-- English -->\r\n<script src=\"../dist/js/languages/en.js\"></script>\r\n\r\n<!-- 繁體中文 -->\r\n<script src=\"../dist/js/languages/zh-tw.js\"></script>\r\n```\r\n![](http://localhost:8080/images/2020/11/23/2e66ebf823c843c6afa93d7d8a87adcf.jpg)',0,'2020-11-23 12:04:23',1),(7,'js POST提交的两种方式','# 第一种提交post的方式是传统方式,判断浏览器进行post请求。\r\n\r\n \r\n \r\n