sqlserver写法:
<select id="queryVehicleRfidInfo" resultMap="BaseResultMap" parameterType="com.tis.entity.VehicleRfidInfo">
select * from VEHICLE_RFID_INFO where 1=1
<if test="licence!=null and licence!=''">
and VEHICLE_RFID_INFO.LICENCE LIKE '%'+#{licence,jdbcType=NVARCHAR}+'%'
</if>
<if test="vehicleOwner != null and vehicleOwner != ''">
and VEHICLE_RFID_INFO.VEHICLE_OWNER LIKE '%'+#{vehicleOwner,jdbcType=NVARCHAR}+'%'
</if>
</select>
mysql写法:
<select id="queryVehicleInfo" resultMap="BaseResultMap" parameterType="com.zit.entity.VehicleInfo">
select * from vehicle_info where 1=1
<if test="hphm != null and '' != hphm">
<bind name="pattern_hphm" value="'%'+hphm+'%'"/>
and hphm like #{pattern_hphm}
</if>
</select>