Mybatis 常用代码

查询信息

 UserInfoDO getInfo(@Param("condition") Map<String, Object> condition);

是是

Map<String, Object> condition = new HashMap<>(1);
condition.put("userId", 1);

 

在Java中的复合条件写法

List<UserInfo> listUserInfo(@Param("condition") Map<String, Object> condition);

like

user_name LIKE CONCAT('%',#{condition.userName},'%')

in

<if test="condition.userId != null and !condition.userId.isEmpty()">        
    AND user_id IN
    <foreach collection="condition.userId" index="index" item="item" open="(" separator="," close=")">
    #{item}
    </foreach>
</if>

判断字符串（结合org.apache.commons.lang3）

<if test="@org.apache.commons.lang3.StringUtils@isNotBlank(condition.userName)">
    AND user.user_name = #{condition.userName}
</if>

 

UserInfoDO getUserInfo(@Param("condition") Map<String, Object> condition);