MyBatis配置

1.环境配置environments

• myBatis可以配置成适应多种环境，但是每个sqlSessionFactory实例只能选择一种环境

• myBatis默认事务管理器时jdbc,连接池：pooled

2.属性properties

外部配置文件 db.properties:

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatistest?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT
username=root
password=123456

注意：properties配置必须要在configuration的最上面

引入外部配置文件：

<configuration>


<properties resource="db.properties"/>

    <environments default="test">
        <environment id="test">
            <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="com/kakafa/dao/UserMapper.xml"/>
</mappers>

</configuration>

也可以在其中配置信息:

<configuration>


    <properties resource="db.properties">
        <property name="name" value="root"/>
        <property name="pwd" value="123456"/>
    </properties>


    <environments default="test">
        <environment id="test">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${name}"/>
                <property name="password" value="${pwd}"/>
            </dataSource>
        </environment>
    </environments>


<mappers>
    <mapper resource="com/kakafa/dao/UserMapper.xml"/>
</mappers>

</configuration>