Mybatis oracle常用语句

修改多个数据：
<update id="del">
<foreach item="item" index="index" collection="array"  separator=";" open="begin" close=";end;">
           update  tb_sy_duty 
           <set>  
             del_flag = '1' 
           </set> 
           where id = #{item}
</foreach> 
</update>




模糊搜索：
<select id="findDepartList" resultType="TbSyDepartment">
SELECT 
<include refid="tbSyDepartmentColumns"/>
FROM tb_sy_department a
<include refid="tbSyDepartmentJoins"/>
<where>
a.del_flag = #{DEL_FLAG_NORMAL}
</where>
<if test="id != null and id != ''">
and a.id = #{id} or a.depart_pids like '%'||#{id}||'%'
</if>
ORDER BY  to_number(a.depart_sort)  asc   
</select>


添加多个数据：
<select id="findDepartList" resultType="TbSyDepartment">
SELECT 
<include refid="tbSyDepartmentColumns"/>
FROM tb_sy_department a
<include refid="tbSyDepartmentJoins"/>
<where>
a.del_flag = #{DEL_FLAG_NORMAL}
</where>
<if test="id != null and id != ''">
and a.id = #{id} or a.depart_pids like '%'||#{id}||'%'
</if>
ORDER BY  to_number(a.depart_sort)  asc   
</select>


查询某个字段多个条件：
<select id="findAllRMList" resultType="TbSyRoleMenu">
SELECT 
<include refid="tbSyRoleMenuColumns"/>
FROM tb_sy_role_menu a
<include refid="tbSyRoleMenuJoins"/>
WHERE a.id in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
                 #{item}
</foreach>
GROUP BY RM_MENU_ID 
</select>


删除多条数据：
<delete id="deleteRoleMenu">
DELETE FROM tb_sy_role_menu WHERE id in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
                 #{item}
</foreach> 
</delete>