Mapper XML Files详解

<select id="selectPerson" parameterType="int" resultType="hashmap">

  SELECT * FROM PERSON WHERE ID = #{id}

</select>

#{id}

// Similar JDBC code, NOT MyBatis…

String selectPerson = "SELECT * FROM PERSON WHERE ID=?";

PreparedStatement ps = conn.prepareStatement(selectPerson);

ps.setInt(1,id);

<select

  id="selectPerson"

  parameterType="int"

  parameterMap="deprecated"

  resultType="hashmap"

  resultMap="personResultMap"

  flushCache="false"

  useCache="true"

  timeout="10000"

  fetchSize="256"

  statementType="PREPARED"

  resultSetType="FORWARD_ONLY">

<insert

  id="insertAuthor"

  parameterType="domain.blog.Author"

  flushCache="true"

  statementType="PREPARED"

  keyProperty=""

  keyColumn=""

  useGeneratedKeys=""

  timeout="20">

<update

  id="insertAuthor"

  parameterType="domain.blog.Author"

  flushCache="true"

  statementType="PREPARED"

  timeout="20">

<delete

  id="insertAuthor"

  parameterType="domain.blog.Author"

  flushCache="true"

  statementType="PREPARED"

  timeout="20">

<insert id="insertAuthor">

  insert into Author (id,username,password,email,bio)

  values (#{id},#{username},#{password},#{email},#{bio})

</insert>

<update id="updateAuthor">

  update Author set

    username = #{username},

    password = #{password},

    email = #{email},

    bio = #{bio}

  where id = #{id}

</update>

<delete id="deleteAuthor">

  delete from Author where id = #{id}

</delete>

<insert id="insertAuthor" useGeneratedKeys="true"

    keyProperty="id">

  insert into Author (username,password,email,bio)

  values (#{username},#{password},#{email},#{bio})

</insert>

<insert id="insertAuthor">

  <selectKey keyProperty="id" resultType="int" order="BEFORE">

    select CAST(RANDOM()*1000000 as INTEGER) a from SYSIBM.SYSDUMMY1

  </selectKey>

  insert into Author

    (id, username, password, email,bio, favourite_section)

  values

    (#{id}, #{username}, #{password}, #{email}, #{bio}, #{favouriteSection,jdbcType=VARCHAR})

</insert>

<selectKey

  keyProperty="id"

  resultType="int"

  order="BEFORE"

  statementType="PREPARED">

<sql id="userColumns"> id,username,password </sql>

<select id="selectUsers" resultType="map">

  select <include refid="userColumns"/>

  from some_table

  where id = #{id}

</select>

<select id="selectUsers" resultType="User">

  select id, username, password

  from users

  where id = #{id}

</select>

<insert id="insertUser" parameterType="User">

  insert into users (id, username, password)

  values (#{id}, #{username}, #{password})

</insert>

#{property,javaType=int,jdbcType=NUMERIC}

#{age,javaType=int,jdbcType=NUMERIC,typeHandler=MyTypeHandler}

#{height,javaType=double,jdbcType=NUMERIC,numericScale=2}

#{department, mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=departmentResultMap}

#{middleInitial, mode=OUT, jdbcType=STRUCT, jdbcTypeName=MY_TYPE, resultMap=departmentResultMap}

#{firstName}

#{middleInitial,jdbcType=VARCHAR}

#{lastName}

String Substitution

By default, using the #{} syntax will cause MyBatis to generate PreparedStatement properties
and set the values safely against the PreparedStatement parameters (e.g. ?). While this is safer, faster and almost
always preferred, sometimes you just want to directly inject a string unmodified into the SQL Statement. For example, for ORDER BY, you might use something like this:

ORDER BY ${columnName}

Here MyBatis won't modify or escape the string.

NOTE It's
not safe to accept input from a user and supply it to a statement unmodified in this way. This leads to potential SQL Injection attacks and therefore you should either disallow user input in these fields, or always perform your own escapes and checks.

<select id="selectUsers" resultType="map">

  select id, username, hashedPassword

  from some_table

  where id = #{id}

</select>

package com.someapp.model;

public class User {

  private int id;

  private String username;

  private String hashedPassword;

  public int getId() {

    return id;

  }

  public void setId(int id) {

    this.id = id;

  }

  public String getUsername() {

    return username;

  }

  public void setUsername(String username) {

    this.username = username;

  }

  public String getHashedPassword() {

    return hashedPassword;

  }

  public void setHashedPassword(String hashedPassword) {

    this.hashedPassword = hashedPassword;

  }

}

<select id="selectUsers" resultType="com.someapp.model.User">

  select id, username, hashedPassword

  from some_table

  where id = #{id}

</select>

<!-- In Config XML file -->

<typeAlias type="com.someapp.model.User" alias="User"/>

<!-- In SQL Mapping XML file -->

<select id="selectUsers" resultType="User">

  select id, username, hashedPassword

  from some_table

  where id = #{id}

</select>

<select id="selectUsers" resultType="User">

  select

    user_id             as "id",

    user_name           as "userName",

    hashed_password     as "hashedPassword"

  from some_table

  where id = #{id}

</select>

<resultMap id="userResultMap" type="User">

  <id property="id" column="user_id" />

  <result property="username" column="user_name"/>

  <result property="password" column="hashed_password"/>

</resultMap>

<select id="selectUsers" resultMap="userResultMap">

  select user_id, user_name, hashed_password

  from some_table

  where id = #{id}

</select>

Advanced Result Maps

MyBatis was created with one idea in mind: Databases aren't always what you want or need them to be. While we'd love every database to be perfect 3rd normal form or BCNF, they aren't. And it would be great if it was possible to
have a single database map perfectly to all of the applications that use it, it's not. Result Maps are the answer that MyBatis provides to this problem.

For example, how would we map this statement?

<!-- Very Complex Statement -->

<select id="selectBlogDetails" resultMap="detailedBlogResultMap">

  select

       B.id as blog_id,

       B.title as blog_title,

       B.author_id as blog_author_id,

       A.id as author_id,

       A.username as author_username,

       A.password as author_password,

       A.email as author_email,

       A.bio as author_bio,

       A.favourite_section as author_favourite_section,

       P.id as post_id,

       P.blog_id as post_blog_id,

       P.author_id as post_author_id,

       P.created_on as post_created_on,

       P.section as post_section,

       P.subject as post_subject,

       P.draft as draft,

       P.body as post_body,

       C.id as comment_id,

       C.post_id as comment_post_id,

       C.name as comment_name,

       C.comment as comment_text,

       T.id as tag_id,

       T.name as tag_name

  from Blog B

       left outer join Author A on B.author_id = A.id

       left outer join Post P on B.id = P.blog_id

       left outer join Comment C on P.id = C.post_id

       left outer join Post_Tag PT on PT.post_id = P.id

       left outer join Tag T on PT.tag_id = T.id

  where B.id = #{id}

</select>

You'd probably want to map it to an intelligent object model consisting of a Blog that was written by an Author, and has many Posts, each of which may have zero or many Comments and Tags. The following is a complete example of
a complex ResultMap (assume Author, Blog, Post, Comments and Tags are all type aliases). Have a look at it, but don't worry, we're going to go through each step. While it may look daunting at first, it's actually very simple.

<!-- Very Complex Result Map -->

<resultMap id="detailedBlogResultMap" type="Blog">

  <constructor>

    <idArg column="blog_id" javaType="int"/>

  </constructor>

  <result property="title" column="blog_title"/>

  <association property="author" javaType="Author">

    <id property="id" column="author_id"/>

    <result property="username" column="author_username"/>

    <result property="password" column="author_password"/>

    <result property="email" column="author_email"/>

    <result property="bio" column="author_bio"/>

    <result property="favouriteSection" column="author_favourite_section"/>

  </association>

  <collection property="posts" ofType="Post">

    <id property="id" column="post_id"/>

    <result property="subject" column="post_subject"/>

    <association property="author" javaType="Author"/>

    <collection property="comments" ofType="Comment">

      <id property="id" column="comment_id"/>

    </collection>

    <collection property="tags" ofType="Tag" >

      <id property="id" column="tag_id"/>

    </collection>

    <discriminator javaType="int" column="draft">

      <case value="1" resultType="DraftPost"/>

    </discriminator>

  </collection>

</resultMap>

The resultMap element has a number of sub-elements and a structure worthy of some discussion.
The following is a conceptual view of the resultMap element.

resultMap

• constructor - used for injecting results into the constructor of a class upon instantiation
  • idArg - ID argument; flagging results as ID will help improve overall performance
  • arg - a normal result injected into the constructor
• id – an ID result; flagging results as ID will help improve overall performance
• result – a normal result injected into a field or JavaBean property
• association – a complex type association; many results will roll up into this type
  • nested result mappings – associations are resultMap s themselves, or can refer to one
• collection – a collection of complex types
  • nested result mappings – collections are resultMap s themselves, or can refer to one
• discriminator – uses a result value to determine which resultMap to
  use
  • case – a case is a result map based on some value
    • nested result mappings – a case is also a result map itself, and thus can contain many of these same elements, or it can refer to an external resultMap.

Best
Practice Always build ResultMaps incrementally. Unit tests really help out here. If you try to build a gigantic resultMap like
the one above all at once, it's likely you'll get it wrong and it will be hard to work with. Start simple, and evolve it a step at a time. And unit test! The downside to using frameworks is that they are sometimes a bit of a black box (open source or not).
Your best bet to ensure that you're achieving the behaviour that you intend, is to write unit tests. It also helps to have them when submitting bugs.

The next sections will walk through each of the elements in more detail.

id & result

<id property="id" column="post_id"/>

<result property="subject" column="post_subject"/>

These are the most basic of result mappings. Both id , and result map a single column value to a single property or field of a simple data type (String, int, double, Date, etc.).

The only difference between the two is that id will flag the result as an identifier property to be used when comparing object instances. This helps to improve general performance, but especially performance of caching
and nested result mapping (i.e. join mapping).

Each has a number of attributes:

Supported JDBC Types

For future reference, MyBatis supports the following JDBC Types via the included JdbcType enumeration.

constructor

<constructor>

   <idArg column="id" javaType="int"/>

   <arg column="username" javaType="String"/>

</constructor>

While properties will work for most Data Transfer Object (DTO) type classes, and likely most of your domain model, there may be some cases where you want to use immutable classes. Often tables that contain reference or lookup
data that rarely or never changes is suited to immutable classes. Constructor injection allows you to set values on a class upon instantiation, without exposing public methods. MyBatis also supports private properties and private JavaBeans properties to achieve
this, but some people prefer Constructor injection. The constructor element enables this.

Consider the following constructor:

public class User {

   //...

   public User(int id, String username) {

     //...

  }

//...

}

In order to inject the results into the constructor, MyBatis needs to identify the constructor by the type of its parameters. Java has no way to introspect (or reflect) on parameter names. So when creating a constructor element,
ensure that the arguments are in order, and that the data types are specified.

<constructor>

   <idArg column="id" javaType="int"/>

   <arg column="username" javaType="String"/>

</constructor>

The rest of the attributes and rules are the same as for the regular id and result elements.

association

<association property="author" javaType="Author">

  <id property="id" column="author_id"/>

  <result property="username" column="author_username"/>

</association>

The association element deals with a "has-one" type relationship. For example, in our example, a Blog has one Author. An association mapping works mostly like any other result. You specify the target property, the javaType of
the property (which MyBatis can figure out most of the time), the jdbcType if necessary and a typeHandler if you want to override the retrieval of the result values.

Where the association differs is that you need to tell MyBatis how to load the association. MyBatis can do so in two different ways:

• Nested Select: By executing another mapped SQL statement that returns the complex type desired.
• Nested Results: By using nested result mappings to deal with repeating subsets of joined results.

First, let's examine the properties of the element. As you'll see, it differs from a normal result mapping only by the select and resultMap attributes.

Nested Select for Association

For example:

<resultMap id="blogResult" type="Blog">

  <association property="author" column="author_id" javaType="Author" select="selectAuthor"/>

</resultMap>

<select id="selectBlog" resultMap="blogResult">

  SELECT * FROM BLOG WHERE ID = #{id}

</select>

<select id="selectAuthor" resultType="Author">

  SELECT * FROM AUTHOR WHERE ID = #{id}

</select>

That's it. We have two select statements: one to load the Blog, the other to load the Author, and the Blog's resultMap describes that the selectAuthor statement
should be used to load its author property.

All other properties will be loaded automatically assuming their column and property names match.

While this approach is simple, it will not perform well for large data sets or lists. This problem is known as the "N+1 Selects Problem". In a nutshell, the N+1 selects problem is caused like this:

• You execute a single SQL statement to retrieve a list of records (the "+1").
• For each record returned, you execute a select statement to load details for each (the "N").

This problem could result in hundreds or thousands of SQL statements to be executed. This is not always desirable.

The upside is that MyBatis can lazy load such queries, thus you might be spared the cost of these statements all at once. However, if you load such a list and then immediately iterate through it to access the nested data, you
will invoke all of the lazy loads, and thus performance could be very bad.

And so, there is another way.

Nested Results for Association

You've already seen a very complicated example of nested associations above. The following is a far simpler example to demonstrate how this works. Instead of executing a separate statement, we'll join the Blog and Author tables
together, like so:

<select id="selectBlog" resultMap="blogResult">

  select

    B.id            as blog_id,

    B.title         as blog_title,

    B.author_id     as blog_author_id,

    A.id            as author_id,

    A.username      as author_username,

    A.password      as author_password,

    A.email         as author_email,

    A.bio           as author_bio

  from Blog B left outer join Author A on B.author_id = A.id

  where B.id = #{id}

</select>

Notice the join, as well as the care taken to ensure that all results are aliased with a unique and clear name. This makes mapping far easier. Now we can map the results:

<resultMap id="blogResult" type="Blog">

  <id property="id" column="blog_id" />

  <result property="title" column="blog_title"/>

  <association property="author" resultMap="authorResult" />

</resultMap>

<resultMap id="authorResult" type="Author">

  <id property="id" column="author_id"/>

  <result property="username" column="author_username"/>

  <result property="password" column="author_password"/>

  <result property="email" column="author_email"/>

  <result property="bio" column="author_bio"/>

</resultMap>

In the example above you can see at the Blog's "author" association delegates to the "authorResult" resultMap to load the Author instance.

Very Important: id elements play a very important role in Nested Result mapping. You should always specify one or more properties that can be used to uniquely identify the results. The truth is that
MyBatis will still work if you leave it out, but at a severe performance cost. Choose as few properties as possible that can uniquely identify the result. The primary key is an obvious choice (even if composite).

Now, the above example used an external resultMap element to map the association. This makes the Author resultMap reusable. However, if you have no need to reuse it, or if you simply prefer to co-locate your result mappings into
a single descriptive resultMap, you can nest the association result mappings. Here's the same example using this approach:

<resultMap id="blogResult" type="Blog">

  <id property="id" column="blog_id" />

  <result property="title" column="blog_title"/>

  <association property="author" javaType="Author">

    <id property="id" column="author_id"/>

    <result property="username" column="author_username"/>

    <result property="password" column="author_password"/>

    <result property="email" column="author_email"/>

    <result property="bio" column="author_bio"/>

  </association>

</resultMap>

What if the blog has a co-author? The select statement would look like:

<select id="selectBlog" resultMap="blogResult">

  select

    B.id            as blog_id,

    B.title         as blog_title,

    A.id            as author_id,

    A.username      as author_username,

    A.password      as author_password,

    A.email         as author_email,

    A.bio           as author_bio,

    CA.id           as co_author_id,

    CA.username     as co_author_username,

    CA.password     as co_author_password,

    CA.email        as co_author_email,

    CA.bio          as co_author_bio

  from Blog B

  left outer join Author A on B.author_id = A.id

  left outer join Author CA on B.co_author_id = CA.id

  where B.id = #{id}

</select>

Recall that the resultMap for Author is defined as follows.

<resultMap id="authorResult" type="Author">

  <id property="id" column="author_id"/>

  <result property="username" column="author_username"/>

  <result property="password" column="author_password"/>

  <result property="email" column="author_email"/>

  <result property="bio" column="author_bio"/>

</resultMap>

Because the column names in the results differ from the columns defined in the resultMap, you need to specify columnPrefix to
reuse the resultMap for mapping co-author results.

<resultMap id="blogResult" type="Blog">

  <id property="id" column="blog_id" />

  <result property="title" column="blog_title"/>

  <association property="author"

    resultMap="authorResult" />

  <association property="coAuthor"

    resultMap="authorResult"

    columnPrefix="co_" />

</resultMap>

Multiple ResultSets for Association

Starting from version 3.2.3 MyBatis provides yet another way to solve the N+1 problem.

Some databases allow stored procedures to return more than one resultset or execute more than one statement at once and return a resultset per each one. This can be used to hit the database just once and return related data without
using a join.

In the example, the stored procedure executes the following queries and returns two result sets. The first will contain Blogs and the second Authors.

SELECT * FROM BLOG WHERE ID = #{id}

SELECT * FROM AUTHOR WHERE ID = #{id}

A name must be given to each result set by adding a resultSets attribute to the mapped
statement with a list of names separated by commas.

<select id="selectBlog" resultSets="blogs,authors" resultMap="blogResult">

  {call getBlogsAndAuthors(#{id,jdbcType=INTEGER,mode=IN})}

</select>

Now we can specify that the data to fill the "author" association comes in the "authors" result set:

<resultMap id="blogResult" type="Blog">

  <id property="id" column="id" />

  <result property="title" column="title"/>

  <association property="author" javaType="Author" resultSet="authors" column="author_id" foreignColumn="id">

    <id property="id" column="id"/>

    <result property="username" column="username"/>

    <result property="password" column="password"/>

    <result property="email" column="email"/>

    <result property="bio" column="bio"/>

  </association>

</resultMap>

You've seen above how to deal with a "has one" type association. But what about "has many"? That's the subject of the next section.

collection

<collection property="posts" ofType="domain.blog.Post">

  <id property="id" column="post_id"/>

  <result property="subject" column="post_subject"/>

  <result property="body" column="post_body"/>

</collection>

The collection element works almost identically to the association. In fact, it's so similar, to document the similarities would be redundant. So let's focus on the differences.

To continue with our example above, a Blog only had one Author. But a Blog has many Posts. On the blog class, this would be represented by something like:

private List<Post> posts;

To map a set of nested results to a List like this, we use the collection element. Just like the association element, we can use a nested select, or nested results from a join.

Nested Select for Collection

First, let's look at using a nested select to load the Posts for the Blog.

<resultMap id="blogResult" type="Blog">

  <collection property="posts" javaType="ArrayList" column="id" ofType="Post" select="selectPostsForBlog"/>

</resultMap>

<select id="selectBlog" resultMap="blogResult">

  SELECT * FROM BLOG WHERE ID = #{id}

</select>

<select id="selectPostsForBlog" resultType="Post">

  SELECT * FROM POST WHERE BLOG_ID = #{id}

</select>

There are a number things you'll notice immediately, but for the most part it looks very similar to the association element we learned about above. First, you'll notice that we're using the collection element. Then you'll notice
that there's a new "ofType" attribute. This attribute is necessary to distinguish between the JavaBean (or field) property type and the type that the collection contains. So you could read the following mapping like this:

<collection property="posts" javaType="ArrayList" column="id" ofType="Post" select="selectPostsForBlog"/>

Read as: "A collection of posts in an ArrayList of type Post."

The javaType attribute is really unnecessary, as MyBatis will figure this out for you
in most cases. So you can often shorten this down to simply:

<collection property="posts" column="id" ofType="Post" select="selectPostsForBlog"/>

Nested Results for Collection

By this point, you can probably guess how nested results for a collection will work, because it's exactly the same as an association, but with the same addition of the ofType attribute
applied.

First, let's look at the SQL:

<select id="selectBlog" resultMap="blogResult">

  select

  B.id as blog_id,

  B.title as blog_title,

  B.author_id as blog_author_id,

  P.id as post_id,

  P.subject as post_subject,

  P.body as post_body,

  from Blog B

  left outer join Post P on B.id = P.blog_id

  where B.id = #{id}

</select>

Again, we've joined the Blog and Post tables, and have taken care to ensure quality result column labels for simple mapping. Now mapping a Blog with its collection of Post mappings is as simple as:

<resultMap id="blogResult" type="Blog">

  <id property="id" column="blog_id" />

  <result property="title" column="blog_title"/>

  <collection property="posts" ofType="Post">

    <id property="id" column="post_id"/>

    <result property="subject" column="post_subject"/>

    <result property="body" column="post_body"/>

  </collection>

</resultMap>

Again, remember the importance of the id elements here, or read the association section above if you haven't already.

Also, if you prefer the longer form that allows for more reusability of your result maps, you can use the following alternative mapping:

<resultMap id="blogResult" type="Blog">

  <id property="id" column="blog_id" />

  <result property="title" column="blog_title"/>

  <collection property="posts" ofType="Post" resultMap="blogPostResult" columnPrefix="post_"/>

</resultMap>

<resultMap id="blogPostResult" type="Post">

  <id property="id" column="id"/>

  <result property="subject" column="subject"/>

  <result property="body" column="body"/>

</resultMap>

Multiple ResultSets for Collection

As we did for the association, we can call an stored procedure that executes two queries and returns two result sets, one with Blogs and another with Posts:

SELECT * FROM BLOG WHERE ID = #{id}

SELECT * FROM POST WHERE BLOG_ID = #{id}

A name must be given to each result set by adding a resultSets attribute to the mapped
statement with a list of names separated by commas.

<select id="selectBlog" resultSets="blogs,posts" resultMap="blogResult">

  {call getBlogsAndPosts(#{id,jdbcType=INTEGER,mode=IN})}

</select>

We specify that the "posts" collection will be filled out of data contained in the result set named "posts":

<resultMap id="blogResult" type="Blog">

  <id property="id" column="id" />

  <result property="title" column="title"/>

  <collection property="posts" ofType="Post" resultSet="posts" column="id" foreignColumn="blog_id">

    <id property="id" column="id"/>

    <result property="subject" column="subject"/>

    <result property="body" column="body"/>

  </collection>

</resultMap>

NOTE There's
no limit to the depth, breadth or combinations of the associations and collections that you map. You should keep performance in mind when mapping them. Unit testing and performance testing of your application goes a long way toward discovering the best approach
for your application. The nice thing is that MyBatis lets you change your mind later, with very little (if any) impact to your code.

Advanced association and collection mapping is a deep subject. Documentation can only get you so far. With a little practice, it will all become clear very quickly.

discriminator

<discriminator javaType="int" column="draft">

  <case value="1" resultType="DraftPost"/>

</discriminator>

Sometimes a single database query might return result sets of many different (but hopefully somewhat related) data types. The discriminator element was designed to deal with this situation, and others, including class inheritance
hierarchies. The discriminator is pretty simple to understand, as it behaves much like a switch statement in Java.

A discriminator definition specifies column and javaType attributes. The column is where MyBatis will look for the value to compare. The javaType is required to ensure the proper kind of equality test is performed (although String
would probably work for almost any situation). For example:

<resultMap id="vehicleResult" type="Vehicle">

  <id property="id" column="id" />

  <result property="vin" column="vin"/>

  <result property="year" column="year"/>

  <result property="make" column="make"/>

  <result property="model" column="model"/>

  <result property="color" column="color"/>

  <discriminator javaType="int" column="vehicle_type">

    <case value="1" resultMap="carResult"/>

    <case value="2" resultMap="truckResult"/>

    <case value="3" resultMap="vanResult"/>

    <case value="4" resultMap="suvResult"/>

  </discriminator>

</resultMap>

In this example, MyBatis would retrieve each record from the result set and compare its vehicle type value. If it matches any of the discriminator cases, then it will use the resultMap specified
by the case. This is done exclusively, so in other words, the rest of the resultMap is ignored (unless it is extended, which we talk about in a second). If none of the cases match, then MyBatis simply uses the resultMap as defined outside of the discriminator
block. So, if the carResult was declared as follows:

<resultMap id="carResult" type="Car">

  <result property="doorCount" column="door_count" />

</resultMap>

Then ONLY the doorCount property would be loaded. This is done to allow completely independent groups of discriminator cases, even ones that have no relationship to the parent resultMap. In this case we do of course know that
there's a relationship between cars and vehicles, as a Car is-a Vehicle. Therefore, we want the rest of the properties loaded too. One simple change to the resultMap and we're set to go.

<resultMap id="carResult" type="Car" extends="vehicleResult">

  <result property="doorCount" column="door_count" />

</resultMap>

Now all of the properties from both the vehicleResult and carResult will be loaded.

Once again though, some may find this external definition of maps somewhat tedious. Therefore there's an alternative syntax for those that prefer a more concise mapping style. For example:

<resultMap id="vehicleResult" type="Vehicle">

  <id property="id" column="id" />

  <result property="vin" column="vin"/>

  <result property="year" column="year"/>

  <result property="make" column="make"/>

  <result property="model" column="model"/>

  <result property="color" column="color"/>

  <discriminator javaType="int" column="vehicle_type">

    <case value="1" resultType="carResult">

      <result property="doorCount" column="door_count" />

    </case>

    <case value="2" resultType="truckResult">

      <result property="boxSize" column="box_size" />

      <result property="extendedCab" column="extended_cab" />

    </case>

    <case value="3" resultType="vanResult">

      <result property="powerSlidingDoor" column="power_sliding_door" />

    </case>

    <case value="4" resultType="suvResult">

      <result property="allWheelDrive" column="all_wheel_drive" />

    </case>

  </discriminator>

</resultMap>

NOTE Remember
that these are all Result Maps, and if you don't specify any results at all, then MyBatis will automatically match up columns and properties for you. So most of these examples are more verbose than they really need to be. That said, most databases are kind
of complex and it's unlikely that we'll be able to depend on that for all cases.

<select id="selectUsers" resultType="User">

  select

    user_id             as "id",

    user_name           as "userName",

    hashed_password

  from some_table

  where id = #{id}

</select>

<resultMap id="userResultMap" type="User">

  <result property="password" column="hashed_password"/>

</resultMap>

<select id="selectBlog" resultMap="blogResult">

  select

    B.id,

    B.title,

    A.username,

  from Blog B left outer join Author A on B.author_id = A.id

  where B.id = #{id}

</select>

<resultMap id="blogResult" type="Blog">

  <association property="author" javaType="Author" resultMap="authorResult"/>

</resultMap>

<resultMap id="authorResult" type="Author">

  <result property="username" column="author_username"/>

</resultMap>

<select id="selectUsers" resultType="User" autoMapping="false">

  select

    user_id             as "id",

    user_name           as "userName",

    hashed_password

  from some_table

  where id = #{id}

</select>

<cache/>

<cache

  eviction="FIFO"

  flushInterval="60000"

  size="512"

  readOnly="true"/>

Using a Custom Cache

In addition to customizing the cache in these ways, you can also completely override the cache behavior by implementing your own cache, or creating an adapter to other 3rd party caching solutions.

<cache type="com.domain.something.MyCustomCache"/>

This example demonstrates how to use a custom cache implementation. The class specified in the type attribute must implement the org.apache.ibatis.cache.Cache interface and provide a constructor that gets an String id as an argument.
This interface is one of the more complex in the MyBatis framework, but simple given what it does.

public interface Cache {

  String getId();

  int getSize();

  void putObject(Object key, Object value);

  Object getObject(Object key);

  boolean hasKey(Object key);

  Object removeObject(Object key);

  void clear();

}

To configure your cache, simply add public JavaBeans properties to your Cache implementation, and pass properties via the cache Element, for example, the following would call a method called setCacheFile(String
file) on your Cache implementation:

<cache type="com.domain.something.MyCustomCache">

  <property name="cacheFile" value="/tmp/my-custom-cache.tmp"/>

</cache>

You can use JavaBeans properties of all simple types, MyBatis will do the conversion.

NOTE Settings
of cache (like eviction strategy, read write..etc.) in section above are not applied when using Custom Cache.

It's important to remember that a cache configuration and the cache instance are bound to the namespace of the SQL Map file. Thus, all statements in the same namespace as the cache are bound by it. Statements can modify how they
interact with the cache, or exclude themselves completely by using two simple attributes on a statement-by-statement basis. By default, statements are configured like this:

<select ... flushCache="false" useCache="true"/>

<insert ... flushCache="true"/>

<update ... flushCache="true"/>

<delete ... flushCache="true"/>

Since that's the default, you obviously should never explicitly configure a statement that way. Instead, only set the flushCache and useCache attributes if you want to change the default behavior. For example, in some cases you
may want to exclude the results of a particular select statement from the cache, or you might want a select statement to flush the cache. Similarly, you may have some update statements that don't need to flush the cache upon execution.

cache-ref

Recall from the previous section that only the cache for this particular namespace will be used or flushed for statements within the same namespace. There may come a time when you want to share the same cache configuration and
instance between namespaces. In such cases you can reference another cache by using the cache-ref element.

<cache-ref namespace="com.someone.application.data.SomeMapper"/>