Mybatis oracle常用语句

g_blue_wind

于 2017-01-07 16:49:19 发布

阅读量864

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle数据库

本文链接：https://blog.youkuaiyun.com/g_blue_wind/article/details/54176064

oracle数据库专栏收录该内容

3 篇文章

订阅专栏

本文介绍使用MyBatis进行批量数据操作的方法，包括批量更新、模糊搜索、批量添加及删除等操作，并展示了具体的XML配置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

修改多个数据：
<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>