private void writeDB(
final JerModel jerModel,
final boolean isInsert,
final boolean isUpdate,
final boolean isDelete) {
try {
try {
conn.setAutoCommit(false);
if (isInsert) {
try (PreparedStatement psJm = jerModel.getPreparer().createInsertStmt(conn)) {
psJm.executeUpdate();
}
conn.commit();
for (final PreparedStatement stmt :
jerModel
.getPreparer()
.getPrepStmtsFromMultiFields(conn, getMaxIDValueForTable(jerModel))) {
try (PreparedStatement psJm = stmt) {
psJm.executeUpdate();
}
}
} else if (isUpdate) {
for (final PreparedStatement stmt : jerModel.getPreparer().createUpdateStmts(conn)) {
try (PreparedStatement psJm = stmt) {
psJm.executeUpdate();
}
}
} else if (isDelete) {
for (final PreparedStatement stmt : jerModel.getPreparer().createDelStmts(conn)) {
try (PreparedStatement psJm = stmt) {
psJm.executeUpdate();
}
}
}
conn.commit();
setChanged();
notifyObservers(new JerObserverMsg(JerMsgType.DB_UPDATE));
} catch (SQLException | NumberFormatException nfe) {
conn.rollback();
conn.setAutoCommit(true);
throw nfe;
} finally {
conn.setAutoCommit(true);
}
} catch (final SQLException e1) {
LOGGER.severe(e1.getMessage());
setModelAndID(jerModel, -1);
jerInfoMsgHandler.showMsg("@" + jerModel.getIdName() + ": " + e1.getLocalizedMessage());
}
}
public void checkSelectedPlaces() throws ParseException {
checkAssociatedPlaces(selectedModel, selectedModel.getIdName(), selectedID);
}
