CREATE OR REPLACE Procedure Pro_CheckUser(UName In Varchar2,UPass In Varchar2,YesOrNo Out Int) Is flag Number(2); Begin Select Count(UName) Into flag From User Where UName='UName' And UPass='UPass'; If (flag <> 1) Then YesOrNo := 0; Else YesOrNo := 1; End If; End Pro_CheckUser;
create or replace procedure pr_judge(username in varchar2,password in varchar2,flag int) as flagno number; begin select count(username) into flagno from 表名 where 用户名=username and 密码=password; if(flagno==0) then return flag:=1; else return flag:=0; end if; end pr_judge;
Is
flag Number(2);
Begin
Select Count(UName) Into flag From User Where UName='UName' And UPass='UPass';
If (flag <> 1) Then
YesOrNo := 0;
Else
YesOrNo := 1;
End If;
End Pro_CheckUser;
as
flagno number;
begin
select count(username) into flagno from 表名 where 用户名=username and 密码=password;
if(flagno==0) then
return flag:=1;
else
return flag:=0;
end if;
end pr_judge;