MyBatis

SQL拼接 concat或者如下方式

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