public static ListInfo queryListInfoWithTotalsizeByNullRowHandler(NullRowHandler rowhandler, SQLInfo sql, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { return queryListInfoWithDBName2ndTotalsizeByNullRowHandler( rowhandler, null,sql, offset,pagesize,totalsize,fields); } public static ListInfo queryListInfoWithTotalsizesqlByNullRowHandler(NullRowHandler rowhandler, SQLInfo sql, long offset,int pagesize,SQLInfo totalsizesql,Object... fields) throws SQLException
public ListInfo queryListInfoWithDBName2ndTotalsizeByNullRowHandler(NullRowHandler rowhandler,String dbname, String sqlname, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByNullRowHandler( rowhandler,dbname, sql, offset,pagesize,totalsize,fields); } public ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException
public static ListInfo queryListInfoWithDBName2ndTotalsizeByNullRowHandler(NullRowHandler rowhandler,String dbname, String sql, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { // PreparedDBUtil dbutil = new PreparedDBUtil(); // dbutil.preparedSelect(dbname, sql,offset,pagesize,totalsize); // 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); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByNullRowHandler( rowhandler, dbname, sqlinfo, offset, pagesize, totalsize,fields); } public static ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,String dbname, String sql, long offset,int pagesize,String totalsizesql,Object... fields) throws SQLException