CREATE DEFINER=root
@localhost
PROCEDURE UserLogin
(IN username varchar(100), IN userpassWord varchar(100), OUT errcount int, OUT errMsg varchar(200), OUT userid int)
DETERMINISTIC
BEGIN
set errcount = 0;
set errMsg = ”;
set @userid = 0;
set @userpsd = ”;
set userid = 0;
select @userid:=id,@userpsd:=user_passwd from userinfo where user_name = username;
if @userid > 0 then
begin
if userpassWord = @userpsd then
begin
set errcount = 0;
set errMsg = ”;
set userid=@userid;
end;
else
begin
set errcount = 2;
set errMsg = ‘密码错误’;
end;
end if;
end;
else
begin
set errcount = 1;
set errMsg = ‘用户名不存在’;
end;
end if;
END
UserLogin 存储过程
最新推荐文章于 2022-07-18 21:07:28 发布