ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
@@ -116,10 +116,10 @@ /** * 校验用户名称是否唯一 * * @param userName 用户名称 * @param user 用户名称 * @return 结果 */ public SysUser checkUserNameUnique(String userName); public SysUser checkUserNameUnique(SysUser user); /** * 校验手机号码是否唯一 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
@@ -471,7 +471,7 @@ @Override public String checkUserNameUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkUserNameUnique(user.getUserName()); SysUser info = userMapper.checkUserNameUnique(user); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
@@ -322,11 +322,18 @@ where u.user_id = #{userId} </select> <select id="checkUserNameUnique" parameterType="String" resultMap="SysUserResult"> <select id="checkUserNameUnique" parameterType="com.ruoyi.common.core.domain.entity.SysUser" resultMap="SysUserResult"> select user_id, user_name from sys_user where user_name = #{userName} and del_flag = '0' limit 1 and del_flag = '0' <if test="orgid != null and orgid != ''"> and orgid = #{orgid} </if> <if test="campusid != null and campusid != ''"> and campusid = #{campusid} </if> limit 1 </select> <select id="checkPhoneUnique" parameterType="String" resultMap="SysUserResult">