mybatis，数组和集合分别作为条件的写法

Mapper.java

public int deletePerStaffEducationByIds(String[] educationIds);

Mapper.xml

        delete from per_staff_education where education_id in 
       
            #{educationId}
       
   

修改

public int updateStorageDStatus(@Param("rowIds") List rowIds);

        update material_in_storage_d set status = '1' where row_id in 
                    separator="," open="(" close=")">
            #{item}
        
   

查询

public List selectMaterialInStorageDByRowIds(@Param("rowIds") List rowIds);

        SELECT 
            DISTINCT parent_id 
        from material_in_storage_d where row_id in 
       
            #{item}