mybatis 标签 if else和choose when 的使用方法

mybatis | 2019-11-19 13:45:19

1. mybatis if else

mybatis 有if 没有else,但你可以用多个if 来实现

<!--使用 if 元素根据条件动态查询用户信息-->
<select id="selectUserByIf" resultType="com.po.MyUser" parameterType="com.po.MyUser">
    select * from user where 1=1
    <if test="a==1">
        and uname like concat('%',#{uname},'%')
    </if >
    <if test="a=='2'">
        and usex=#{usex}
    </if >
</select>

 

2.mybatis choose when

在mybatis里面没有if else 用的是when和otherwise这两个标签，choose是最外层包含的

choose>
	<when test="">
	  
	</when>
	<otherwise>
		
	</otherwise>
</choose>

 

登录后即可回复 登录 | 注册
    
相关文章
scala中的 if else 语句php 流程控制 elseif/else ifphp directoryiterator determine if current directoryiterator item is . or .. php deque determines if the deque contains given valuesphp ingres 函数 test if the connection is using autocommitphp posix 函数 determine if a file descriptor is an interactive terminalphp svn 函数 return true if props are different false otherwisephp imagick checks if the object has more imagesphp intlchar check if code point is a space character according to javaphp intltimezone check if this zone has the same rules and offset as another zonephp mongodb driver readconcern checks if this is the default read concernphp mysql xdevapi statement check if more resultsphp recursivearrayiterator returns an iterator for the current entry if it is an array or an objectphp reflectionproperty checks if property is a default propertyphp solrdocument checks if a field existsphp splfileinfo tells if the file is a linkphp swoole client check if the connection is established.php tidynode checks if a node has siblingsphp zookeeper checks if the current zookeeper connection state can be recoveredmybatis 标签 if else和choose when 的使用方法
关注编程学问公众号