public static ListInfo queryListInfoWithTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType, SQLInfo sql, long offset,int pagesize,SQLInfo totalsizesql,Object... fields) throws SQLException { return queryListInfoWithDBName2ndTotalsizesqlByRowHandler( rowhandler,beanType, null,sql, offset,pagesize,totalsizesql,fields); }
public ListInfo queryListInfoWithDBName2ndTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); SQLInfo totalsizesql = this.getSqlInfo(dbname, totalsizesqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizesqlByRowHandler(rowhandler,beanType,dbname, sql, offset,pagesize,totalsizesql,fields); } /**
public static ListInfo queryListInfoWithDBName2ndTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sql, long offset,int pagesize,String totalsizesql,Object... fields) throws SQLException { // PreparedDBUtil dbutil = new PreparedDBUtil(); // dbutil.preparedSelectWithTotalsizesql(dbname, sql,offset,pagesize,totalsizesql); // if(fields != null && fields.length > 0) // { // for(int i = 0; i < fields.length ; i ++) // { // // Object field = fields[i]; // dbutil.setObject(i + 1, field); // } // } // // // ListInfo datas = new ListInfo(); // datas.setDatas(dbutil.executePreparedForList(beanType,rowhandler)); // datas.setTotalSize(dbutil.getLongTotalSize()); // return datas; SQLInfo sqlinfo = SQLUtil.getGlobalSQLUtil().getSQLInfo(sql,false,false); SQLInfo totalsizesqlinfo = SQLUtil.getGlobalSQLUtil().getSQLInfo(totalsizesql,false,false); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizesqlByRowHandler( rowhandler, beanType, dbname, sqlinfo, offset, pagesize, totalsizesqlinfo, fields); } /**