login_proc1.sql

来自「主要介绍了sql的基础教程」· SQL 代码 · 共 60 行

if exists (select * from  sysdatabases where name = 'db_user' )
drop database db_user
create database db_user
go 
use db_user
if exists (select * from  sysobjects where name = 'tab_user' and type = 'U' )
drop table tab_user
go 
create table tab_user

(
	u_name varchar(20),
	u_pwd varchar(20)

)
go
insert into tab_user values('123','123')
go

if exists (select * from  sysobjects where name = 'proc_login' and type = 'P' )
drop proc proc_login
go
create proc proc_login

	@u_name varchar(200),
	@u_pwd varchar(200),
	@intI int output,
	@str_msg varchar(200)='' output

as
	begin
		declare
			@sum int
			if @u_name =NULL or @u_pwd = null
				begin
					set @intI = 0
					set @str_msg = '请输入用户名或者密码'
				end
			else
				begin
					select @sum = count(*) from tab_user
					where u_name = @u_name and u_pwd = @u_pwd
					if @sum > 0 
						begin
							set @intI = 1 
							set @str_msg= '登陆成功'
						end		
					else
						begin
							set @intI = 0
							set @str_msg= '用户名或密码错误，请重新输入！'
						end		
			end
	end



go