MyBatis中的Set配置信息详解

た入场券 2022-05-20 01:06 200阅读 0赞

**settings**

这是 MyBatis 中极为重要的调整设置，它们会改变 MyBatis 的运行时行为。下表描述了设置中各项的意图、默认值等。

以下信息转载自MyBatis官方文档：http://www.mybatis.org/mybatis-3/zh/configuration.html

<table style="table-layout:fixed;width:0px;">       
 <tbody> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:bottom;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);">设置参数</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:bottom;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">描述</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:bottom;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">有效值</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:bottom;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">默认值</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">cacheEnabled</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">全局地开启或关闭配置文件中的所有映射器已经配置的任何缓存。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">lazyLoadingEnabled</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">延迟加载的全局开关。当开启时，所有关联对象都会延迟加载。 特定关联关系中可通过设置</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">fetchType</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">属性来覆盖该项的开关状态。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">false</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">aggressiveLazyLoading</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">当开启时，任何方法的调用都会加载该对象的所有属性。否则，每个属性会按需加载（参考</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">lazyLoadTriggerMethods</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">).</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">false (true in ≤3.4.1)</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">multipleResultSetsEnabled</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">是否允许单一语句返回多结果集（需要兼容驱动）。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">useColumnLabel</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">使用列标签代替列名。不同的驱动在这方面会有不同的表现， 具体可参考相关驱动文档或通过测试这两种不同的模式来观察所用驱动的结果。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">useGeneratedKeys</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">允许 JDBC 支持自动生成主键，需要驱动兼容。 如果设置为 true 则这个设置强制使用自动生成主键，尽管一些驱动不能兼容但仍可正常工作（比如 Derby）。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">False</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">autoMappingBehavior</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定 MyBatis 应如何自动映射列到字段或属性。 NONE 表示取消自动映射；PARTIAL 只会自动映射没有定义嵌套结果集映射的结果集。 FULL 会自动映射任意复杂的结果集（无论是否嵌套）。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">NONE, PARTIAL, FULL</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">PARTIAL</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">autoMappingUnknownColumnBehavior</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定发现自动映射目标未知列（或者未知属性类型）的行为。</span> 
    </div> 
    <div> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">NONE</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">: 不做任何反应</span> 
    </div> 
    <div> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">WARNING</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">: 输出提醒日志 (</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">'org.apache.ibatis.session.AutoMappingUnknownColumnBehavior'</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">&nbsp;的日志等级必须设置为&nbsp;</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">WARN</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">)</span> 
    </div> 
    <div> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">FAILING</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">: 映射失败 (抛出&nbsp;</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">SqlSessionException</span> 
     <span style="font-family:SimSun, STSong;color:rgb(64,64,64);background-color:transparent;">)</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">NONE, WARNING, FAILING</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">NONE</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">defaultExecutorType</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">配置默认的执行器。SIMPLE 就是普通的执行器；REUSE 执行器会重用预处理语句（prepared statements）； BATCH 执行器将重用语句并执行批量更新。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">SIMPLE REUSE BATCH</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">SIMPLE</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">defaultStatementTimeout</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">设置超时时间，它决定驱动等待数据库响应的秒数。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">任意正整数</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not Set (null)</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">defaultFetchSize</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">为驱动的结果集获取数量（fetchSize）设置一个提示值。此参数只可以在查询设置中被覆盖。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">任意正整数</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not Set (null)</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">safeRowBoundsEnabled</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">允许在嵌套语句中使用分页（RowBounds）。如果允许使用则设置为false。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">False</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">safeResultHandlerEnabled</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">允许在嵌套语句中使用分页（ResultHandler）。如果允许使用则设置为false。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">True</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">mapUnderscoreToCamelCase</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">是否开启自动驼峰命名规则（camel case）映射，即从经典数据库列名 A_COLUMN 到经典 Java 属性名 aColumn 的类似映射。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">False</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">localCacheScope</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">MyBatis 利用本地缓存机制（Local Cache）防止循环引用（circular references）和加速重复嵌套查询。 默认值为 SESSION，这种情况下会缓存一个会话中执行的所有查询。 若设置值为 STATEMENT，本地会话仅用在语句执行上，对相同 SqlSession 的不同调用将不会共享数据。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">SESSION | STATEMENT</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">SESSION</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">jdbcTypeForNull</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">当没有为参数提供特定的 JDBC 类型时，为空值指定 JDBC 类型。 某些驱动需要指定列的 JDBC 类型，多数情况直接用一般类型即可，比如 NULL、VARCHAR 或 OTHER。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">JdbcType 常量. 大多都为: NULL, VARCHAR and OTHER</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">OTHER</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">lazyLoadTriggerMethods</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定哪个对象的方法触发一次延迟加载。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">用逗号分隔的方法列表。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">equals,clone,hashCode,toString</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">defaultScriptingLanguage</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定动态 SQL 生成的默认语言。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">一个类型别名或完全限定类名。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">org.apache.ibatis.scripting.xmltags.XMLLanguageDriver</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">defaultEnumTypeHandler</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定 Enum 使用的默认&nbsp;</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">TypeHandler</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;。 (从3.4.5开始)</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">一个类型别名或完全限定类名。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">org.apache.ibatis.type.EnumTypeHandler</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">callSettersOnNulls</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定当结果集中值为 null 的时候是否调用映射对象的 setter（map 对象时为 put）方法，这对于有 Map.keySet() 依赖或 null 值初始化的时候是有用的。注意基本类型（int、boolean等）是不能设置成 null 的。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">false</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">returnInstanceForEmptyRow</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">当返回行的所有列都是空时，MyBatis默认返回</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">null</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。 当开启这个设置时，MyBatis会返回一个空实例。 请注意，它也适用于嵌套的结果集 (i.e. collectioin and association)。（从3.4.2开始）</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">false</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">logPrefix</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定 MyBatis 增加到日志名称的前缀。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">任何字符串</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not set</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">logImpl</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定 MyBatis 所用日志的具体实现，未指定时将自动查找。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">SLF4J | LOG4J | LOG4J2 | JDK_LOGGING | COMMONS_LOGGING | STDOUT_LOGGING | NO_LOGGING</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not set</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">proxyFactory</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定 Mybatis 创建具有延迟加载能力的对象所用到的代理工具。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">CGLIB | JAVASSIST</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">JAVASSIST (MyBatis 3.3 or above)</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">vfsImpl</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定VFS的实现</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">自定义VFS的实现的类全限定名，以逗号分隔。</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not set</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">useActualParamName</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">允许使用方法签名中的名称作为语句参数名称。 为了使用该特性，你的工程必须采用Java 8编译，并且加上</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">-parameters</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">选项。（从3.4.1开始）</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true | false</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">true</span> 
    </div></td> 
  </tr> 
  <tr> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">configurationFactory</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定一个提供</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Configuration</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">实例的类。 这个被返回的Configuration实例用来加载被反序列化对象的懒加载属性值。 这个类必须包含一个签名方法</span> 
     <span style="font-size:12px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">static Configuration getConfiguration()</span> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">. (从 3.2.3 版本开始)</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">类型别名或者全类名.</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;background-color:rgb(249,249,249);"> 
    <div> 
     <span style="font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">Not set</span> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

一个配置完整的 settings 元素的示例如下：

一个配置完整的 settings 元素的示例如下：
    <settings>
      <setting name="cacheEnabled" value="true"/>
      <setting name="lazyLoadingEnabled" value="true"/>
      <setting name="multipleResultSetsEnabled" value="true"/>
      <setting name="useColumnLabel" value="true"/>
      <setting name="useGeneratedKeys" value="false"/>
      <setting name="autoMappingBehavior" value="PARTIAL"/>
      <setting name="autoMappingUnknownColumnBehavior" value="WARNING"/>
      <setting name="defaultExecutorType" value="SIMPLE"/>
      <setting name="defaultStatementTimeout" value="25"/>
      <setting name="defaultFetchSize" value="100"/>
      <setting name="safeRowBoundsEnabled" value="false"/>
      <setting name="mapUnderscoreToCamelCase" value="false"/>
      <setting name="localCacheScope" value="SESSION"/>
      <setting name="jdbcTypeForNull" value="OTHER"/>
      <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
    </settings>