我怎么使用SQL标签调用带输出参数的存储过程啊!
一
<sql:update var="proc" dataSource="${con}">
exec proc_reg @UserName='${name}',@Sex='${se}',@Uemail='${eml}',@Password='${param.psw}',@Imgpath='${img}',
@IFreply='${Re}',@QQID='${QQ}',@Individualsignature='${sign}'
</sql:update>
二
<sql:query var="procs" dataSource="${con}">
exec proc_select output, output, output,
output, output, output,
output, output, output, output
</sql:query>
第一个我实现了!
第二个我怎么取 output 参数啊!
一
<sql:update var="proc" dataSource="${con}">
exec proc_reg @UserName='${name}',@Sex='${se}',@Uemail='${eml}',@Password='${param.psw}',@Imgpath='${img}',
@IFreply='${Re}',@QQID='${QQ}',@Individualsignature='${sign}'
</sql:update>
二
<sql:query var="procs" dataSource="${con}">
exec proc_select output, output, output,
output, output, output,
output, output, output, output
</sql:query>
第一个我实现了!
第二个我怎么取 output 参数啊!
output, output, output,
output, output, output, output
===================================
(&#$)@*$%@#*_%*@_)(%@@)_@#(%_
哪個是參數?我怎么看不出來?
create proc proc_select
@name varchar(20)output,
@gender varchar(10)output,
@email varchar(30)output,
@img varchar(10)output,
@points int output, --财 产
@experience int output, --经验值
@charm int output, --魅力值
@ifrep varchar(10)output, --有回帖时是否提示
@QQ varchar(10)output, --QQ号
@lsignature varchar(50)output, --个性签名
as
Select @name=UserName,@gender=Sex,@email=Uemail,@img=Imgpath,@points=Points,@experience=Experience,
@charm=Charm,@ifrep=IFreply,@QQ=QQID,@lsignature=Individualsignature from Users where UserName=@@identity
GO
--测试数据
declare @aname varchar(20),@gender varchar(10),@email varchar(30),@img varchar(10),@points int,@experience int,
@charm int,@ifrep varchar(10),@QQ varchar(10),@lsignature varchar(50)
exec proc_select @aname output,@gender output,@email output,
@img output,@points output,@experience output,
@charm output,@ifrep output,@QQ output,@lsignature output
select @aname, @gender, @email, @img, @points, @experience, @charm, @ifrep, @QQ, @lsignature
-----------------------以上位SQL代码-----------------------
-----------------------以下JSP代码------------------------
你说我用<c:set var="name" value="">
<sql:query var="procs" dataSource="${con}">
exec proc_select output, output, output,
output, output, output,
output, output, output, output
</sql:query>
怎么取?
有时候好用,但是有时候太难用了!
半成品!