mybatis注解@Select中添加判断条件＜script＞

讓丄帝愛伱

已于 2023-11-04 19:24:28 修改

阅读量4.4k

点赞数 2

分类专栏：后端技术文章标签： mybatis 数据库

于 2022-11-27 21:01:59 首次发布

本文链接：https://blog.csdn.net/ximaiyao1984/article/details/128069806

版权

后端技术专栏收录该内容

342 篇文章 2 订阅

订阅专栏

@Select("<script>"
        + "select a.id, a.emp_name, a.emp_no,b.depart_name sys_org_code,c.post_name,c.post_name as post_mutex " +
        "        from ls_emp_info a left join sys_depart b on a.org_code = b.org_code " +
        "        left join ls_emp_post c on a.emp_no = c.emp_no " +
        "        <where>" +
        "            <if test=\"empInfo.empName != null and empInfo.empName != ''\"> " +
        "                a.emp_name like CONCAT('%',#{empInfo.empName},'%'), " +
        "            </if>" +
        "        </where>"
        + "</script>")
IPage<EmpInfo> getPage(Page<EmpInfo> page, QueryWrapper<EmpInfo> queryWrapper, @Param("empInfo") EmpInfo empInfo);

@Select({"<script>"
	+"select * from func_report_waste_crktj(#{startDate},#{endDate}) "
	+" where 1=1  "
	+"<when test= 'khbm!=null'> and khbm=#{khbm} </when>"
	+"<when test= 'lbbm!=null'> and lbbm=#{lbbm} </when>"
	+"<when test= 'djbm!=null'> and djbm=#{djbm} </when>"
	+"</script>"})
List<Map<String,Object>>  getWasteCrktjxxList(Map<String,Object> params);