各环境变量的配置

JDK

环境变量：
JAVA_HOME + 安装路径
Path + %JAVA_HOME%\bin
Path + %JAVA_HOME%\jre\bin
CLASSPATH + .;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar

Tomcat

我们需要配置三个系统环境变量
CATALINA_BASE：指向tomcat的安装位置
CATALINE_HOME:指向tomcat的安装位置
Path：%CATALINA_HOME%\lib;%CATALINA_HOME%\bin

Maven

环境变量：
M2_HOME Maven目录下的bin目录
MAVEN_HOME Maven目录
Path + %MAVEN_HOME%\bin

D:\Environment\apache-maven-3.8.2\conf下的settings.xml 中，加入阿里云镜像

<mirror>
  <id>aliyunmaven</id>
  <mirrorOf>*</mirrorOf>
  <name>阿里云公共仓库</name>
  <url>https://maven.aliyun.com/repository/public</url>
</mirror>

在安装目录中新建文件夹 - maven-repo
在setting.xml中 55行加入

<localRepository>D:\Environment\apache-maven-3.8.2\maven-repo</localRepository>

MySQL

环境变量：
Path + 安装目录下的bin目录 D:\Environment\mysql-5.7.34-winx64\bin
在D:\Environment\mysql-5.7.34-winx64 中新建 my.ini
my.ini中加入以下信息 ：

[mysqld]
basedir=D:\Environment\mysql-5.7.34-winx64
datadir=D:\Environment\mysql-5.7.34-winx64\data
port=3306
skip-grant-tables

启动管理员CMD，将路径切换到mysql下的bin目录(cd /d D:\Environment\mysql-5.7.34-winx64\bin)，然后输入mysqld -install
成功后再输入 mysqld --initialize-insecure --user=mysql
等待执行完毕后再输入 net start mysql 等待启动完毕
再输入mysql -u root -p 提示输入密码，直接点回车，进入
输入 update mysql.user set authentication_string=password(‘123456’)where user=‘root’ and Host = ‘localhost’;
成功后输入 flush privileges;
修改 my.ini 中最后一行，在最后一行前加#，将最后一行注释掉
重启服务即可

Mybatis

新建Maven项目，加入以下依赖

<dependencies>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/junit/junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

在resources中新建mybatis-config.xml
去官方文档找到xml内容，

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="org/mybatis/example/BlogMapper.xml"/>
  </mappers>
</configuration>

<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
  <property name="url" value="jdbc:mysql://localhost:3306/替换为数据库名?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
  <property name="username" value="root"/>
  <property name="password" value="123456"/>

mybatis工具类 MybatisUtil.java

public class MybatisUtil {

  private static SqlSessionFactory sqlSessionFactory;
  static {
      try {
          //使用Mybatis第一步，获取sqlSessionFactory对象
          String resource = "mybatis-config.xml";
          InputStream inputStream = Resources.getResourceAsStream(resource);
          sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
      } catch (IOException e) {
          e.printStackTrace();
      }

  }
  public static SqlSession getSqlSession(){
      return sqlSessionFactory.openSession();
  }
}

pom.xml中需加入以下代码来读取配置文件

<build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

在Idea设置中搜索SQL Dialects，将sql方言改为Mysql，这样就可以在mybatis-config.xml中 . 出来东西了