<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="mapper.AlarmMapper" >
<resultMap id="AlarmResultMap" type="vo.AlarmRs" >
<result column="alarm_id" property="alarm_id" jdbcType="INTEGER" />
<result column="alarm_level" property="alarm_level" jdbcType="INTEGER" />
<result column="alarm_flag" property="alarm_flag" jdbcType="INTEGER" />
<result column="alarm_time" property="alarm_time" jdbcType="TIMESTAMP" />
<result column="alarm_desc" property="alarm_desc" jdbcType="VARCHAR" />
</resultMap>
<sql id="Base_Column_List" >
alarm_id, alarm_level, alarm_flag, alarm_time, alarm_desc
</sql>
<sql id="tableNameSql">
jy_alarm
</sql>
<sql id="varSql2">
<where>
<trim suffixOverrides="and">
<if test="startDate != null and startDate !=''" >
DATE(alarm_time) >= #{startDate,jdbcType=VARCHAR} and
</if>
<if test="endDate != null and endDate !=''" >
DATE(alarm_time) <= #{endDate,jdbcType=VARCHAR} and
</if>
<if test="level !=3" >
alarm_level = #{level,jdbcType=INTEGER} and
</if>
</trim>
</where>
</sql>
<select id="getAlarmRs" resultMap="AlarmResultMap" parameterType="vo.AlarmCondition">
select
<include refid="Base_Column_List" />
from
<include refid="tableNameSql" />
<include refid="varSql2" />
ORDER BY alarm_time DESC
</select>
<select id="getAlarmRsFirst" resultMap="AlarmResultMap" parameterType="vo.AlarmCondition">
select alarm_id, alarm_level, alarm_flag, alarm_time, alarm_desc from jy_alarm
where DATE(alarm_time) = #{toDay,jdbcType=VARCHAR} ORDER BY alarm_time DESC
</select>
</mapper>
mybatis拼接查询条件
最新推荐文章于 2024-08-09 14:58:21 发布