ASP代码
Set Comm=Server.CreateObject("ADODB.Command")
Comm.ActiveConnection="provider=sqloledb;database=mytest;uid=sa;pwd=sa;server=192.168.0.137"
Comm.CommandText="usercheck"
Comm.CommandType=4
Set p1=Comm.CreateParameter("fullname",200,1,50,"a")
Comm.Parameters.Append p1
Set p1=Comm.CreateParameter("password",200,1,20,"b")
Comm.Parameters.Append p1
Set p1=Comm.CreateParameter("check",129,2,3)
Comm.Parameters.Append p1
Comm.Execute
if comm("check")="yes" then
response.write "欢迎进入系统! 用户名:" & comm("fullname") & " 密码:" & comm("password")
else
response.write "对不起,您尚未注册!"
end if
Set Comm=nothing 存储过程代码如下:
建立数据表userinfo
id int(4) not null,
fullname varchar(50) not null,
password varchar(20) not null,
nikename varchar(50) not null 第二步,建立存储过程usercheck
CREATE procedure usercheck
@infullname varchar(50),
@inpassword varchar(50),
@outcheck char(3) OUTPUT
as
if exists(select * from userinfo where fullname=@infullname and password=@inpassword)
select @outcheck='yes'
else
select @outcheck='no' 各位高手,帮我看看啊,郁闷死了。
Set Comm=Server.CreateObject("ADODB.Command")
Comm.ActiveConnection="provider=sqloledb;database=mytest;uid=sa;pwd=sa;server=192.168.0.137"
Comm.CommandText="usercheck"
Comm.CommandType=4
Set p1=Comm.CreateParameter("fullname",200,1,50,"a")
Comm.Parameters.Append p1
Set p1=Comm.CreateParameter("password",200,1,20,"b")
Comm.Parameters.Append p1
Set p1=Comm.CreateParameter("check",129,2,3)
Comm.Parameters.Append p1
Comm.Execute
if comm("check")="yes" then
response.write "欢迎进入系统! 用户名:" & comm("fullname") & " 密码:" & comm("password")
else
response.write "对不起,您尚未注册!"
end if
Set Comm=nothing 存储过程代码如下:
建立数据表userinfo
id int(4) not null,
fullname varchar(50) not null,
password varchar(20) not null,
nikename varchar(50) not null 第二步,建立存储过程usercheck
CREATE procedure usercheck
@infullname varchar(50),
@inpassword varchar(50),
@outcheck char(3) OUTPUT
as
if exists(select * from userinfo where fullname=@infullname and password=@inpassword)
select @outcheck='yes'
else
select @outcheck='no' 各位高手,帮我看看啊,郁闷死了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货