MyBatis中的注解文件信息

落日映苍穹つ 2022-05-20 01:06 150阅读 0赞

##### 映射器注解 #####

以下信息转载自MyBatis官方文档：http://www.mybatis.org/mybatis-3/zh/java-api.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-size:16px;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-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">相对应的 XML</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:bottom;"> 
    <div> 
     <span style="font-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@CacheNamespace</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">类</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;cache&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">为给定的命名空间（比如类）配置缓存。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">implemetation</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">eviction</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">flushInterval</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">size</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">readWrite</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">blocking</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;和</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">properties</span> 
     <span style="font-size:16px;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;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Property</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;property&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">指定参数值或占位值（placeholder）（能被&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">mybatis-config.xml</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">内的配置属性覆盖）。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">name</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。（仅在MyBatis 3.4.2以上版本生效）</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@CacheNamespaceRef</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">类</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;cacheRef&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">参照另外一个命名空间的缓存来使用。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">name</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。如果你使用了这个注解，你应设置&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或者&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">name</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;属性的其中一个。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;属性用于指定 Java 类型而指定命名空间（命名空间名就是指定的 Java 类型的全限定名），</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">name</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;属性（这个属性仅在MyBatis 3.4.2以上版本生效）直接指定了命名空间的名字。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@ConstructorArgs</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;constructor&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">收集一组结果传递给一个结果对象的构造方法。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Arg</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;arg&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;idArg&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">单参数构造方法，是 ConstructorArgs 集合的一部分。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">id</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">column</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">javaType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">jdbcType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">typeHandler</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">select</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;和&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">resultMap</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。id 属性是布尔值，来标识用于比较的属性，和</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;idArg&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;XML 元素相似。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@TypeDiscriminator</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;discriminator&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">一组实例值被用来决定结果映射的表现。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">column</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">javaType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">jdbcType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">typeHandler</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;和&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">cases</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。cases 属性是实例数组。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Case</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;case&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">单独实例的值和它对应的映射。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">type</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">results</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。results 属性是结果数组，因此这个注解和实际的&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">ResultMap</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;很相似，由下面的&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Results</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解指定。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Results</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;resultMap&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">结果映射的列表，包含了一个特别结果列如何被映射到属性或字段的详情。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">id</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。value 属性是&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Result</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解的数组。这个 id 的属性是结果映射的名称。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Result</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;result&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;id&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">在列和属性或字段之间的单独结果映射。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">id</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">column</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">javaType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">jdbcType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">typeHandler</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">one</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">many</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。id 属性是一个布尔值，来标识应该被用于比较（和在 XML 映射中的</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;id&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">相似）的属性。one 属性是单独的联系，和&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;association&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;相似，而 many 属性是对集合而言的，和</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;collection&gt;</span> 
     <span style="font-size:16px;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;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@One</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;association&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">复杂类型的单独属性值映射。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">select</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，已映射语句（也就是映射器方法）的全限定名，它可以加载合适类型的实例。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">fetchType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">会覆盖全局的配置参数&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">lazyLoadingEnabled</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(255,255,255);background-color:rgb(153,153,153);"><strong>注意</strong></span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;联合映射在注解 API中是不支持的。这是因为 Java 注解的限制,不允许循环引用。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Many</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;collection&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">映射到复杂类型的集合属性。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">select</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，已映射语句（也就是映射器方法）的全限定名，它可以加载合适类型的实例的集合，</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">fetchType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;会覆盖全局的配置参数&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">lazyLoadingEnabled</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(255,255,255);background-color:rgb(153,153,153);"><strong>注意</strong></span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;联合映射在注解 API中是不支持的。这是因为 Java 注解的限制，不允许循环引用</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@MapKey</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;">&nbsp;</td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">这是一个用在返回值为 Map 的方法上的注解。它能够将存放对象的 List 转化为 key 值为对象的某一属性的 Map。属性有：&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，填入的是对象的属性名，作为 Map 的 key 值。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Options</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</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-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">这个注解提供访问大范围的交换和配置选项的入口，它们通常在映射语句上作为属性出现。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Options</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解提供了通俗易懂的方式来访问它们，而不是让每条语句注解变复杂。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">useCache=true</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">flushCache=FlushCachePolicy.DEFAULT</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">resultSetType=FORWARD_ONLY</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">statementType=PREPARED</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">fetchSize=-1</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">timeout=-1</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">useGeneratedKeys=false</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyProperty="id"</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyColumn=""</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">resultSets=""</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。值得一提的是， Java 注解无法指定&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">null</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;值。因此，一旦你使用了&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Options</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解，你的语句就会被上述属性的默认值所影响。要注意避免默认值带来的预期以外的行为。</span> 
    </div> 
    <div> 
     <br> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp; &nbsp; &nbsp; &nbsp;注意：&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyColumn</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;属性只在某些数据库中有效（如 Oracle、PostgreSQL等）。请在插入语句一节查看更多关于&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyColumn</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;和&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyProperty</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;两者的有效值详情。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Insert</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Update</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Delete</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Select</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;insert&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;update&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;delete&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;select&gt;</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">这四个注解分别代表将会被执行的 SQL 语句。它们用字符串数组（或单个字符串）作为参数。如果传递的是字符串数组，字符串之间先会被填充一个空格再连接成单个完整的字符串。这有效避免了以 Java 代码构建 SQL 语句时的“丢失空格”的问题。然而，你也可以提前手动连接好字符串。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">value</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，填入的值是用来组成单个 SQL 语句的字符串数组。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@InsertProvider</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@UpdateProvider</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@DeleteProvider</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@SelectProvider</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;insert&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;update&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;delete&gt;</span> 
    </div> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;select&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">允许构建动态 SQL。这些备选的 SQL 注解允许你指定类名和返回在运行时执行的 SQL 语句的方法。（自从MyBatis 3.4.6开始，你可以用&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">CharSequence</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;代替&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">String</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;来返回类型返回值了。）当执行映射语句的时候，MyBatis 会实例化类并执行方法，类和方法就是填入了注解的值。你可以把已经传递给映射方法了的对象作为参数，"Mapper interface type" 和 "Mapper method" 会经过&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">ProviderContext</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;（仅在MyBatis 3.4.5及以上支持）作为参数值。（MyBatis 3.4及以上的版本，支持多参数传入）属性有：&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">type</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">method</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">type</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;属性需填入类。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">method</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;需填入该类定义了的方法名。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(255,255,255);background-color:rgb(153,153,153);"><strong>注意</strong></span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;接下来的小节将会讨论类，能帮助你更轻松地构建动态 SQL。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Param</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">参数</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">如果你的映射方法的形参有多个，这个注解使用在映射方法的参数上就能为它们取自定义名字。若不给出自定义名字，多参数（不包括&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">RowBounds</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;参数）则先以 "param" 作前缀，再加上它们的参数位置作为参数别名。例如&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">#{param1}</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">,&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">#{param2}</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，这个是默认值。如果注解是&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Param("person")</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">，那么参数就会被命名为&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">#{person}</span> 
     <span style="font-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@SelectKey</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;selectKey&gt;</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">这个注解的功能与&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;selectKey&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;标签完全一致，用在已经被&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Insert</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@InsertProvider</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Update</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@UpdateProvider</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解了的方法上。若在未被上述四个注解的方法上作&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@SelectKey</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解则视为无效。如果你指定了&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@SelectKey</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解，那么 MyBatis 就会忽略掉由&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Options</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解所设置的生成主键或设置（configuration）属性。属性有：</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">statement</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;填入将会被执行的 SQL 字符串数组，</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyProperty</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;填入将会被更新的参数对象的属性的值，</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">before</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;填入&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">true</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">false</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;以指明 SQL 语句应被在插入语句的之前还是之后执行。</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">resultType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;填入&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">keyProperty</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;的 Java 类型和用&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">Statement</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">、&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">PreparedStatement</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;和&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">CallableStatement</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;中的&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">STATEMENT</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">、&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">PREPARED</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">CALLABLE</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;中任一值填入&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">statementType</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">。默认值是&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">PREPARED</span> 
     <span style="font-size:16px;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;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@ResultMap</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">这个注解给&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Select</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或者&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@SelectProvider</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;提供在 XML 映射中的&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;resultMap&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;的id。这使得注解的 select 可以复用那些定义在 XML 中的 ResultMap。如果同一 select 注解中还存在&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Results</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;或者&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@ConstructorArgs</span> 
     <span style="font-size:16px;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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@ResultType</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">此注解在使用了结果处理器的情况下使用。在这种情况下，返回类型为 void，所以 Mybatis 必须有一种方式决定对象的类型，用于构造每行数据。如果有 XML 的结果映射，请使用&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@ResultMap</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;注解。如果结果类型在 XML 的&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">&lt;select&gt;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;节点中指定了，就不需要其他的注解了。其他情况下则使用此注解。比如，如果 @Select 注解在一个将使用结果处理器的方法上，那么返回类型必须是 void 并且这个注解（或者@ResultMap）必选。这个注解仅在方法返回类型是 void 的情况下生效。</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-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">@Flush</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">方法</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">N/A</span> 
    </div></td> 
   <td style="color:rgb(57,57,57);border-color:rgb(167,167,167);vertical-align:top;"> 
    <div> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">如果使用了这个注解，定义在 Mapper 接口中的方法能够调用&nbsp;</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:rgb(254,233,204);">SqlSession#flushStatements()</span> 
     <span style="font-size:16px;font-family:SimSun, STSong;color:rgb(0,0,0);background-color:transparent;">&nbsp;方法。（Mybatis 3.3及以上）</span> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

