记MySQL中if条件语句以及include标签的用法

if条件语句

//如果条件判断为true则执行表达式1即   select * from project p where p.VALID_STATUS = '1' and p.BELONG_ORG = #{belongOrg}
//如果条件判断为false则执行表达式2即  select * from project p where p.VALID_STATUS = '1' and p.CREATED_ORG = #{departCode}
select *
from project p
where p.VALID_STATUS = '1'
and if(p.BELONG_ORG = #{belongOrg}//条件判断
                , p.BELONG_ORG = #{belongOrg}//表达式1
                , p.CREATED_ORG = #{departCode})//表达式2

include标签

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.com.git.dgmsdi.api.mapper.project.ProjectMapper">
    <sql id="limitSql">
        <choose>
            <when test="limitFlag != null and limitFlag == 1">
                and if(p.BELONG_ORG = #{belongOrg}
                , p.BELONG_ORG = #{belongOrg}
                , p.CREATED_ORG = #{departCode})
            </when>
            <when test="limitFlag != null and limitFlag == 2">
                and p.CREATED_ORG = #{departCode})
            </when>
            <otherwise>
            </otherwise>
        </choose>
    </sql>
</mapper>

//注：choose标签，当满足when中的条件时则执行when中的代码，然后跳出choose；当when中的条件都不满足时则执行otherwise中的代码
//如果是同一个xml文件则直接调用id
<include refid="limitSql"/>
//如果是不同的xml文件需调用此sql的路径全称
<include refid="cn.com.git.dgmsdi.api.mapper.project.ProjectMapper.limitSql"/>