34,838
社区成员




CREATE PROCEDURE zd_kjjLogin
@Id Int output,
@userClass nvarchar(20) output,
@department nvarchar(20) output,
@purview nvarchar(20) output,
@userName nvarchar(20),
@passWord nvarchar(20),
@IP nvarchar(20)
AS
if exists(select id from [zd_user_admin] where UserName = @userName and [Password] = @passWord) begin
begin transaction
update [zd_user_admin] set LastLoginTime = getdate(), LastLoginIP = @IP,logins = logins+'a' where UserName = @Username
if @@error <>0 begin
--捕获错误一般是这样的。
--加这一句,在前台程序可以捕捉到。
raiserror('这里写上你的错误提示',16,1)
--******************************************
rollback transaction
return -1
end
commit transaction
select @Id=Id,@userClass=userClass,@department=department,@purview=purview from [zd_user_admin] where UserName = @userName
return 0
end
return 1
@Username
if @@error <>0 begin
rollback transaction
return -1
看看日志,没捕过!