</BUG>
private static final String SQL_SELECT_AFF_BY_ID = "SELECT * FROM AFFILIATION WHERE affiliationID = ?";
private static final String SQL_SELECT_AFF_BY_PERSONID_ORGID
= "SELECT * FROM AFFILIATION WHERE personID = ? AND organisationID = ?";
<BUG>private static final String UPDATE_AFFILIATION = "UPDATE AFFILIATION SET begin_date = ? ,end_date = ? WHERE affiliationID = ?";
</BUG>
public AffiliationDAO(Connection conn) {
super(conn);
}
private Affiliation getAffiliationIfAlreadyStored(Person pers, Organisation org) throws SQLException {

import java.util.logging.Logger;
import org.slf4j.LoggerFactory;
public class AffiliationDAO extends DAO<Affiliation, Long> {
private static final org.slf4j.Logger logger = LoggerFactory.getLogger(AffiliationDAO.class);
private static final String SQL_INSERT
= "INSERT INTO AFFILIATION (organisationID, personID, from_date, until_date) VALUES (?, ?, ?, ?)";
private static final String SQL_SELECT_AFF_BY_ID = "SELECT * FROM AFFILIATION WHERE affiliationID = ?";
private static final String SQL_SELECT_AFF_BY_PERSONID_ORGID
= "SELECT * FROM AFFILIATION WHERE personID = ? AND organisationID = ?";
private static final String UPDATE_AFFILIATION = "UPDATE AFFILIATION SET from_date = ? ,until_date = ? WHERE affiliationID = ?";
public AffiliationDAO(Connection conn) {
super(conn);
}
private Affiliation getAffiliationIfAlreadyStored(Person pers, Organisation org) throws SQLException {
