private void setHistObj(final JerHistObj jho) {
if (jho == null) {
jerInfoMsgHandler.showMsg(JerResourceBundleAccessor.get("mainModel_noHistObj"));
} else {
setModelAndIDAndNotify(jho.getModel(), jho.getId());
}
}
public void exportAllData(final String location) {
final java.text.SimpleDateFormat todaysDate = new java.text.SimpleDateFormat("yyyy-MM-dd");
final String backupFile =
location + "_" + todaysDate.format((java.util.Calendar.getInstance()).getTime());
try (CallableStatement cs =
conn.prepareCall("CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (?,?,?,?,?,?)")) {
cs.setString(1, schemaName);
cs.setString(2, "AUTHORS");
cs.setString(3, backupFile + "_TABLE_AUTHORS.csv");
cs.setString(4, ",");
cs.setString(5, null);
cs.setString(6, "UTF-8");
cs.execute();
cs.setString(2, "DOCUMENTS");
cs.setString(3, backupFile + "_TABLE_DOCUMENTS.csv");
cs.execute();
cs.setString(2, "ENTRIES");
cs.setString(3, backupFile + "_TABLE_ENTRIES.csv");
cs.execute();
cs.setString(2, "TOPOS_IN_ENTRY");
cs.setString(3, backupFile + "_TABLE_TOPOS_IN_ENTRY.csv");
cs.execute();
cs.setString(2, "TOPOI");
cs.setString(3, backupFile + "_TABLE_TOPOI.csv");
cs.execute();
cs.setString(2, "PLACES");
cs.setString(3, backupFile + "_TABLE_PLACES.csv");
cs.execute();
cs.setString(2, "PLACETOPOS");
cs.setString(3, backupFile + "_TABLE_PLACETOPOS.csv");
cs.execute();
getJerInfoMsgHandler().showMsg(JerResourceBundleAccessor.get("successful_dataexport"));
} catch (final SQLException e) {
getJerInfoMsgHandler().showMsg(e.getLocalizedMessage());
}
}