MyBatis学习小结

一款轻量级的ORM框架

全局配置文件 SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration           PUBLIC "-//mybatis.org//DTD Config 3//EN"           "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- 加载全局配置, 延迟加载和二级缓存等 -->
    <settings>
        <setting name="lazyLoadingEnabled" value="true">
        </setting>
        <!-- 以下配置在mybatis的3.4.1版本后默认为false -->
        <!-- <setting name="aggressiveLazyLoading" value="false"/> -->
        <!-- <setting name="cacheEnabled" value="true"/> -->
        <!-- 使用JDBC的getGeneratedKeys获取数据库自增主键值，默认为false -->
        <setting name="useGeneratedKeys" value="true">
        </setting>
        <!-- 使用列别名替换列名，默认为true -->
        <setting name="useColumnLabel" value="true">
        </setting>
        <!-- 开启驼峰标识命名转换，默认为false：Table(create_time) -> Entity(createTime) -->
        <setting name="mapUnderscoreToCamelCase" value="true">
        </setting>
    </settings>
    <!-- 定义别名 -->
    <typealiases>
        <!-- <typeAlias type="domain.User" alias="user"/> -->
        <package name="domain">
        </package>
    </typealiases>
    <!-- 事务及连接池，整合spring后需要在spring中进行配置 -->
    <environments default="development">
        <environment id="development">
            <transactionmanager type="JDBC">
            </transactionmanager>
            <datasource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver">
                </property>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis">
                </property>
                <property name="username" value="root">
                </property>
                <property name="password" value="root">
                </property>
            </datasource>
        </environment>
    </environments>
    <!-- 加載映射文件 -->
    <mappers>
        <!-- 加载单个映射文件<mapper resource="sqlMap/UserMapper.xml" /> -->
        <!-- 加载包下的所有映射文件(使用mapper代理) -->
        <package name="mapperProxy">
        </package>
    </mappers>
</configuration><?xml ve