ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/job.xml"); Map conditions = new HashMap(); conditions.put("jobname", jobname);
try ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/cms/documentmanager/document.xml"); SQLParams params = new SQLParams(); final SimpleDateFormat dateformat = DataFormatUtil.getSimpleDateFormat(request,"yyyy-MM-dd");
protected void initInstanceUpgrade() { if(instanceUpgrade == null) { instanceUpgrade = new InstanceUpgrade(); extendExecutor = new ConfigSQLExecutor("org/activiti/engine/impl/db/upgrade/upgradesql.xml"); instanceUpgrade.setExecutor(extendExecutor); } instanceUpgrade.setTaskService(this.taskService); instanceUpgrade.setRuntimeService(this.runtimeService); instanceUpgrade.init(); }
private ConfigSQLExecutor executor_ = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/resManagerImpl.xml");
private void initSQLInfo(){ if(esjdbc.getSql() == null || esjdbc.getSql().equals("")){ try { ConfigSQLExecutor executor = new ConfigSQLExecutor(esjdbc.getSqlFilepath()); SQLInfo sqlInfo = executor.getSqlInfo(esjdbc.getSqlName()); esjdbc.setSql(sqlInfo.getSql()); esjdbc.setExecutor(executor); } catch (SQLException e){ throw new ESDataImportException(e); } } } public void setEsjdbc(ESJDBC esjdbc){
private void initSQLInfo(){ if(esjdbc.getSql() == null || esjdbc.getSql().equals("")){ try { ConfigSQLExecutor executor = new ConfigSQLExecutor(esjdbc.getSqlFilepath()); SQLInfo sqlInfo = executor.getSqlInfo(esjdbc.getSqlName()); esjdbc.setSql(sqlInfo.getSql()); esjdbc.setExecutor(executor); } catch (SQLException e){ throw new ESDataImportException(e); } } } public void setEsjdbc(ESJDBC esjdbc){
public void exportData2DB(){ Map params = getParams() != null ?getParams():new HashMap(); params.put("size", getBatchSize());//每页5000条记录 if(this.sliceQuery){ params.put("sliceMax",this.sliceSize); } final int insertBatchSize = this.insertBatchSize == null ?this.getBatchSize():this.insertBatchSize; //采用自定义handler函数处理每个scroll的结果集后,response中只会包含总记录数,不会包含记录集合 //scroll上下文有效期1分钟;大数据量时可以采用handler函数来处理每次scroll检索的结果,规避数据量大时存在的oom内存溢出风险 configSQLExecutor = getSql() == null ?new ConfigSQLExecutor(getDsl2ndSqlFile()):null; exportCount = new ExportCount(); ClientInterface clientUtil = ElasticSearchHelper.getConfigRestClientUtil(this.getDsl2ndSqlFile()); ESExporterScrollHandler esExporterScrollHandler = new ESExporterScrollHandler(this); ESDatas<Map> response = null; if(!this.sliceQuery) { response = clientUtil.scroll(getQueryUrl(), getDslName(), getScrollLiveTime(), params, Map.class, esExporterScrollHandler); } else{ response = clientUtil.scrollSliceParallel(getQueryUrl(), getDslName(), params, getScrollLiveTime(),Map.class, esExporterScrollHandler); } if(logger.isInfoEnabled()) logger.info("Export compoleted and export total {} records.",response.getTotalSize()); }
public void exportData2DB(){ Map params = getParams() != null ?getParams():new HashMap(); params.put("size", getBatchSize());//每页5000条记录 if(this.sliceQuery){ params.put("sliceMax",this.sliceSize); } final int insertBatchSize = this.insertBatchSize == null ?this.getBatchSize():this.insertBatchSize; //采用自定义handler函数处理每个scroll的结果集后,response中只会包含总记录数,不会包含记录集合 //scroll上下文有效期1分钟;大数据量时可以采用handler函数来处理每次scroll检索的结果,规避数据量大时存在的oom内存溢出风险 configSQLExecutor = getSql() == null ?new ConfigSQLExecutor(getDsl2ndSqlFile()):null; exportCount = new ExportCount(); ClientInterface clientUtil = ElasticSearchHelper.getConfigRestClientUtil(this.getDsl2ndSqlFile()); ESExporterScrollHandler esExporterScrollHandler = new ESExporterScrollHandler(this); ESDatas<Map> response = null; if(!this.sliceQuery) { response = clientUtil.scroll(getQueryUrl(), getDslName(), getScrollLiveTime(), params, Map.class, esExporterScrollHandler); } else{ response = clientUtil.scrollSliceParallel(getQueryUrl(), getDslName(), params, getScrollLiveTime(),Map.class, esExporterScrollHandler); } if(logger.isInfoEnabled()) logger.info("Export compoleted and export total {} records.",response.getTotalSize()); }
private static ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/user.xml");
OrgAdministrator { private static ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/user.xml"); public static SQLUtil sqlUtilInsert = SQLUtil.getInstance("org/frameworkset/insert.xml");
conn.setString(24,site.getDistributeManners()); conn.executePrepared(); ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/cms/documentmanager/docclass.xml"); DocClass docClass = new DocClass(); docClass.setSite_id((int)siteId);
ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/cms/documentmanager/document.xml"); SQLParams params = new SQLParams(); params.addSQLParam("queryFlag", queryFlag, SQLParams.STRING);
private static ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/user.xml"); private static BussinessCheck bussinessCheck; private SQLUtil sqlUtilInsert = SQLUtil