public <T> void executeBatch(String sqlname,List<T> datas,int batchsize, BatchHandler<T> batchHandler) throws SQLException{ executeBatch(null,sqlname, datas, batchsize, batchHandler); }
public void handle(ESDatas<T> response) throws Exception {//自己处理每次scroll的结果 long totalSize = response.getTotalSize(); List<T> datas = response.getDatas(); int batchNo = es2DB.getExportCount().increamentCount(); if(totalSize == 0 || datas == null || datas.size() == 0){ if(logger.isInfoEnabled()){ logger.info("Igonre Execute export task {}:zero or null datas.",batchNo); } return; } if(logger.isInfoEnabled()){ logger.info("Execute task {} start.",batchNo); } if(es2DB.getSql() == null) { es2DB.getConfigSQLExecutor().executeBatch(es2DB.getDbConfig().getDbName(),es2DB.getSqlName(), datas, es2DB.getBatchSize(), es2DB.getBatchHandler()); } else{ SQLExecutor.executeBatch(es2DB.getDbConfig().getDbName(),es2DB.getSql(), datas, es2DB.getBatchSize(), es2DB.getBatchHandler()); } if(logger.isInfoEnabled()){ logger.info("Execute task {} complete and export data {} record.",batchNo,datas.size()); } } }
public void handle(ESDatas<T> response) throws Exception {//自己处理每次scroll的结果 long totalSize = response.getTotalSize(); List<T> datas = response.getDatas(); int batchNo = es2DB.getExportCount().increamentCount(); if(totalSize == 0 || datas == null || datas.size() == 0){ if(logger.isInfoEnabled()){ logger.info("Igonre Execute export task {}:zero or null datas.",batchNo); } return; } if(logger.isInfoEnabled()){ logger.info("Execute task {} start.",batchNo); } if(es2DB.getSql() == null) { es2DB.getConfigSQLExecutor().executeBatch(es2DB.getDbConfig().getDbName(),es2DB.getSqlName(), datas, es2DB.getBatchSize(), es2DB.getBatchHandler()); } else{ SQLExecutor.executeBatch(es2DB.getDbConfig().getDbName(),es2DB.getSql(), datas, es2DB.getBatchSize(), es2DB.getBatchHandler()); } if(logger.isInfoEnabled()){ logger.info("Execute task {} complete and export data {} record.",batchNo,datas.size()); } } }