public static ListInfo queryListInfoWithTotalsizeByRowHandler(RowHandler rowhandler,Class<?> beanType, SQLInfo sql, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { return queryListInfoWithDBName2ndTotalsizeByRowHandler( rowhandler,beanType, null,sql, offset,pagesize,totalsize,fields); }
public ListInfo queryListInfoWithDBName2ndTotalsizeByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByRowHandler(rowhandler,beanType,dbname, sql, offset,pagesize,totalsize,fields); } public ListInfo queryListInfoWithDBName2ndTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException
public static ListInfo queryListInfoWithDBName2ndTotalsizeByRowHandler(RowHandler rowhandler,Class<?> beanType,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); // } // } // // // ListInfo datas = new ListInfo(); // datas.setDatas(dbutil.executePreparedForList(beanType,rowhandler)); // datas.setTotalSize(dbutil.getLongTotalSize()); // return datas; SQLInfo sqlinfo = SQLUtil.getGlobalSQLUtil().getSQLInfo(sql,false,false); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByRowHandler( rowhandler, beanType, dbname, sqlinfo, offset, pagesize, totalsize,fields); }