1.背景
使用编号和名字查询数据,其中名字为模糊查询.
2.解决方案
<select id="selectAccordingTotheNumberandname" parameterType="java.util.Map" resultMap="DegreeBaseResultMap">
SELECT
pd.tuid,pd.donation_logo,pd.donation_degree,pd.donation_code,pd.slogan,
pd.create_by,pd.owner_id,pd.created,pd.updated,pd.delete_flag,pd.delete_by,pd.donation_num,
pd.donation_name,pd.start_age,pd.end_age,pd.join_type,pd.fruit_balance,pdd.ren_num
FROM pm_donation pd
LEFT JOIN
pm_donation_degree pdd
ON
pd.donation_degree = pdd.degree
WHERE
delete_flag = #{deleteFlag}
<if test="donationMessage != null">
AND
(
donation_code = #{donationMessage}
OR
LOCATE(#{donationMessage},donation_name)>0
)
</if>
</select>
最后一个AND连接的( donation_code = #{donationMessage} OR LOCATE(#{donationMessage}, donation_name)>0)