##### 映射申明样例 #####

这个例子展示了如何使用 @SelectKey 注解来在插入前读取数据库序列的值：

@Insert("insert into table3 (id, name) values(#{nameId}, #{name})")
    @SelectKey(statement="call next value for TestSequence", keyProperty="nameId", before=true, resultType=int.class)
    int insertTable3(Name name);

这个例子展示了如何使用 @SelectKey 注解来在插入后读取数据库识别列的值：

@Insert("insert into table2 (name) values(#{name})")
    @SelectKey(statement="call identity()", keyProperty="nameId", before=false, resultType=int.class)
    int insertTable2(Name name);

这个例子展示了如何使用 @Flush 注解去调用 SqlSession\#flushStatements()：

@Flush
    List<BatchResult> flush();

这些例子展示了如何通过指定 @Result 的 id 属性来命名结果集：

@Results(id = "userResult", value = {
         
      @Result(property = "id", column = "uid", id = true),
      @Result(property = "firstName", column = "first_name"),
      @Result(property = "lastName", column = "last_name")
    })
    @Select("select * from users where id = #{id}")
    User getUserById(Integer id);
    
    @Results(id = "companyResults")
    @ConstructorArgs({
         
      @Arg(property = "id", column = "cid", id = true),
      @Arg(property = "name", column = "name")
    })
    @Select("select * from company where id = #{id}")
    Company getCompanyById(Integer id);

