【java】mybatis foreach传入list用法

1.xml中的sql

//随便写的sql，不用在意语法
<select id="test" resultMap="storageResultMap">
        select * from storage where 1 = 1
        <foreach collection="list" item="item" index="index">
            <if test="item.name != null and  item.name != ''">
                and `name` = #{item.name}
            </if>
            <if test="item.description != null and  item.description != ''">
                <bind name="pattern" value="'%' + item.description + '%'"/>
                and`description` like #{pattern}
            </if>
        </foreach>
    </select>

2.方法接口

public Object test(@Param("list") List<Storage> storageList);

3.实体类

@Data
@EqualsAndHashCode(callSuper = true)
@TableName("storage")
@ApiModel(value = "对象",description = "对象")
public class Storage extends BaseEntity {
    private static final long serialVersionUID = 1L;

    @TableField(value = "name")
    @ApiModelProperty(value = "名称", required = true)
    private String name;

    @TableField(value = "description")
    @ApiModelProperty(value = "描述", required = true)
    private String description;

}