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 a symbolic linkphp vector determines if the vector contains given valuesphp soap 函数 checks if a soap call has failedphp sqlite 函数 opens an sqlite database and create the database if it does not existphp wincache 函数 adds a variable in user cache only if variable does not already exist in the cachephp intlchar check if code point is an alphanumeric characterphp intlchar check if code point is a printable characterphp locale checks if a language tag filter matches with localephp mongo choose a new secondary for slaveokay readsphp mongodb driver server checks if this server is a passive member of a replica setphp mysqli stmt check if there are more query results from a multiple queryphp reflectionclassconstant checks if class constant is privatephp reflectionproperty checks if property is publicphp solrinputdocument checks if a field existsphp splheap tells if the heap is in a corrupted statephp swoole http client check if the http connection is connected.php tidynode checks if a node is part of a html documentmybatis 标签 if else和choose when 的使用方法
关注编程学问公众号