private void setHistObj(final JerHistObj jho) {
if (jho == null) {
jerInfoMsgHandler.showMsg(JerResourceBundleAccessor.get("mainModel_noHistObj"));
} else {
setModelAndIDAndNotify(jho.getModel(), jho.getId());
}
}
public void setModelAndIDAndNotify(final JerModel jm, final int selID) {
selectedModel = jm;
selectedID = selID;
setChanged();
notifyObservers(new JerObserverMsg(JerMsgType.SELECTION));
jerInfoMsgHandler.setMsgBoxToNormal();
}
private List<Object> readDB(final String sql) {
final List<Object> columnList = new ArrayList<>();
try {
conn.setAutoCommit(false);
try (PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
final int columnCount = rs.getMetaData().getColumnCount();
final List<Object> rowList = new ArrayList<>(columnCount);
for (int i = 1; i <= columnCount; i++) {
rowList.add(rs.getObject(i));
}
columnList.add(rowList);
}
conn.commit();
} catch (final SQLException e) {
conn.rollback();
throw e;
} finally {
conn.setAutoCommit(true);
}
} catch (final SQLException e1) {
jerInfoMsgHandler.showMsg(e1.getLocalizedMessage());
}
return columnList;
}
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());
}
}