public static ListInfo queryListInfoWithTotalsizesqlByNullRowHandler(NullRowHandler rowhandler, SQLInfo sql, long offset,int pagesize,SQLInfo totalsizesql,Object... fields) throws SQLException { return queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler( rowhandler, null,sql, offset,pagesize,totalsizesql,fields); }
public ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,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.queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler( rowhandler,dbname, sql, offset,pagesize,totalsizesql,fields); } /**
public static ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,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); // } // } // // dbutil.executePreparedWithRowHandler(rowhandler); // ListInfo datas = new ListInfo(); // // datas.setTotalSize(dbutil.getLongTotalSize()); // return datas; SQLInfo sqlinfo = SQLUtil.getGlobalSQLUtil().getSQLInfo(sql,false,false); SQLInfo totalsizesqlinfo = SQLUtil.getGlobalSQLUtil().getSQLInfo(totalsizesql,false,false); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler( rowhandler, dbname, sqlinfo, offset, pagesize, totalsizesqlinfo, fields); } /**