README.md · huzhiyuan0215/云网盘项目

# 数据库

```
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 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 `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\n<!DOCTYPE configuration\r\n        PUBLIC \"-//mybatis.org//DTD Config 3.0//EN\"\r\n        \"http://mybatis.org/dtd/mybatis-3-config.dtd\">\r\n<configuration>\r\n    <typeAliases>\r\n        <package name=\"com.**.pojo\"/>\r\n    </typeAliases>\r\n    <mappers>\r\n        <mapper resource=\"com/**/dao/**Mapper.xml\"/>\r\n        <mapper resource=\"com/**/dao/**Mapper.xml\"/>\r\n    </mappers>\r\n\r\n</configuration>\r\n```\r\n## **Mapper.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE mapper\r\n        PUBLIC \"-//mybatis.org//DTD Config 3.0//EN\"\r\n        \"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">\r\n<mapper namespace=\"com.kuang.dao.**Mapper\">\r\n    <insert>\r\n        \r\n    </insert>\r\n    <delete>\r\n        \r\n    </delete>\r\n    <update>\r\n      \r\n    </update>\r\n    <select>\r\n        \r\n    </select>\r\n</mapper>\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<beans xmlns=\"http://www.springframework.org/schema/beans\"\r\n       xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n       xmlns:context=\"http://www.springframework.org/schema/context\"\r\n       xsi:schemaLocation=\"http://www.springframework.org/schema/beans\r\nhttp://www.springframework.org/schema/beans/spring-beans.xsd\r\nhttp://www.springframework.org/schema/context\r\nhttps://www.springframework.org/schema/context/spring-context.xsd\">\r\n\r\n    \r\n    \r\n    <context:property-placeholder location=\"classpath:database.properties\"/>\r\n\r\n    \r\n    \r\n    <bean id=\"dataSource\" class=\"com.mchange.v2.c3p0.ComboPooledDataSource\">\r\n        \r\n        <property name=\"driverClass\" value=\"${jdbc.driver}\"/>\r\n        <property name=\"jdbcUrl\" value=\"${jdbc.url}\"/>\r\n        <property name=\"user\" value=\"${jdbc.username}\"/>\r\n        <property name=\"password\" value=\"${jdbc.password}\"/>\r\n\r\n        \r\n        <property name=\"maxPoolSize\" value=\"30\"/>\r\n        <property name=\"minPoolSize\" value=\"10\"/>\r\n        \r\n        <property name=\"autoCommitOnClose\" value=\"false\"/>\r\n        \r\n        <property name=\"checkoutTimeout\" value=\"10000\"/>\r\n        \r\n        <property name=\"acquireRetryAttempts\" value=\"2\"/>\r\n    </bean>\r\n\r\n    \r\n    <bean id=\"sqlSessionFactory\" class=\"org.mybatis.spring.SqlSessionFactoryBean\">\r\n        \r\n        <property name=\"dataSource\" ref=\"dataSource\"/>\r\n        \r\n        <property name=\"configLocation\" value=\"classpath:mybatis-config.xml\"/>\r\n    </bean>\r\n\r\n    \r\n    \r\n    <bean class=\"org.mybatis.spring.mapper.MapperScannerConfigurer\">\r\n        \r\n        <property name=\"sqlSessionFactoryBeanName\" value=\"sqlSessionFactory\"/>\r\n        \r\n        <property name=\"basePackage\" value=\"com.**.dao\"/>\r\n    </bean>\r\n\r\n</beans>\r\n```\r\n\r\n## spring-service.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<beans xmlns=\"http://www.springframework.org/schema/beans\"\r\n       xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n       xmlns:context=\"http://www.springframework.org/schema/context\"\r\n       xsi:schemaLocation=\"http://www.springframework.org/schema/beans\r\n    http://www.springframework.org/schema/beans/spring-beans.xsd\r\n    http://www.springframework.org/schema/context\r\n    http://www.springframework.org/schema/context/spring-context.xsd\">\r\n\r\n    \r\n    <context:component-scan base-package=\"com.**.service\" />\r\n\r\n    \r\n    <bean id=\"**ServiceImpl\" class=\"com.**.service.**ServiceImpl\">\r\n        <property name=\"**Mapper\" ref=\"**Mapper\"/>\r\n    </bean>\r\n\r\n    \r\n    <bean id=\"transactionManager\" class=\"org.springframework.jdbc.datasource.DataSourceTransactionManager\">\r\n        \r\n        <property name=\"dataSource\" ref=\"dataSource\" />\r\n    </bean>\r\n\r\n</beans>\r\n```\r\n\r\n## spring-mvc.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<beans xmlns=\"http://www.springframework.org/schema/beans\"\r\n       xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n       xmlns:context=\"http://www.springframework.org/schema/context\"\r\n       xmlns:mvc=\"http://www.springframework.org/schema/mvc\"\r\n       xsi:schemaLocation=\"http://www.springframework.org/schema/beans\r\n    http://www.springframework.org/schema/beans/spring-beans.xsd\r\n    http://www.springframework.org/schema/context\r\n    http://www.springframework.org/schema/context/spring-context.xsd\r\n    http://www.springframework.org/schema/mvc\r\n    https://www.springframework.org/schema/mvc/spring-mvc.xsd\">\r\n\r\n    \r\n    \r\n    <mvc:annotation-driven />\r\n    \r\n    <mvc:default-servlet-handler/>\r\n    <mvc:resources location=\"/statics/js/\" mapping=\"/js/**\"/>\r\n    <mvc:resources location=\"/statics/css/\" mapping=\"/css/**\"/>\r\n\r\n    \r\n    <bean class=\"org.springframework.web.servlet.view.InternalResourceViewResolver\">\r\n        <property name=\"viewClass\" value=\"org.springframework.web.servlet.view.JstlView\" />\r\n        <property name=\"prefix\" value=\"/WEB-INF/jsp/\" />\r\n        <property name=\"suffix\" value=\".jsp\" />\r\n    </bean>\r\n\r\n    \r\n    <context:component-scan base-package=\"com.kuang.controller\" />\r\n    \r\n    <mvc:interceptors>\r\n        <mvc:interceptor>\r\n            \r\n            \r\n            \r\n            <mvc:mapping path=\"/**\"/>\r\n            \r\n            <bean class=\"com.**.interceptor.**Interceptor\"/>\r\n        </mvc:interceptor>\r\n    </mvc:interceptors>\r\n\r\n</beans>\r\n```\r\n## applicationContext.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<beans xmlns=\"http://www.springframework.org/schema/beans\"\r\n       xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n       xsi:schemaLocation=\"http://www.springframework.org/schema/beans\r\n        http://www.springframework.org/schema/beans/spring-beans.xsd\">\r\n\r\n    <import resource=\"classpath:spring-dao.xml\"/>\r\n    <import resource=\"classpath:spring-service.xml\"/>\r\n    <import resource=\"classpath:spring-mvc.xml\"/>\r\n</beans>\r\n```\r\n## web.xml\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<web-app xmlns=\"http://xmlns.jcp.org/xml/ns/javaee\"\r\n         xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n         xsi:schemaLocation=\"http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd\"\r\n         version=\"4.0\">\r\n\r\n    \r\n    <servlet>\r\n        <servlet-name>dispatcherServlet</servlet-name>\r\n        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>\r\n        <init-param>\r\n            <param-name>contextConfigLocation</param-name>\r\n            <param-value>classpath:applicationContext.xml</param-value>\r\n        </init-param>\r\n        <load-on-startup>1</load-on-startup>\r\n    </servlet>\r\n    <servlet-mapping>\r\n        <servlet-name>dispatcherServlet</servlet-name>\r\n        <url-pattern>/</url-pattern>\r\n    </servlet-mapping>\r\n\r\n    \r\n    <filter>\r\n        <filter-name>encodingFilter</filter-name>\r\n        <filter-class>\r\n            org.springframework.web.filter.CharacterEncodingFilter\r\n        </filter-class>\r\n        <init-param>\r\n            <param-name>encoding</param-name>\r\n            <param-value>utf-8</param-value>\r\n        </init-param>\r\n    </filter>\r\n    <filter-mapping>\r\n        <filter-name>encodingFilter</filter-name>\r\n        <url-pattern>/*</url-pattern>\r\n    </filter-mapping>\r\n\r\n    \r\n    <session-config>\r\n        <session-timeout>15</session-timeout>\r\n    </session-config>\r\n\r\n</web-app>\r\n```\r\n## 相关的pom依赖以及Maven资源过滤设置\r\n\r\n```\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<project xmlns=\"http://maven.apache.org/POM/4.0.0\"\r\n         xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\r\n         xsi:schemaLocation=\"http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd\">\r\n    <modelVersion>4.0.0</modelVersion>\r\n\r\n    <groupId>com.kuang</groupId>\r\n    <artifactId>ssmbuild</artifactId>\r\n    <version>1.0-SNAPSHOT</version>\r\n\r\n    <dependencies>\r\n        \r\n        <dependency>\r\n            <groupId>junit</groupId>\r\n            <artifactId>junit</artifactId>\r\n            <version>4.12</version>\r\n        </dependency>\r\n        \r\n        <dependency>\r\n            <groupId>mysql</groupId>\r\n            <artifactId>mysql-connector-java</artifactId>\r\n            <version>5.1.47</version>\r\n        </dependency>\r\n        \r\n        <dependency>\r\n            <groupId>com.mchange</groupId>\r\n            <artifactId>c3p0</artifactId>\r\n            <version>0.9.5.2</version>\r\n        </dependency>\r\n\r\n        \r\n        <dependency>\r\n            <groupId>javax.servlet</groupId>\r\n            <artifactId>servlet-api</artifactId>\r\n            <version>2.5</version>\r\n        </dependency>\r\n        <dependency>\r\n            <groupId>javax.servlet.jsp</groupId>\r\n            <artifactId>jsp-api</artifactId>\r\n            <version>2.2</version>\r\n        </dependency>\r\n        <dependency>\r\n            <groupId>javax.servlet</groupId>\r\n            <artifactId>jstl</artifactId>\r\n            <version>1.2</version>\r\n        </dependency>\r\n\r\n        \r\n        <dependency>\r\n            <groupId>org.mybatis</groupId>\r\n            <artifactId>mybatis</artifactId>\r\n            <version>3.5.2</version>\r\n        </dependency>\r\n        <dependency>\r\n            <groupId>org.mybatis</groupId>\r\n            <artifactId>mybatis-spring</artifactId>\r\n            <version>2.0.2</version>\r\n        </dependency>\r\n\r\n        \r\n        <dependency>\r\n            <groupId>org.springframework</groupId>\r\n            <artifactId>spring-webmvc</artifactId>\r\n            <version>5.1.9.RELEASE</version>\r\n        </dependency>\r\n        <dependency>\r\n            <groupId>org.springframework</groupId>\r\n            <artifactId>spring-jdbc</artifactId>\r\n            <version>5.1.9.RELEASE</version>\r\n        </dependency>\r\n\r\n\r\n        <dependency>\r\n            <groupId>org.projectlombok</groupId>\r\n            <artifactId>lombok</artifactId>\r\n            <version>1.16.10</version>\r\n        </dependency>\r\n        \r\n        <dependency>\r\n            <groupId>com.google.code.gson</groupId>\r\n            <artifactId>gson</artifactId>\r\n            <version>2.8.6</version>\r\n        </dependency>\r\n    </dependencies>\r\n\r\n    <build>\r\n        <resources>\r\n            <resource>\r\n                <directory>src/main/java</directory>\r\n                <includes>\r\n                    <include>**/*.properties</include>\r\n                    <include>**/*.xml</include>\r\n                </includes>\r\n                <filtering>false</filtering>\r\n            </resource>\r\n            <resource>\r\n                <directory>src/main/resources</directory>\r\n                <includes>\r\n                    <include>**/*.properties</include>\r\n                    <include>**/*.xml</include>\r\n                </includes>\r\n                <filtering>false</filtering>\r\n            </resource>\r\n        </resources>\r\n    </build>\r\n\r\n\r\n</project>\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文件记得添加<%@ taglib prefix=\"c\" uri=\"http://java.sun.com/jsp/jstl/core\" %>\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&lt;!-- English --&gt;\r\n&lt;script src=\"../dist/js/languages/en.js\"&gt;&lt;/script&gt;\r\n\r\n&lt;!-- 繁體中文 --&gt;\r\n&lt;script src=\"../dist/js/languages/zh-tw.js\"&gt;&lt;/script&gt;\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    <SCRIPT stype=text/javascript>\r\n    var xmlobj; //定义XMLHttpRequest对象\r\n    function CreateXMLHttpRequest()\r\n    {\r\n    if(window.ActiveXObject)\r\n    //如果当前浏览器支持Active Xobject，则创建ActiveXObject对象\r\n    {\r\n      //xmlobj = new ActiveXObject(\"Microsoft.XMLHTTP\");\r\n      try {\r\n          xmlobj = new ActiveXObject(\"Msxml2.XMLHTTP\");\r\n          } catch (e) {\r\n         try {\r\n           xmlobj = new ActiveXObject(\"Microsoft.XMLHTTP\");\r\n            } catch (E) {\r\n              xmlobj = false;\r\n             }\r\n            }\r\n           }\r\n    else if(window.XMLHttpRequest)\r\n    //如果当前浏览器支持XMLHttp Request，则创建XMLHttpRequest对象\r\n    {\r\n      xmlobj = new XMLHttpRequest();\r\n    }\r\n    }\r\n    function SubmitArticle(act,cityname,antique) //主程序函数\r\n    {\r\n      CreateXMLHttpRequest(); //创建对象\r\n      //var parm = \"act=firstweather\" ;//构造URL参数\r\n      //antique = escape(antique);\r\n      var parm = \"act=\" + act + \"&cityname=\" + cityname + \"&antique=\" + antique;//构造URL参数\r\n      //xmlobj.open(\"POST\", \"{dede:global.cfg_templeturl/}/../include/weather.php\", true); //调用weather.php\r\n      xmlobj.open(\"POST\", \"/weather/include/weather.php\", true); //调用weather.php\r\n      xmlobj.setRequestHeader(\"cache-control\",\"no-cache\");\r\n      xmlobj.setRequestHeader(\"contentType\",\"text/html;charset=uft-8\") //指定发送的编码\r\n      xmlobj.setRequestHeader(\"Content-Type\", \"application/x-www-form-urlencoded;\");  //设置请求头信息\r\n      xmlobj.onreadystatechange = StatHandler;  //判断URL调用的状态值并处理\r\n      xmlobj.send(parm); //设置为发送给服务器数据\r\n    }\r\n	\r\n# 第二种方式则是虚拟表单的形式提交post请求。\r\n\r\n    function post(URL, PARAMS) {\r\n      var temp = document.createElement(\"form\");\r\n      temp.action = URL;\r\n      temp.method = \"post\";\r\n      temp.style.display = \"none\";\r\n      for (var x in PARAMS) {\r\n        var opt = document.createElement(\"textarea\");\r\n        opt.name = x;\r\n        opt.value = PARAMS[x];\r\n        // alert(opt.name)\r\n        temp.appendChild(opt);\r\n      }\r\n      document.body.appendChild(temp);\r\n      temp.submit();\r\n      return temp;\r\n    }\r\n    调用方法 如：\r\n    代码如下:\r\n      post(\'pages/statisticsJsp/excel.action\',{html:prnhtml,cm1:\'sdsddsd\',cm2:\'haha\'});',1,'2020-04-18 19:07:03',6),(8,'spring boot实现QQ邮箱验证码','#### 导入依赖\r\n    <dependency>\r\n                <groupId>org.springframework.boot</groupId>\r\n                <artifactId>spring-boot-starter-mail</artifactId>\r\n    </dependency>\r\n	\r\n#### appcation.properties导入邮件相关配置\r\n\r\n    spring.mail.username=*********@qq.com\r\n    spring.mail.password=**********\r\n    spring.mail.host=smtp.qq.com\r\n    spring.mail.properties.mail.smtp.ssl.enable=true\r\n	\r\n- spring.mail.password的获取方法\r\n![](http://39.97.179.225:8080/HuaCloudDisk/adminupload/f4c18597a857d8a6aed70e4e33b728c.png)\r\n\r\n![](http://39.97.179.225:8080/HuaCloudDisk/adminupload/15096ac57017c72d8aea55070b61236.png)\r\n\r\n\r\n#### 发送邮件的接口\r\n\r\n    package com.ljh.service;\r\n    \r\n    interface SendMail {\r\n        //发送邮件验证码接口\r\n        int sendMail(String address,String code);\r\n    }\r\n    \r\n	\r\n#### 实现接口\r\n\r\n    package com.ljh.service;\r\n    \r\n    import org.springframework.beans.factory.annotation.Autowired;\r\n    import org.springframework.mail.SimpleMailMessage;\r\n    import org.springframework.mail.javamail.JavaMailSender;\r\n    import org.springframework.stereotype.Service;\r\n    \r\n    @Service\r\n    public class SendMailImpl implements SendMail {\r\n        @Autowired\r\n        JavaMailSender javaMailSender;\r\n        @Override\r\n        public int sendMail(String address,String code) {\r\n            //创建简单邮件对象\r\n            SimpleMailMessage simpleMailMessage=new SimpleMailMessage();\r\n            //标题\r\n            simpleMailMessage.setSubject(\"邮件验证码\");\r\n            //内容\r\n            simpleMailMessage.setText(code);\r\n            //发送地址\r\n            simpleMailMessage.setTo(address);\r\n            //邮件来源地址\r\n            simpleMailMessage.setFrom(\"1985113163@qq.com\");\r\n            //发送邮件\r\n            javaMailSender.send(simpleMailMessage);\r\n            return 0;\r\n        }\r\n    }\r\n    \r\n	\r\n#### controller控制层调用服务\r\n\r\n    package com.ljh.controller;\r\n    \r\n    import com.ljh.service.SendMailImpl;\r\n    import org.springframework.beans.factory.annotation.Autowired;\r\n    import org.springframework.scheduling.annotation.Async;\r\n    import org.springframework.stereotype.Controller;\r\n    import org.springframework.web.bind.annotation.RequestMapping;\r\n    import org.springframework.web.bind.annotation.ResponseBody;\r\n    \r\n    import javax.servlet.http.HttpServletRequest;\r\n    import javax.servlet.http.HttpSession;\r\n    import java.util.Random;\r\n    import java.util.Timer;\r\n    import java.util.TimerTask;\r\n    \r\n    @Controller\r\n    public class SendMailController {\r\n        @Autowired\r\n        private SendMailImpl sendMail;\r\n        @RequestMapping(\"mail\")\r\n        @ResponseBody\r\n        public void mail(String address, HttpServletRequest httpServletRequest) {\r\n            //用Random生成五位验证码，random.nextInt(范围值)+初始下标值\r\n            Random random=new Random();\r\n            int code=random.nextInt(89999)+10000;\r\n            //将邮箱地址和验证码放入session中进行验证登陆\r\n            if(httpServletRequest.getSession().getAttribute(\"code\")!=null){\r\n                httpServletRequest.getSession().removeAttribute(\"address\");\r\n                httpServletRequest.getSession().removeAttribute(\"code\");\r\n            }\r\n            httpServletRequest.getSession().setAttribute(\"address\",address);\r\n            httpServletRequest.getSession().setAttribute(\"code\",Integer.toString(code));\r\n            //发送邮件\r\n            sendMail.sendMail(address,Integer.toString(code));\r\n            //用线程设置验证码过期时间\r\n            final Timer timer=new Timer();\r\n            final HttpSession httpSession=httpServletRequest.getSession();\r\n            timer.schedule(new TimerTask() {\r\n                @Override\r\n                public void run() {\r\n                    try {\r\n                        httpSession.removeAttribute(\"code\");\r\n                        System.out.println(\"验证码失效\");\r\n                        timer.cancel();\r\n                    } catch (Exception e) {\r\n                        System.out.println(\"找不到session，验证码失效\");\r\n                    }\r\n                }\r\n            },5*60*1000);\r\n        }\r\n        @RequestMapping(\"/go\")\r\n        public String go(String address,String code,HttpServletRequest httpServletRequest){\r\n            try {\r\n                //验证码验证登陆\r\n                if(httpServletRequest.getSession().getAttribute(\"address\").toString().equals(address)&&httpServletRequest.getSession().getAttribute(\"code\").toString().equals(code)){\r\n                    //成功登陆后让验证码失效\r\n                    httpServletRequest.getSession().removeAttribute(\"code\");\r\n                    return \"success\";\r\n                }else {\r\n                    return \"redirect:/toIndex\";\r\n                }\r\n            } catch (Exception e) {\r\n                return \"redirect:/toIndex\";\r\n            }\r\n        }\r\n        @RequestMapping(\"/toIndex\")\r\n        public String toIndex(){\r\n            return \"index\";\r\n        }\r\n    }\r\n    \r\n	\r\n#### 前端用ajax调用controller接口（以下代码使用了thymeleaf模板引擎）\r\n\r\n    <!DOCTYPE html>\r\n    <html lang=\"en\" xmlns:th=\"http://www.w3.org/1999/xhtml\">\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>Title</title>\r\n    </head>\r\n    <body>\r\n    <form method=\"post\" th:action=\"@{/go}\">\r\n        <input name=\"address\" type=\"text\" id=\"address\">\r\n        <input type=\"text\" name=\"code\">\r\n        <button type=\"button\" th:onclick=\"send()\">邮件发送</button>\r\n        <button type=\"submit\">提交</button>\r\n    </form>\r\n    <script\r\n            th:src=\"@{https://code.jquery.com/jquery-3.5.1.js}\"\r\n            integrity=\"sha256-QWo7LDvxbWT2tbbQ97B53yJnYU3WhH/C8ycbRAkjPDc=\"\r\n            crossorigin=\"anonymous\"></script>\r\n    <script th:inline=\"javascript\">\r\n        /*<![CDATA[*/\r\n        var context = /*[[${#httpServletRequest.getContextPath()}]]*/ null;\r\n        /*]]>*/\r\n        function send(){\r\n            $.ajax({\r\n                type:\"post\",\r\n                url:context+\"/mail\",\r\n                contentType: \"application/x-www-form-urlencoded;charset=utf-8\",\r\n                data:{\"address\":$(\"#address\").val()}\r\n            });\r\n        }\r\n    </script>\r\n    </body>\r\n    </html>\r\n	\r\n#### 创建一个页面模拟登陆成功\r\n\r\n    <!DOCTYPE html>\r\n    <html lang=\"en\">\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>Title</title>\r\n    </head>\r\n    <body>\r\n    success\r\n    </body>\r\n    </html>',1,'2020-05-15 19:08:37',10),(10,'blog.sql','```sql\r\n/*\r\n Navicat Premium Data Transfer\r\n\r\n Source Server         : localhost_mysql\r\n Source Server Type    : MySQL\r\n Source Server Version : 50717\r\n Source Host           : localhost:3306\r\n Source Schema         : blog\r\n\r\n Target Server Type    : MySQL\r\n Target Server Version : 50717\r\n File Encoding         : 65001\r\n\r\n Date: 05/09/2020 09:23:34\r\n*/\r\n\r\nSET NAMES utf8mb4;\r\nSET FOREIGN_KEY_CHECKS = 0;\r\n\r\n-- ----------------------------\r\n-- Table structure for about\r\n-- ----------------------------\r\nDROP TABLE IF EXISTS `about`;\r\nCREATE TABLE `about`  (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\r\n  `amountOfReading` int(11) NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`) USING BTREE\r\n) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\r\n\r\n-- ----------------------------\r\n-- Table structure for blog\r\n-- ----------------------------\r\nDROP TABLE IF EXISTS `blog`;\r\nCREATE TABLE `blog`  (\r\n  `blogId` int(11) NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `edits` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `blogStatus` int(11) NOT NULL,\r\n  `time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\r\n  `amountOfReading` int(11) NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`blogId`) USING BTREE\r\n) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\r\n\r\n-- ----------------------------\r\n-- Table structure for leavemessages\r\n-- ----------------------------\r\nDROP TABLE IF EXISTS `leavemessages`;\r\nCREATE TABLE `leavemessages`  (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),\r\n  PRIMARY KEY (`id`) USING BTREE\r\n) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\r\n\r\n-- ----------------------------\r\n-- Table structure for user\r\n-- ----------------------------\r\nDROP TABLE IF EXISTS `user`;\r\nCREATE TABLE `user`  (\r\n  `accountNumber` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `password` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\r\n  `identityType` int(11) NOT NULL,\r\n  PRIMARY KEY (`accountNumber`) USING BTREE\r\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\r\n\r\nSET FOREIGN_KEY_CHECKS = 1;\r\n\r\n```',1,'2020-09-05 09:26:04',10);
/*!40000 ALTER TABLE `blog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leavemessages`
--

DROP TABLE IF EXISTS `leavemessages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leavemessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `content` mediumtext NOT NULL,
  `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leavemessages`
--

LOCK TABLES `leavemessages` WRITE;
/*!40000 ALTER TABLE `leavemessages` DISABLE KEYS */;
INSERT INTO `leavemessages` VALUES (3,'user','作者真帅','2020-02-21 12:42:55'),(4,'user','作者好棒哦','2020-02-23 09:41:36'),(5,'user','？？？？\r\n','2020-04-09 10:10:26');
/*!40000 ALTER TABLE `leavemessages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `accountNumber` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `identityType` int(11) NOT NULL,
  PRIMARY KEY (`accountNumber`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('111111','111111',0),('360','123456',0),('aa','123456',0),('admin','admin',1),('adqqq','123456',0),('arain','dy360033',0),('kkk123','123123',0),('longliangjun','123456',0),('luchao','123456',0),('lz','123456',0),('lz0909','liu990909.',0),('mwu','1qazxsw2',0),('qwe','111111',0),('test','1q2w3e4r5t',0),('tianzeng','xt886372',0),('wzq','wangzq081',0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'blog'
--

--
-- Dumping routines for database 'blog'
--
/*!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 2021-01-27 14:41:05

```

huzhiyuan0215/云网盘项目

简介

发行版

贡献者

近期动态

huzhiyuan0215/云网盘项目 .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

huzhiyuan0215/云网盘项目