public void populateProdFreqValues() {
try {
Connection con = Main.dbConnection;
if (!con.isValid(0)) {
con = Main.reconnect();
}
freqValues.clear();
PreparedStatement stmt =
con.prepareStatement(
"select value, code, seq, lov_lookup_id from lov_lookup where code='PRODUCT_FREQ' order by seq");
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
freqValues.add(rs.getString(1));
}
prodFreq.getItems().addAll(freqValues);
} catch (SQLException e) {
Main._logger.debug("Error :", e);
e.printStackTrace();
} catch (Exception e) {
Main._logger.debug("Error :", e);
e.printStackTrace();
}
}
