mybatis批量删除sql语法

数据库信息

mysql> select * from fz02;
+----+
| id |
+----+
|  3 |
|  4 |
|  5 |
|  6 |
|  7 |
|  8 |
|  9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
+----+
13 rows in set (0.00 sec)

mysql>

mapper.xml文件

<delete id="deleteid">
        delete from fz02 where id in (${user1.id},${user2.id})
</delete>

User对象

public class User {
    private int id;

    public User(){}
    public User(int id) {
        this.id = id;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                '}';
    }
}

mapper接口

public interface Usermapper {
    void deleteid(@Param("user1")User user,@Param("user2")User user2);
}

开始调用

@Test
    public void a1() throws Exception{
        InputStream inputStream = Resources.getResourceAsStream("mybatis_.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
        SqlSession session = sqlSessionFactory.openSession(true);

        Usermapper usermapper = session.getMapper(Usermapper.class);
        usermapper.deleteid(new User(2),new User(1));

        inputStream.close();
        session.close();
    }

运行结果

mapper接口的sql语句还可以改为

<delete id="deleteid">
        delete from fz02 where id in (#{user1.id},#{user2.id})
</delete>

运行结果