使用mybatis实现模糊查询和精准查询切换的功能

1、首先在前端页面添加勾选框（name设置为check）

 

2、mybatis代码

1. 当check勾选时，check不为null，走模糊查询like
2. 当check未勾选时，check为null，走精准查询 = 

            <if test="check != null and check !='' ">
				<if test="kuangjia != null and kuangjia != ''">
					AND kuangjia like concat('%',#{kuangjia},'%')
				</if>
				<if test="dianji != null and dianji != ''">
					AND dianji like concat('%',#{dianji},'%')
				</if>
			</if>	
			<if test="check == null or check == '' ">
				<if test="kuangjia != null and kuangjia != ''">
					AND kuangjia = #{kuangjia}
				</if>
				<if test="dianji != null and dianji != ''">
					AND dianji = #{dianji}
				</if>
			</if>