MyBatis if标签

最新推荐文章于 2023-04-23 23:05:08 发布

二楼后座。

最新推荐文章于 2023-04-23 23:05:08 发布

阅读量431

点赞数

分类专栏： # Java框架文章标签： SQL查询员工信息条件筛选数据库JOIN 字符串匹配

本文链接：https://blog.csdn.net/D1124615130/article/details/116854866

版权

Java框架专栏收录该内容

26 篇文章 1 订阅

订阅专栏

List<Staff> getStaffByCondition(@Param("text") String conditionText,
                                            @Param("type") String conditionType,
                                            @Param("gender") String conditionGender,
                                            @Param("j_id") String conditionJob,
                                            @Param("d_id") String conditionDepartment);

<select id="getStaffByCondition" resultMap="base">
        select staff.s_id, staff.s_name, gender, phone, s_address, salary, staff_department_job.d_id, department.d_name
        from staff left join staff_department_job on staff.s_id = staff_department_job.s_id
            join department on staff_department_job.d_id = department.d_id
        where
            <if test="text==null">
                1 = 1
            </if>
            <if test="text!=null">
                <if test="type==null">
                    s_name = #{text} or staff.s_id = #{text} or phone = #{text}
                </if>
                <if test="type!=null">
                    ${type} = #{text}
                </if>
            </if>
            <if test="gender!=null">
                and gender = #{gender}
            </if>
    </select>