关于SQL存储过程的问题 急啊！！！

[lycgxy]

高手帮忙！！！！谢谢！！！

怎样调用此存储过程：
CREATE proc queryEmployeeInfo
@aTableName NVARCHAR(255), -- 需要查询的表名
@aGetFields NVARCHAR(1000) = '*', -- 需要返回的列,逗号隔开
@anOrderField NVARCHAR(255) = '', -- 排序的字段名(只能有一个)
@aPageSize INT = 10, -- 页尺寸
@aPageIndex INT = 1, -- 页码
@anIsCount INT = 0, -- 是否仅仅返回记录总数, 0: 不返回, 非0: 返回
@anIsDESC INT = 0, -- 是否升序排列, 0: 升序, 非0: 值则降序
@aQuery NVARCHAR(1500) = '' -- 查询条件 (注意: 不要加 where)
AS
DECLARE @strSQL NVARCHAR(4000) -- SQL主语句
DECLARE @strLocate NVARCHAR(200) -- 定位查询范围
DECLARE @strOrder NVARCHAR(400) -- 排序
IF @anIsCount != 0 -- 统计总数
BEGIN
IF @aQuery != '' -- 有查询条件
SET @strSQL = 'select count(*) as Total from [' + @aTableName + '] where ' + @aQuery
ELSE -- 没有查询条件
SET @strSQL = 'select count(*) as Total from [' + @aTableName + ']'
END
ELSE -- 不进行统计总数
BEGIN
IF @anIsDESC != 0 -- 降续
BEGIN
SET @strLocate = ' < (select min'
SET @strOrder = ' order by [' + @anOrderField + '] desc'
END
ELSE -- 升序
BEGIN
SET @strLocate = ' > (select max'
--SET @strOrder = ' order by [' + @anOrderField + '] asc'
SET @strOrder =''
END

IF @aPageIndex = 1 -- 第一页
BEGIN
IF @aQuery != '' -- 有查询条件
SET @strSQL = 'select top ' + STR(@aPageSize) + ' ' + @aGetFields + ' from [' + @aTableName + ']
where ' + @aQuery + ' ' + @strOrder
ELSE -- 没有查询条件
SET @strSQL = 'select top ' + STR(@aPageSize) + ' ' + @aGetFields + ' from [' + @aTableName + '] '+ @strOrder
END
ELSE -- 不是第一页
BEGIN
IF @aQuery != '' -- 有查询条件
SET @strSQL='select * from (
select top '+ STR(@aPageSize)+' * from(
select top '+STR(@aPageSize)+' * from ['+@aTableName+']
where '+@aQuery+' order by ['+@anOrderField+'] asc
)b order by ['+@anOrderField+'] desc
) c order by ['+@anOrderField+'] asc'
ELSE
SET @strSQL='select * from (
select top '+ STR(@aPageSize)+' * from(
select top '+STR(@aPageSize)+' * from ['+@aTableName+']
order by ['+@anOrderField+'] asc
)b order by ['+@anOrderField+'] desc
) c order by ['+@anOrderField+'] asc'

END
END
EXEC (@strSQL)
return




调用的Java语句如下：
cstmt = con.prepareCall("{call queryEmployeeInfo(?,?,?,?,?,?,?,?)}");

cstmt.setString(1,"EmployeeInfo");
cstmt.setString(2,"*");
cstmt.setString(3,"employeeID");
cstmt.setInt(4,2);
cstmt.setInt(5,2);
cstmt.setInt(6,0);
cstmt.setInt(7,0);
cstmt.setString(8,"autoID=1");
cstmt.executeQuery();

但是执行到cstmt.executeQuery();就出错了

[syhan]

我看晕了，得把错误写出来啊