第在mybatis中使用ifelse進行判斷的操作!--查詢物品的id--

selectid="checkItemsId"parameterType="pd"resultType="java.lang.Integer"

SELECT

i.itemsid

FROMpq_goods_itemsi

where

!--方式一使用choose的方式查詢--

!--choose

whentest="parentId!=0"parentTypeId=#{parentId}/when

whentest="parentId==0"parentTypeIdisnull/when

/choose--

!--方式二使用if的方式查詢--

iftest="color!=null"

i.personone=#{personone}

ANDi.persontwo=#{persontwo}

ANDi.color=#{color}

/if

iftest="color==null"

i.personone=#{personone}

ANDi.persontwo=#{persontwo}

ANDi.colorisnull

/if

/where

/select

需要注意的是使用了where標簽以后，sql中不在使用where字段來限制條件

如果判斷條件有多個中間用and表示并列

iftest="color!=nullandpersonone!=null"

補充：mybaits中if多個test和ifelse分支支持

mybaits中if多個test

selectid="selectByDynamicallyWithPage"parameterType="map"resultMap="BaseResultMap"

select

includerefid="Base_Column_List"/

fromgene_polymorphism

where

diag_id=#{conds.diagId,jdbcType=INTEGER}

iftest="conds.chromesome!=nullandconds.chromesome!=''"

andchromesome=#{conds.chromesome,jdbcType=VARCHAR}

/if

iftest="conds.startPos!=null"

andstart_pos=#{conds.startPos,jdbcType=BIGINT}

/if

/where

/select

ifelse分支：

selectid="selectByDynamicallyWithPage"parameterType="map"resultMap="BaseResultMap"

select

includerefid="Base_Column_List"/

fromgene_polymorphism

where

diag_id=#{conds.diagId,jdbcType=INTEGER}

iftest="conds.chromesome!=null"

andchromesome=#{conds.chromesome,jdbcType=VARCHAR}

/if

iftest="conds.startPos!=null"

andstart_pos=#{conds.startPos,jdbcType=BIGINT}

/if

iftest="conds.endPos!=null"

andend_pos=#{conds.endPos,jdbcType=BIGINT}

/if

iftest="conds.geneTypes!=null"

!--andgene_typein--

!--foreachcollection="conds.geneTypes"open="("close=")"item="item"separator=","--

!--#{item,jdbcType=VARCHAR}--

!--/foreach--

and(

foreachcollection="conds.geneTypes"item="item"separator="or"

gene_typelikeCONCAT('%',CONCAT(#{item,jdbcType=VARCHAR},'%'))

/foreach

/if

iftest="conds.geneChange!=null"

andgene_changelikeCONCAT('%',CONCAT(#{conds.geneChange,jdbcType=VARCHAR},'%'))

/if

/where

orderby

trimsuffixOverrides=","

choose

whentest="conds.chromesomeSort!=nullandconds.chromesomeSort=='asc'"

chromesomeasc,

/when

whentest="conds.chromesomeSort!=nullandconds.chromesomeSort=='desc'"

chromesomedesc,

/when

/choose

choose

whentest="conds.startPosSort!=nullandconds.startPosSort=='asc'"

start_posasc,

/when

whentest="conds.startPosSort!=nullandconds.startPosSort=='desc'"

start_posdesc,

/when

otherwise

iddesc

/otherwise

/choose

/trim

limit#{startRow,jdbcType=INTEGER},#{pageSize,jdbcType=INTEGER}

!