如何分批执行insql 查询语句，解决输入参数多的问题。

zhou66

InSqlBatchCaller caller = new InSqlBatchCaller(cuserids);
      caller.execute(new IInSqlBatchCallBack()
      {
        public Object doWithInSql(String inSql) throws BusinessException, SQLException
        {
          String sql = "cuserid in " + inSql;
          Collection col = qry.retrieveByClause(UserVO.class, sql, UserMatcher.SUPPORTED_FIELDS);
          withinList.addAll(col);
          return null;
        } } );



示例：
public List<UserVO> matchWithin(String[] cuserids, String matchString) throws BusinessException {
    final IUAPQueryBS qry = (IUAPQueryBS)NCLocator.getInstance().lookup(IUAPQueryBS.class);
    final List withinList = new ArrayList();
    try
    {
      InSqlBatchCaller caller = new InSqlBatchCaller(cuserids);
      caller.execute(new IInSqlBatchCallBack()
      {
        public Object doWithInSql(String inSql) throws BusinessException, SQLException
        {
          String sql = "cuserid in " + inSql;
          Collection col = qry.retrieveByClause(UserVO.class, sql, UserMatcher.SUPPORTED_FIELDS);
          withinList.addAll(col);
          return null;
        } } );
    }
    catch (Exception e) {
      throw new BusinessException(e);
    }

    List resultList = new ArrayList();

    for (UserVO uvo : withinList) {
      for (String field : SUPPORTED_FIELDS) {
        if (matches(uvo, field, matchString)) {
          resultList.add(uvo);

          break;
        }
      }
    }

    return resultList;
  }

zhou66

批量查询物料的最近采购价：

select * From (
select po.vbillcode,po.dbilldate, pob.nqtorigtaxprice,pob.pk_material,
        row_number() over(partition by pob.pk_material order by po.dbilldate desc) rn
from po_order_b pob
inner join po_order po on pob.pk_order =po.pk_order
where po.dr=0 and pob.dr=0
) where rn=1

zhou66

nc.vo.trade.sqlutil.InSqlBatchCaller  类全名