@Override public void execute(Database database) throws CustomChangeException { logger.info("begin process excel :" + filePath); ExcelSeedDataReader dataReader = new ExcelSeedDataReader(filePath); tables = dataReader.load(); dbAdaptor = new DbAdaptor(this); dbAdaptor.setUrl(System.getProperty("db.url")); dbAdaptor.setUserName(System.getProperty("db.user")); dbAdaptor.setPassword(System.getProperty("db.password")); dbAdaptor.setOverride(Boolean.valueOf(System.getProperty("db.override", "true"))); String name = System.getProperty("db.skipUpdateTables"); if (StringUtils.isNotEmpty(name)) { String[] names = name.toUpperCase().split(","); Collections.addAll(updateSkipTableNames, names); } try { processData(); dbAdaptor.closeConnection(true); } catch (Exception e) { dbAdaptor.closeConnection(false); throw new CustomChangeException(e); } }
@Override public void execute(Database database) throws CustomChangeException { logger.info("begin process excel :" + filePath); ExcelSeedDataReader dataReader = new ExcelSeedDataReader(filePath); tables = dataReader.load(); dbAdaptor = new DbAdaptor(this); dbAdaptor.setUrl(System.getProperty("db.url")); dbAdaptor.setUserName(System.getProperty("db.user")); dbAdaptor.setPassword(System.getProperty("db.password")); dbAdaptor.setDbDriver(System.getProperty("db.driver")); dbAdaptor.setOverride(Boolean.valueOf(System.getProperty("db.override", "true"))); String name = System.getProperty("db.skipUpdateTables"); if (StringUtils.isNotEmpty(name)) { String[] names = name.toUpperCase().split(","); Collections.addAll(updateSkipTableNames, names); } try { processData(); dbAdaptor.closeConnection(true); } catch (Exception e) { dbAdaptor.closeConnection(false); throw new CustomChangeException(e); } }