MyBatis中时间段内另一种比较方式

最新推荐文章于 2024-06-02 14:14:19 发布

烟火缠过客

最新推荐文章于 2024-06-02 14:14:19 发布

阅读量865

点赞数

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.youkuaiyun.com/LuckFairyLuckBaby/article/details/92767720

由于未提供博客具体内容，无法生成包含关键信息的摘要。

	<select id="getLoginLogs222222" resultType="map" parameterType="com.baomidou.mybatisplus.plugins.Page">
		select * from sys_login_log where 1 = 1
		<if test="beginTime != null and beginTime !='' and endTime != null and endTime != ''">
			and (createTime between CONCAT(#{beginTime},' 00:00:00') and CONCAT(#{endTime},' 23:59:59'))
		</if>
		<if test="logName != null and logName !=''">
			and logname like CONCAT('%',#{logName},'%')
		</if>
		<choose>
			<when test="orderByField != null and orderByField !=''">
				<choose>
					<when test="isAsc == true">
						order by ${orderByField} ASC
					</when>
					<otherwise>
						order by ${orderByField} DESC
					</otherwise>
				</choose>
			</when>
			<otherwise>
				order by createtime DESC
			</otherwise>
		</choose>
	</select>