public VacationSettings getVacationSettings(AccessToken token) {
VacationSettings ret = new VacationSettings();
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
con = obmHelper.getConnection();
String query =
"SELECT userobm_vacation_enable, userobm_vacation_datebegin, "
+ "userobm_vacation_dateend, userobm_vacation_message FROM UserObm "
+ "WHERE userobm_id=?";
ps = con.prepareStatement(query);
ps.setInt(1, token.getObmId());
rs = ps.executeQuery();
if (rs.next()) {
ret.setEnabled(rs.getBoolean(1));
Timestamp ts = rs.getTimestamp(2);
if (ts != null) {
ret.setStart(new Date(ts.getTime()));
}
ts = rs.getTimestamp(3);
if (ts != null) {
ret.setEnd(new Date(ts.getTime()));
}
ret.setText(rs.getString(4));
}
} catch (SQLException e) {
logger.error("Could load vacation settings for " + token.getUserLogin(), e);
} finally {
obmHelper.cleanup(con, ps, rs);
}
return ret;
}
