孟郎诗词网2.0版本问题总结

1. centos7.6安装yum方式安装jdk：https://blog.csdn.net/qq_34885405/article/details/93030373
2. Springboot整合Mybatis 出现：Invalid bound statement (not found)：https://blog.csdn.net/sacredness/article/details/82533097
3. centos7防火墙常用指令：https://blog.csdn.net/Karan_01/article/details/73798678
4. MYSQL:WARN: Establishing SSL connection without server's identity verification is not recommended.：https://blog.csdn.net/u010429286/article/details/77750177
5. thymeleaf输出原html内容：https://ask.csdn.net/questions/189159
6. centos7yum安装mysql5.7：https://www.cnblogs.com/luohanguo/p/9045391.html
7. frp内网穿透：https://blog.csdn.net/u013144287/article/details/78589643
8. linux查看tomcat状态：https://www.cnblogs.com/Rozdy/p/4619190.html
9. frp结束和运行：https://www.jianshu.com/p/43f69a534413
10. CentOS7安装字体：https://www.cnblogs.com/cuishuai/p/8441132.html
11. tomcat关闭报错，导致无法正常启动：SEVERE: Could not contact localhost:8005. Tomcat may not be running error while shutting down tomcat
    https://blog.csdn.net/qq_36659177/article/details/83688485
12. tomcat启动报错org.apache.catalina.webresources.Cache.getResource Unable to add the resource
    https://blog.csdn.net/zx1323/article/details/77018109
13. SpringBoot 在阿里云Linux服务器上邮件发送失败：https://blog.csdn.net/weixin_38575051/article/details/93591123
14. MySQL5.7配置远程访问：https://blog.csdn.net/liuyinghui523/article/details/83307289
15.  

• pom.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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.2.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.union</groupId>
    <artifactId>pro</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>pro</name>
    <description>Demo project for Spring Boot</description>
    <packaging>war</packaging>

    <properties>
        <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-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <!--MyBatis依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- mysql 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- druid 数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-surefire-plugin</artifactId>
                <configuration>
                    <!--跳过项目运行测试用例-->
                    <skipTests>true</skipTests>
                </configuration>
            </plugin>
        </plugins>

        <!--解决idea中xml文件和配置文件不被加载的问题-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <filtering>true</filtering>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
            </resource>
        </resources>
    </build>

</project>

• 配置文件示例

spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/union?useSSL=false&serverTimezone=UTC&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=
#数据库连接池
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#别名
mybatis.type-aliases-package=com.union.pro.pojo