search

BestDI / BestDI.github.io

Mia's Home
https://bestdi.github.io
1 stars 0 forks source link

Ⓜ️ Mybatis 使用良药积累 #50

Open BestDI opened 4 years ago

BestDI commented 4 years ago

1. Mybatis like模糊查询拼接

example:

<!-- Way 1 -->
<if test="projectName!=null and projectName!=''">
    <bind name="projectName_" value="'%'+projectName+'%'"/>
    AND info.name like #{projectName_}
</if>
<!-- Way 2 -->
<if test="projectName!=null and projectName!=''">
    AND info.name like concat('%',#{projectName_},'%')
</if>