Mybatis实现条件查询
javaBean对应的映射文件方法<select id="getAllHistoryInfo" resultType="hashmap"
parameterType="historyAlarm">
<![CDATA[
select
history.*,alarmConfig.alarmZhName,alarmConfig.alarmEnName,alarmConfig.alarmType as almType
from
historyAlarmInfo history
left JOINAlarmInfoConfig alarmConfig on history.alarmID=alarmConfig.alarmID
where 1=1
]]>
<if test="hnbID != null and '' != hnbID">
<![CDATA[
AND history.hnbID = #{hnbID}
]]>
</if>
<if test="alarmID != null and '' != alarmID">
<![CDATA[
AND history.alarmID = #{alarmID}
]]>
</if>
<if test="alarmType != null and '' != alarmType">
<![CDATA[
AND alarmConfig.alarmType = #{alarmType}
]]>
</if>
<if test="perceivedSeverity != null and '' != perceivedSeverity">
<![CDATA[
AND history.perceivedSeverity = #{perceivedSeverity}
]]>
</if>
<if test="probableCause != null and '' != probableCause">
<![CDATA[
AND history.probableCause like '%' #{probableCause} '%'
]]>
</if>
<if test="startAlarmRaisedTime != null and '' != startAlarmRaisedTime">
<![CDATA[
AND history.alarmRaisedTime >= #{startAlarmRaisedTime}
]]>
</if>
<if test="endAlarmRaisedTime != null and '' != endAlarmRaisedTime">
<![CDATA[
AND history.alarmRaisedTime <= #{endAlarmRaisedTime}
]]>
</if>
<if test="clearedManner != null">
<![CDATA[
AND history.clearedManner = #{clearedManner}
]]>
</if>
</select>
parameterType="historyAlarm"：表示又业务层传进来的参数，该参数是MyBatis映射配置文件的映射对象。
页:
[1]