MyBatis Mapper 常用功能配置

1、MyBatis Mapper文件中的if 标签判断特定字符串是否相等：

        <!-- 仅仅查询普通用户  --> 
		<if test="isCommon != null and isCommon !=''"> 
			<if test="isCommon == '1'.toString()"> 
				AND AUTH_USER.USER_CATEGORY = 'COMMON_USER' 
			</if> 
		</if>

2、MyBatis Mapper 文件中的delete 标签批量删除用户集合

  <delete id="deleteBySids" parameterType="java.util.List"> 
  		 delete from data_category where id_  in 
  		 <foreach collection="list" item="item"  index="index" open="(" close=")" separator=","> 
            #{item} 
  		 </foreach> 
  </delete>

3、MyBatis Mapper文件中choose when otherise 标签使用= if else 标签

    <!--if else 标签判断  --> 
  		<choose> 
  			<when test="order != null and order != '' and order == '1'.toString()"> 
  				order by arch_info.created_dt desc 
  			</when> 
  			<otherwise> 
		  		order by arch_info.created_dt asc 
  			</otherwise> 
  		</choose>

4、MyBatis Mapper 文件中if 标签判断整数类型是否相等

  <choose> 
	    	<when test="type!= null and type== 2"> 
	    		and type = 2 
	    	</when> 
	    	<otherwise> 
	    		and type = 1 
	    	</otherwise> 
	    </choose>

注意:mybatis默认将integer=0的参数等于‘’空串 = type ==''

5、MyBatis Mapper 文件中if 标签判断List 集合不能为空

 <if test="sids != null and sids.size() > 0"> 
	    	and sid not in  
	    	<foreach collection="sids" item="item" open="(" separator="," close=")"> 
		      		#{item} 
		    </foreach> 
	    </if>