mybatis之动态SQL操作之删除

最新推荐文章于 2025-01-14 15:48:26 发布

转载最新推荐文章于 2025-01-14 15:48:26 发布 · 319 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/loaderman/p/10064465.html

文章标签：

#java

本文介绍了一个使用MyBatis框架实现的动态SQL删除功能的示例。通过StudentDao类的方法dynaSQLwithDelete，可以传入多个学生ID进行批量删除。在StudentMapper.xml中定义了动态SQL语句，使用foreach标签来遍历传入的ID数组，实现IN子句的动态构建。

/**
 * 持久层
 */
public class StudentDao {
    /**
     * 动态SQL--删除
     */
    public void dynaSQLwithDelete(int... ids) throws Exception{
        SqlSession sqlSession = MyBatisUtil.getSqlSession();
        try{
            sqlSession.delete("mynamespace.dynaSQLwithDelete",ids);
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            sqlSession.commit();
            MyBatisUtil.closeSqlSession();
        }
    }
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        dao.dynaSQLwithDelete(1,3,5,7);
    }
}

StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="mynamespace">
    <!-- item表示迭代的参数 -->
    <delete id="dynaSQLwithDelete">
        delete from students where id in
        <!-- 
        <foreach collection="array" open="(" close=")" separator="," item="ids">
            ${ids}
        </foreach>
        -->    
        <foreach collection="list" open="(" close=")" separator="," item="ids">
            ${ids}
        </foreach>    
    </delete>    
</mapper>