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;
}
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/92376.html
