mybatis特殊用法

为了补充自己这垃圾脑袋 还是吧重要的知识记一记吧

    
    @Select("select ee.member_id memberId, ee.real_name realName, "
            + " case when ee.sex = 0 then '女' else '男' end as sex,"
            + " ee.mobile_phone mobilePhone,"
            + " ee.occupation, esc.type"
            + " from eismp_init.eismp_employer ee"
            + " inner join eismp_init.eismp_safety_committee esc"
            + " on ee.member_id = esc.member_id"
            + " where ee.del_flag = 0"
            + " and ee.is_safety_committee = 1"
            + " and esc.del_flag = 0"
            + " and ee.real_name like '%${realName}%'"
            + " and ee.mobile_phone like '%${mobilePhone}%'")
    List getEmployerList(@Param("realName") String realName,
                                             @Param("mobilePhone") String mobilePhone);


ne") String mobilePhone);

小结:新建一个字段Java进行判断也是可以的,当喜欢上了plus的也不会去写SQL语句了