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>
或
materialname like concat('%', #{materialname}, '%')