Mybatis中Mysql choose条件选择

1:定义model

Model.java

public class Page {

    private int page = 1;

    private int count = 0；

    private Map sorting = Maps.newHashMap();

}

2:定义mapper接口

Mapper.java

public interfaceMemberInfoMapper {

    ListgetByOrgId(Page page);

}

3：编写mapper.xml

sql语句

select * from user_hospital uh

where 1 = 1

<choose>

<when test="sorting != null and sorting.size()>0 ">

<foreach item="orderDirection" index="orderField" collection="sorting" open="order by" separator="," close"">

    ${orderField} ${orderDirection}

</foreach>

<when>

<when test = "orderField != null and orderField != '' and orderDirection != null and orderDirection != ''">

    order by ${orderField} ${orderDirection}

</when>

<otherwise>

    order by last_time desc

</otherwise>

</choose>