<where>
  <choose>
    <when test="ids == null">
      <if test="name != null">
        displayNm LIKE CONCAT('%', #{name}, '%')
      </if>
    </when>
    <otherwise>
      AND id IN ( <foreach collection="ids" item="id" separator=",">#{id}</foreach> )
    </otherwise>
  </choose>
</where>

insert into user(name, gender, email)
values
<foreach collection="members" item="item" separator=",">
(
    #{item.name}
  , #{item.gender}
  , #{item.email}
)
</foreach>
on duplicate key update
  name = values(name)
  gender = values(gender)
  email = values(email)

<insert id="insertAuthor" useGeneratedKeys="true" keyProperty="id">
  insert into Author (username,password,email,bio)
  values (#{username},#{password},#{email},#{bio})
</insert>

<insert id="insertAuthor" useGeneratedKeys="true"
    keyProperty="id">
  insert into Author (username, password, email, bio) values
  <foreach item="item" collection="list" separator=",">
    (#{item.username}, #{item.password}, #{item.email}, #{item.bio})
  </foreach>
</insert>

<insert id="addUser" parameterType="User">
  <selectKey keyProperty="userId,userName" resultType="User" order="AFTER">
    SELECT USER_ID AS userId
         , USER_NAME AS userName
    FROM USER
    ORDER BY USER_ID DESC
    LIMIT 1
  </selectKey>
  INSERT INTO USER(col1, ...)
  VALUES (#{...}, ...)
</insert>

<id property="id" column="컬럼명"/>

<result property="필드명" column="컬럼명"/>

<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>

<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>

<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>

<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_" />       <!--결과매핑을 재사용하기 위해 columnPrefix를 명시-->
</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>

<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>

<insert id="insertName">
insert into table (col1) values (#{value})
</insert>

List<String> names = new ArrayList<String>();
names.add("Fred");
names.add("Barney");

SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);

try{
  NameMapper mapper = sqlSession.getMapper(NameMapper.class);
  for(String name : names)
    mapper.insertName(name);
  sqlSession.commit();
}finally{
  sqlSession.close();
}