我的存储过程是:
CREATE procedure proc_count_ry
@department varchar(50),
@remark1 varchar(50)
as
set nocount on
declare @dp varchar(60) ,@rmk varchar(60)
set @dp = '%'+@department + '%'
set @rmk = '%' +@remark1 + '%'
SELECT itemcode, department, SUM(monthpeople) AS monthpeople,remark1 into #temp FROM cw
where department like @dp and remark1 like @rmk
GROUP BY itemcode, department,remark1 ORDER BY itemcode,department,remark1
SELECT itemcode, department, SUM(monthpeople) AS monthpeople into #temp1 FROM cw
where department like @dp
GROUP BY itemcode, department ORDER BY itemcode,department
select a.itemcode ,a.department,a.monthpeople ,b.monthpeople as total from #temp a ,#temp1 b
where a.itemcode = b.itemcode
set nocount on
GO
我在JAVA 写了一段这样的代码 不知道对不对?
public int getproc_count_ry(String department, String remark1)
{
//调用存储过程
int ret =0;
Connection cConn = null;
CallableStatement sStmt = null;
try
{
cConn = SQLServerManagerFactory.getConnetion();
sStmt = cConn.prepareCall("{ ? = call proc_count_ry (?) }");
sStmt.registerOutParameter(1, java.sql.Types.INTEGER);
sStmt.registerOutParameter(2, java.sql.Types.INTEGER);
sStmt.execute();
SQLServerManagerFactory.close(cConn);
sStmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
return ret;
}
然后 在JSP 页面上怎么调用这个存储过程显示出结果呢??
谢谢!!
