src/main/java/com/lwb/hr/mapper/xml/EmployeeMapper.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lwb.hr.mapper.EmployeeMapper">


    <update id="updateDelEmp" parameterType="com.lwb.hr.entity.Employee">
        UPDATE employee
        <set>
            <if test="employeeName != null">
                employee_name = #{employeeName},
            </if>
            <if test="employeeGender != null">
                employee_gender = #{employeeGender},
            </if>
            <if test="employeeBirthday != null">
                employee_birthday = #{employeeBirthday},
            </if>
            <if test="employeeTelephone != null">
                employee_telephone = #{employeeTelephone},
            </if>
            <if test="employeeEmail != null">
                employee_email = #{employeeEmail},
            </if>
            <if test="employeeAddress != null">
                employee_address = #{employeeAddress},
            </if>
            <if test="employeeEducation != null">
                employee_education = #{employeeEducation},
            </if>
            <if test="notes != null">
                notes = #{notes}
            </if>
        </set>
        where employee_number = #{employeeNumber} and deleted = 0;
    </update>





</mapper>