MyBatis

SQL拼接 concat或者如下方式

<if test="pickslipCode != null">
    <bind name="pickslipCodeLike" value="'%' + pickslipCode + '%'"/>
                and PickslipCode LIKE #{pickslipCodeLike}
</if>
复制代码

转载于:https://juejin.im/post/5a31d34ef265da4307034683