mybatis动态Sql实现批量添加和批量删除

比眉伴天荒 2022-04-08 12:17 1020阅读 0赞

mybatis动态Sql实现批量添加和批量删除：  
新建一个domainMapper接口：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]接下来写：domainMapper.xml配置，在本利中即：UserMapper.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="cn.itsource.mybatis.batch_options.UserMapper">
        
        <select id="saveBatch" parameterType="list">
    
            INSERT INTO user (username,password) VALUES
    
            <foreach collection="list" item="user" separator=",">
                (#{user.username},#{user.password})
            </foreach>
    
        </select>
    
    
        <delete id="deleteBatch" parameterType="list">
    
            delete from user where id in
    
            <foreach collection="list" item="id" open="(" close=")" separator=",">
                #{id}
            </foreach>
    
        </delete>
    </mapper>

注意在mybatis的主配置文件中，引入该UserMapper.xml文件：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1]自定义工具类获得SqlSession对象：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2]

测试：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]: /images/20220405/c4fa5e7917cc4b579fe1d3ce3a1b5938.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1]: /images/20220405/43ded8ec913449b3ad6bbe601e70672b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2]: /images/20220405/71fe99f52a1446aebcd4866223d9c646.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3]: /images/20220405/1fc2ba32c68c4e1fb61b7e69eb1bf974.png