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>