一.初识Mybatis

1.使用maven添加配置

<!--导入依赖-->
<dependencies>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--mybatis-->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!--junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
</dependencies>

<!-- 这块就是开放对这个文件夹下 资源的读取 防止读取不到-->
<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>

 

2.搭建数据库（随便搭建 喜欢啥建啥） 顺便建立一个和数据库对应的类

3.导入mybatis.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核心配置文件-->
<configuration>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
  <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

 

4.一个获取连接的utils搞里头

package Utils;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
/**
 * @program: Mybatis
 * @description:
 * @author: @why
 * @create: 2020-08-27 15:03
 **/
public class MyBaitsUtils {
//一个sqlSession搞里头
    private  static SqlSessionFactory factory;

    static {
        String configName="mybatis-config.xml";
        try {
            //读取配置文件
            InputStream inputStream = Resources.getResourceAsStream(configName);
            //得到工厂
           factory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }
    //获取连接
    public static SqlSession getSession()
    {
        return  factory.openSession();
    }

    @Test
    public void Test()
    {
        System.out.println(getSession());
    }
}

 

 

 

 

5.字符集报错：

 

 一般都是将配置文件中的 utf-8改为 uft8

如下图所示

 

 改为

 

 

 

成功获取连接