<!--resultType="int"--><selectid="count"resultType="int">
select count(*) from ams_admin
</select><!--resultMap="BaseResultMap"--><selectid="getById"resultMap="BaseResultMap">
select
<includerefid="xxx"/>
from ams_admin where id=#{id}
</select><!--多表查询--><!-- AdminDetailsVO getDetailsById(Long id); --><selectid="getDetailsById"resultMap="DetailsResultMap">
select
<includerefid="DetailsQueryFields"/>
from ams_admin
left join ams_admin_role on ams_admin.id = ams_admin_role.admin_id
left join ams_role on ams_role.id = ams_admin_role.role_id
where ams_admin.id=#{id}
</select><sqlid="DetailsQueryFields"><iftest="true">
ams_admin.id, ams_admin.username, ams_admin.gmt_modified,
ams_role.id AS role_id, ams_role.name AS role_name,
...
</if></sql><resultMapid="BaseResultMap"type="cn.tedu.mybatis.entity.Admin"><idcolumn="id"property="id"/><resultcolumn="username"property="username"/>
...
<resultcolumn="gmt_modified"property="gmtModified"/></resultMap>
1. delete from ams_admin where id in (
<foreachcollection="array"item="id"separator=",">
#{id}
</foreach>
)
2. delete from ams_admin where id in
<foreachcollection="array"item="id"separator=","open="(",close=")">
#{id}
</foreach>
3.insert
into oms_order_item(id, ... , quantity)
values
<foreachcollection="omsOrderItems"item="ooi"separator=",">
(#{ooi.id}, ... , #{ooi.quantity})
</foreach>