为了补充自己这垃圾脑袋 还是吧重要的知识记一记吧
数据库类型为数字, 返回需要字符串
@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}%'") ListgetEmployerList(@Param("realName") String realName, @Param("mobilePhone") String mobilePhone); ne") String mobilePhone);
小结:新建一个字段Java进行判断也是可以的,当喜欢上了plus的也不会去写SQL语句了
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)