1.Ibatis的批量添加
<!--resultMap是你自己定义的-->
<insert id="Add" resultMap="Person" parameterClass="list">
<![CDATA[
insert all
]]>
<iterate conjunction="">
into SYS_TABLE
(id,Category,Name,Code,Status)
values(
#[].Id#,
#[].Category#,
#[].Name#,
#[].Code#,
#[].Status#)
</iterate>
<!--下面这句必须加,不然会提示找不到SELECT-->
<![CDATA[
select * from dual
]]>
</insert>
2.Ibatis的批量删除
<delete id="Del" resultMap="Person" parameterClass="list">
delete
from SYS_TABLE
where id in
<iterate conjunction="," open="(" close=")">
#[]#
</iterate>
</delete>
3.Ibatis的批量修改
<update id="Update" resultMap="Person" parameterClass="list">
begin
<iterate conjunction="">
update SYS_TABLE set
Category=#[].Category#,
Name =#[].Name#,
Code =#[].Code#,
Status =#[].Status#
where id = #[].Id#;
</iterate>
end;
</update>
4.Ibatis的批量查询
<select id="select" resultMap="Person" parameterClass="list">
select *
from SYS_TABLE
where
payee=#payee# //这是单独的一个字段,如果只有一个list,可以不写这个
<isNotEmpty prepend="and" property="list">
id //这是要遍历的字段
<iterate prepend="in" property="list" conjunction="," open="(" close=")">
#list[]#
</iterate>
</isNotEmpty
</select>