@[TOC](mapper @Select()注解开发,使用模板 if 这里写自定义目录标题)
@Select({"<script>" + "select id, dept_name deptName from dept where pid in (select id from dept where 1=1",
" <when test='deptName!=null and deptName.toString().length() != 0'> ",
"and dept_name = #{deptName}",
" </when> ",
" <when test='deptId != null and deptName.toString().length() != 0'> ",
"and id = #{deptId}",
" </when> ",
")",
"</script>"})