如何在 MySQL 中使用过程验证用户登录? [英] How to validate user login using Procedure in MySQL?

问题描述

目前我正在验证用户登录，因此使用程序将用户名和密码与注册表格进行比较，然后找到记录集值 >0(成功)或 <0(失败)，但我不太擅长程序概念，我尽力了我的水平，但我无法解决这个问题，请帮助我.提前致谢

Currently i am working in validate user login, so using procedure to compare username and password to signupform table, then find a recordset value is >0 (success) or <0 (failed), but i am not very well in procedure concept, i tried my level best but i can't fix this, please help me. Thanks in Advance

这里我试过了:

Create table signupform (username varchar(10), password varchar(10)); 
Insert into signupform values ('sampath','s96000');
Insert into signupform values ('yuvaraj','y96297');
select * from signupform;

// CREATE PROCEDURE for compare username and password
create procedure testing (@username varchar(10), @password varchar(10))
AS
BEGIN
select * from signupform where username = @username and password = @password
End;

推荐答案

我建议你创建函数:

create function testing(@username varchar(10), @password varchar(10))
RETURNS bit
BEGIN
   if EXISTS(select * from signupform where username = @username and password = @password)
   then
      return 1;
   else
      return 0; 
   end if;
end;

这篇关于如何在 MySQL 中使用过程验证用户登录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！