添加数据判断是否存在存在不添加，或存在更新

-- 1\添加数据首先判断数据库中该用户是否存在，如果存在则不进行添加
INSERT INTO dj_employee (GD_employeeId,employeeid,employeename,password,sex,mobile,factoryId,user_id) 
select  #{id},#{employeeid},#{employeename},#{employeeid},#{sex},#{mobile},#{factoryid},#{USER_ID}
WHERE NOT EXISTS (  
    SELECT 1 FROM dj_employee WHERE employeeid = #{employeeid}   and IsDelete = 0
)

INSERT INTO dj_EmpRoleRight (empId,deptId,factoryId)  
select  #{employeeid},(select top 1  deptid from dj_pdept where remark=#{deptid} and factoryId=#{factoryid}),#{factoryid}
WHERE NOT EXISTS (  
    SELECT 1 FROM dj_EmpRoleRight WHERE empId = #{employeeid}
)
---2、如果表中数据存在则进行更新，如果不存在则进行添加
IF EXISTS (SELECT 1 FROM dj_employee WHERE employeeid = '特定employee_id')  
    UPDATE dj_employee  
    SET employeename = '新员工名'
    WHERE employeeid = '特定employee_id';  
ELSE  
    INSERT INTO dj_employee (employeeid, employeename)  
    VALUES ('特定employee_id', '新员工名');