mybatis.xml 常用配置记录

电玩女神 2023-06-08 06:55 2阅读 0赞

<?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>
        <properties resource="config/db.properties"></properties>
    
        <settings>
            
            <setting name="logImpl" value="STDOUT_LOGGING"/>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="lazyLoadingEnabled" value="true"/>
            
            <setting name="aggressiveLazyLoading" value="true"/>
            
            <setting name="multipleResultSetsEnabled" value="true"/>
            
            <setting name="useColumnLabel" value="true"/>
            
            <setting name="useGeneratedKeys" value="true"/>
            
            <setting name="autoMappingBehavior" value="PARTIAL"/>
            
            <setting name="defaultExecutorType" value="SIMPLE"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            
            <setting name="localCacheScope" value="SESSION"/>
            
            <setting name="jdbcTypeForNull" value="NULL"/>
        </settings>
    
        <typeAliases>
            <package name="cn.zanezz.entity"/>
        </typeAliases>
    
    
        <plugins>
            <plugin interceptor="com.github.pagehelper.PageInterceptor">
                <property name="helperDialect" value="mysql"/>
                <property name="offsetAsPageNum" value="false"/>
                <property name="rowBoundsWithCount" value="true"/>
                <property name="pageSizeZero" value="true"/>
                <property name="reasonable" value="true"/>
                <property name="supportMethodsArguments" value="false"/>
            </plugin>
        </plugins>
    
        <environments default="development">
    
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${db_driver}"/>
                    <property name="url" value="${db_url}"/>
                    <property name="username" value="${db_username}"/>
                    <property name="password" value="${db_password}"/>
                </dataSource>
            </environment>
        </environments>
    
        <mappers>
            
            <package name="cn.zanezz.mapper"/>
        </mappers>
    </configuration>