这个例子展示了单一参数使用 @SqlProvider 注解：

@SelectProvider(type = UserSqlBuilder.class, method = "buildGetUsersByName")
    List<User> getUsersByName(String name);
    
    class UserSqlBuilder {
         
      public static String buildGetUsersByName(final String name) {
         
        return new SQL(){
         {
         
          SELECT("*");
          FROM("users");
          if (name != null) {
         
            WHERE("name like #{value} || '%'");
          }
          ORDER_BY("id");
        }}.toString();
      }
    }

这个例子展示了多参数使用 @SqlProvider 注解：

@SelectProvider(type = UserSqlBuilder.class, method = "buildGetUsersByName")
    List<User> getUsersByName(
        @Param("name") String name, @Param("orderByColumn") String orderByColumn);
    
    class UserSqlBuilder {
         
    
      // If not use @Param, you should be define same arguments with mapper method
      public static String buildGetUsersByName(
          final String name, final String orderByColumn) {
         
        return new SQL(){
         {
         
          SELECT("*");
          FROM("users");
          WHERE("name like #{name} || '%'");
          ORDER_BY(orderByColumn);
        }}.toString();
      }
    
      // If use @Param, you can define only arguments to be used
      public static String buildGetUsersByName(@Param("orderByColumn") final String orderByColumn) {
         
        return new SQL(){
         {
         
          SELECT("*");
          FROM("users");
          WHERE("name like #{name} || '%'");
          ORDER_BY(orderByColumn);
        }}.toString();
      }
    }