继续SQL2000分页----传参问题? 400 报错

继续SQL2000分页----传参问题? 400 报错

@JFinal 你好，想跟你请教个问题：

继续上一次自定义分页(SQL2000)问题,现在又遇到一问题,上次是没加入查询参数的情况下是可以的(查所有记录),现在我想加入一些查询条件(一些查询参数),如下:

String  sql= " from ( "+
      " select t1.id,t1.dh,t1.dDate,t1.vTec_Dh,t1.nMK_id,t1.vCustNo,t1.vContatPer,t1.vContaTEL "+
      " ,t1.vCurrencyNo,t1.phr,t1.phr_name,t1.lphbz,t1.phrq,t2.StyleCode as PadNo,t2.size_fw as SizeRange "+
      " ,case when t1.lPhbz=1 then '已批核'  else  '未批核' end as vPhzt "+
      " from Sal_Quotation t1 " +
      " left join  Mould_Style t2 on t1.nMK_id = t2.id "+
      " left join  customs_matKind t3  on t2.vCustoms_code=t3.kindCode "+
      " left join pay_mstr  t4 on t1.vPayTerm=t4.pay_code "+
      " left join SCR_Transport_Mstr t5  on t1.vDelyTerm=t5.transCode "+
      " left join Base_customs_type t6  on t1.vCustomsFormat=t6.vCode "+
      " where t1.dDate=? and t1.vCustNo like ? and t2.styleCode like ?) t1   ";

加了3个参数,由于在自定义分页中这个sqlExceptSelect拼接了2次,所以生成后的分页SQL语句就变成了6个?号,也就是变成了6个参数,然后我传参也传6个:

Object[] paras=new Object[6];

但现在问题来了,在Model中有一句统计总记录数的代码,生成后如下:

select count(*)  from ( select t1.id,t1.dh,t1.dDate,t1.vTec_Dh,t1.nMK_id,t1.vCustNo,t1.vContatPer,t1.vContaTEL ,t1.vCurrencyNo,t1.phr,t1.phr_name,t1.lphbz,t1.phrq,t2.StyleCode as PadNo,t2.size_fw as SizeRange ,case when t1.lPhbz=1 then '已批核' else '未批核' end as vPhzt from Sal_Quotation t1 left join Mould_Style t2 on t1.nMK_id = t2.id left join customs_matKind t3 on t2.vCustoms_code=t3.kindCode left join pay_mstr t4 on t1.vPayTerm=t4.pay_code left join SCR_Transport_Mstr t5 on t1.vDelyTerm=t5.transCode left join Base_customs_type t6 on t1.vCustomsFormat=t6.vCode where t1.dDate=? and t1.vCustNo like ? and t2.styleCode like ?) t1

此句只有3个参数,而刚传的是6个参数,所以导致出错:

com.jfinal.plugin.activerecord.ActiveRecordException: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 4 超出范围。

问题是如果只传三个参数,此处能通过,而到最后生成的总的分页SQL语句又不行了,它要6个参数才行,请问这又如何解决?thks.