在具有相同用户名和姓的registerin用户名上遇到问题！

本文介绍了在具有相同用户名和姓的registerin用户名上遇到问题！的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我正在创建一个项目，管理员在其上添加数据库上的新用户。 我正在参与制作用户名，如firstname.lastname，如果数据库有另一个用户具有相同的名称和姓氏，它增加了一个像firstname1.lastname的用户名。 我可以注册，并没有让我有任何问题。 关键是如何编辑用户如果我们有三个用户使用相同的数据，例如： firstname.lastname firstname1.lastname firstname2.lastname 如果想要更新第二个用户名（firstname1.lastname）的数据，我必须检查数据库以及用户是否已经存在。 存储过程如下所示，我不知道如何解决它 I am making a project on which the admin adds the new users on database.I'm attending to make the username like firstname.lastname and if the database has another user with the same first name and last name it increments the username for one like firstname1.lastname.I can register that and is not making me any problems.The point is how to edit that user if for example we got three users with the same data like:firstname.lastnamefirstname1.lastnamefirstname2.lastnameIf a want to update the data of second username (firstname1.lastname) I have to check the database and if the user already exists.The Stored procedure is like following and I don't know how to fix itALTER PROCEDURE [dbo].[procUpdateUser] @ID_Personi int ,@Emri nvarchar(20),@Mbiemri nvarchar(20),@Gjinia nvarchar(10),@DataLindjes date,@VendiLindjes nvarchar(30),@ID_Komuna int,@EmriPerdoruesit nvarchar (20),@Fjalekalimi nvarchar (20),@DataRegjistrimit date ASBEGINDeclare @numri int = 0SET @numri =(SELECT COUNT (*) from PERSONI where Emri = @Emri AND Mbiemri = @Mbiemri)DECLARE @ID_Roli intSET @ID_Roli = (SELECT (ID_Roli) FROM dbo.ROLI where ID_Roli=4) DECLARE @ID_Identifikimi intSET @ID_Identifikimi = (SELECT ID_Identifikimi FROM PERSONI where Emri = @Emri AND Mbiemri = @Mbiemri AND DataLindjes = @DataLindjes AND Gjinia = @Gjinia AND VendiLindjes = @VendiLindjes AND ID_Roli = @ID_Roli AND ID_Personi=@ID_Personi ) if @numri = 0BEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET[EmriPerdoruesit] = LOWER(@Emri + '.' + @Mbiemri),[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_Identifikimi BEGINUPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET[Emri] = @Emri,[Mbiemri] = @Mbiemri,[Gjinia] = @Gjinia,[DataLindjes] = @DataLindjes,[VendiLindjes] = @VendiLindjes,[ID_Roli] = @ID_Roli,[ID_Identifikimi] = @ID_Identifikimi,[ID_Komuna] = @ID_Komunawhere PERSONI.ID_Personi = @ID_Personi ENDENDELSEBEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET [EmriPerdoruesit] = LOWER(CONCAT( @Emri , @numri) + '.' + @Mbiemri),[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_IdentifikimiBEGIN UPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET [Emri] = @Emri ,[Mbiemri] = @Mbiemri ,[Gjinia] = @Gjinia ,[DataLindjes] = @DataLindjes ,[VendiLindjes] = @VendiLindjes ,[ID_Roli] = @ID_Roli ,[ID_Identifikimi] = @ID_Identifikimi ,[ID_Komuna] = @ID_Komuna where PERSONI.ID_Personi = @ID_PersoniENDENDEND 提前感谢您的回复。Thank you in advance for your reply.推荐答案 NewIndex = Count + 1 = 4 = trouble 所以你需要有一个算法来处理这种情况。 更新 当您更新时，您无法从John Doe1，John Doe2和John中选择合适的人选Doe3自动。 你需要做什么，正如Garth所说，在多个名字的情况下，首先向管理员提供一个名单列表和尽可能多的相关信息，包括表的主键。 然后管理员可以选择要更新的人，并使用主键调用存储过程，您将始终确保更新了正确的人。 （提供管理员选择正确的，当然） [更新] 好​​的，所以你的问题是当你更新一个人和名字和姓氏已经改变了，突然间你又是另一个同名的人。 你现在要做的就是深入了解呼吸并经历不同的场景。这里的一个关键，双关语是你确实将主键作为参数提供给存储过程。 现在你必须考虑不同的情况： 1.名字和姓氏都没有更新。 没问题，正常更新。 2.更新名字或姓氏或两者都有。 检查数据库中是否存在新的名称组合。 如果不是：没问题 如果是这样：为此人分配一个新的索引号。使用与插入SP相同的算法。 我希望这可以帮助你前进。 我刚从酒吧来到这里去睡觉，也许，也许，只是也许，我现在不是最聪明的。So you need to have an algorithm that takes care of this case too.UpdateWhen you update there is no way you can select the right person from the set John Doe1, John Doe2 and John Doe3 automatically.What you need to do, as Garth said, in the case of multiple names, is first to present the admin with a list of the names and as much relevant information as possible, including the primary key of the table.Then the admin can select the person to update and the stored procedure is called with the primary key and you will always be sure that the correct person is updated.(Provided the admin picks the right one, of course)[UPDATE]OK, so your problem is when you are updating a person and the first name and the last name has changed and all of a sudden you a yet another person with the same name.What you need to do now is to take a deep breath and go through the different scenarios. One key here, pun intended, is that you do provide the primary key as a parameter into the stored procedure.Now you have to consider the different cases:1. Neither the first name nor the last name has been updated.No problem, update as normal.2. Either the first name or the last name has been updated or both.Check if the new combination of names exist in the database.If not: No problemIf so: Assign a new index number for this person. Use the same algorithm as for the insert SP.I hope this will help you forward.I just came from the pub and about to go to sleep, so maybe, just maybe, I am not at my brightest right now. ALTER PROCEDURE [dbo].[procUpdateUser] @ID_Personi int ,@Emri nvarchar(20),@Mbiemri nvarchar(20),@Gjinia nvarchar(10),@DataLindjes date,@VendiLindjes nvarchar(30),@ID_Komuna int,@EmriPerdoruesit nvarchar (20),@Fjalekalimi nvarchar (20),@DataRegjistrimit date ASBEGINDECLARE @ID_Roli intSET @ID_Roli = (SELECT (ID_Roli) FROM dbo.ROLI where ID_Roli=4) DECLARE @ID_Identifikimi intSET @ID_Identifikimi = (SELECT ID_Identifikimi FROM PERSONI where PERSONI.ID_Personi = @ID_Personi)Declare @numri int = 0SET @numri =(SELECT COUNT (*) from PERSONI where Emri = @Emri AND Mbiemri = @Mbiemri)if (@numri = 0 AND LOWER(@Emri + '.' + @Mbiemri) != @EmriPerdoruesit )BEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET [EmriPerdoruesit] = LOWER(@Emri + '.' + @Mbiemri),[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_Identifikimi BEGINUPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET[Emri] = @Emri,[Mbiemri] = @Mbiemri,[Gjinia] = @Gjinia,[DataLindjes] = @DataLindjes,[VendiLindjes] = @VendiLindjes,[ID_Roli] = @ID_Roli,[ID_Identifikimi] = @ID_Identifikimi,[ID_Komuna] = @ID_Komunawhere PERSONI.ID_Personi = @ID_Personi ENDENDelse if (@numri = 0 AND LOWER(@Emri + '.' + @Mbiemri) = @EmriPerdoruesit )BEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET [EmriPerdoruesit] = @EmriPerdoruesit,[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_Identifikimi BEGINUPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET[Emri] = @Emri,[Mbiemri] = @Mbiemri,[Gjinia] = @Gjinia,[DataLindjes] = @DataLindjes,[VendiLindjes] = @VendiLindjes,[ID_Roli] = @ID_Roli,[ID_Identifikimi] = @ID_Identifikimi,[ID_Komuna] = @ID_Komunawhere PERSONI.ID_Personi = @ID_Personi ENDENDelse if (@numri >0 AND LOWER(@Emri + '.' + @Mbiemri) != @EmriPerdoruesit )BEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET [EmriPerdoruesit] = LOWER(CONCAT(@Emri, @numri) + '.' + @Mbiemri),[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_Identifikimi BEGINUPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET[Emri] = @Emri,[Mbiemri] = @Mbiemri,[Gjinia] = @Gjinia,[DataLindjes] = @DataLindjes,[VendiLindjes] = @VendiLindjes,[ID_Roli] = @ID_Roli,[ID_Identifikimi] = @ID_Identifikimi,[ID_Komuna] = @ID_Komunawhere PERSONI.ID_Personi = @ID_Personi ENDENDELSE if (@numri > 0 AND LOWER(@Emri + '.' + @Mbiemri) = @EmriPerdoruesit )BEGINUPDATE [TEMA_ScoMan].[dbo].[IDENTIFIKIMI] SET [EmriPerdoruesit] = @EmriPerdoruesit,[Fjalekalimi] = LOWER(@Emri + '.' + @Mbiemri),[ID_Roli] = @ID_Roli,[DataRegjistrimit] = @DataRegjistrimitwhere ID_Identifikimi = @ID_IdentifikimiBEGIN UPDATE [TEMA_ScoMan].[dbo].[PERSONI] SET [Emri] = @Emri ,[Mbiemri] = @Mbiemri ,[Gjinia] = @Gjinia ,[DataLindjes] = @DataLindjes ,[VendiLindjes] = @VendiLindjes ,[ID_Roli] = @ID_Roli ,[ID_Identifikimi] = @ID_Identifikimi ,[ID_Komuna] = @ID_Komuna where PERSONI.ID_Personi = @ID_PersoniENDENDEND 已更新。Updated. 这篇关于在具有相同用户名和姓的registerin用户名上遇到问题！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！