Mybatis环境配置

1、使用maven引入mybatis的依赖

在pom.xml添加以下代码

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.22</version>
        </dependency>
    </dependencies>

2、创建核心配置文件mybatis-config

在resource下添加mybatis-config

<?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>

<!--    开启驼峰命名法转换,防止数据丢失-->
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <environments default="dev">
<!--        配置不同的环境id  dev开发环境、prd生产环境-->
        <environment id="dev">
<!--            采用JDBC方式对数据库事务进行管理-->
            <transactionManager type="JDBC"></transactionManager>
<!--            采用连接池方式管理数据库连接-->
<!--            如果type="POOLED",代表使用连接池，close()时将连接回收到连接池中-->
<!--            如果type="UNPOOLED",代表直连,close()则会调用Connection.close()方法-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/babytun?useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

<!--创建mapper获取sql执行语句，resource中的路径为mapper.xml的路径-->
    <mappers>
        <mapper resource="mappers/goodsMapper.xml"/>
    </mappers>

</configuration>

​

3、创建MybatiUtils获取SqlSession

package Utlis;

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 java.io.IOException;
import java.io.Reade