CDATA

Mr.ninglixin

于 2021-04-12 15:00:44 发布

阅读量90

点赞数

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/weixin_46572329/article/details/115622728

版权

mybatis 专栏收录该内容

5 篇文章

订阅专栏

这个sql是点击修改时除了自己本身的id在数据库中是否有重复的

   <select id="departmentNo" resultMap="departmentInfoColumns">
        SELECT id,parent_id,department_no,department_goal_relevancy,department_name,department_type_code,fill_role_id,
        master_no,master_name,sys_office_id
        FROM department_performance_assessment_department_info
        WHERE department_no = #{departmentNo} and  del_flag='0' and <![CDATA[ id <> ]]> #{id}
    </select>