UserLogin 存储过程

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