mybatis-模糊查询like CONCAT

最新推荐文章于 2025-04-04 21:50:18 发布

原创最新推荐文章于 2025-04-04 21:50:18 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

CLAA 专栏收录该内容

221 篇文章

订阅专栏

本文介绍了一个使用MyBatis的SQL映射文件，用于根据参数查询设备操作日志的方法。通过LEFT JOIN连接用户表，实现了按设备EUI、订单号、操作描述等条件筛选，并按操作时间降序排列。

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

<select id="queryAllOsmDevOplogByPara" resultType="com.zte.claa.infiboss.app.model.osm.OsmDevOplog">
	   SELECT   t.DEVEUI AS deveui, 
		    t.DEVTYPE AS devType, 
		    t.ORDNO AS ordNo, 
		    t.CLAANO AS claaNo, 
		    t.OPTIME AS opTime, 
		    t.REMARK AS remark, 
		    t.OPDESCP AS opDescp, 
		    t.OPERATOR AS operator,
		    t.USERID AS userid,
		    t.OPFLAG AS opFlag,
		    u.USERNAME AS username
	   FROM  t_osm_dev_oplog t LEFT JOIN t_cgs_sm_user u 
	   ON t.USERID = u.USERID 
	   WHERE 1 = 1 
	  <if test='para.deveui != null and para.deveui != "" '>
		 AND t.DEVEUI = #{para.deveui, jdbcType=VARCHAR} 
	  </if>
	  <if test='para.ordNo != null and para.ordNo != "" '>
		 AND t.ORDNO = #{para.ordNo, jdbcType=VARCHAR} 
	  </if>
	  <if test='para.opDescp != null and para.opDescp != "" '>
		 AND t.OPDESCP like CONCAT('%',#{para.opDescp, jdbcType=VARCHAR},'%')
	  </if>
	  ORDER BY t.OPTIME DESC  
</select>