mybatis拼接查询条件

最新推荐文章于 2025-05-16 18:18:14 发布

shjniu3000

最新推荐文章于 2025-05-16 18:18:14 发布

阅读量3.3k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： web后端文章标签： mybatis 条件分割

本文链接：https://blog.youkuaiyun.com/shjniu3000/article/details/51957216

web后端专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的报警记录查询模块。该模块定义了报警记录的映射关系，并通过不同的SQL配置实现了基于条件筛选的报警记录查询功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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) &gt;= #{startDate,jdbcType=VARCHAR} and 
			    </if>
			    <if test="endDate != null and endDate !=''" >
			     DATE(alarm_time) &lt;= #{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>