public static void removeHolidayDate(Connection con, HolidayDetail holiday) throws SQLException {
StringBuilder deleteStatement = new StringBuilder(128);
deleteStatement.append("delete from ").append(AGENDA_HOLIDAYS_TABLENAME);
deleteStatement.append(" where holidayDate = ? ");
deleteStatement.append(" and userId = ? ");
PreparedStatement prepStmt = null;
try {
prepStmt = con.prepareStatement(deleteStatement.toString());
prepStmt.setString(1, DateUtil.date2SQLDate(holiday.getDate()));
prepStmt.setInt(2, Integer.parseInt(holiday.getUserId()));
prepStmt.executeUpdate();
} finally {
DBUtil.close(prepStmt);
}
}
public static void addHolidayDate(Connection con, HolidayDetail holiday)
throws SQLException, UtilException {
if (!isHolidayDate(con, holiday)) {
StringBuilder insertStatement = new StringBuilder(128);
insertStatement.append("insert into ").append(AGENDA_HOLIDAYS_TABLENAME);
insertStatement.append(" values ( ? , ? )");
PreparedStatement prepStmt = null;
try {
prepStmt = con.prepareStatement(insertStatement.toString());
prepStmt.setInt(1, Integer.parseInt(holiday.getUserId()));
prepStmt.setString(2, DateUtil.date2SQLDate(holiday.getDate()));
prepStmt.executeUpdate();
} finally {
DBUtil.close(prepStmt);
}
}
}
public static boolean isHolidayDate(Connection con, HolidayDetail holiday) throws SQLException {
StringBuilder query = new StringBuilder(128);
query.append("select * ");
query.append("from ").append(AGENDA_HOLIDAYS_TABLENAME);
query.append(" where holidayDate = ? ");
query.append(" and userId = ? ");
PreparedStatement stmt = null;
ResultSet rs = null;
try {
stmt = con.prepareStatement(query.toString());
stmt.setString(1, DateUtil.date2SQLDate(holiday.getDate()));
stmt.setInt(2, Integer.parseInt(holiday.getUserId()));
rs = stmt.executeQuery();
return rs.next();
} finally {
DBUtil.close(rs, stmt);
}
}