= "SELECT * FROM LOCATION WHERE locationID = ? ";
private static final String SQL_SELECT_LOCATION_BY_orgID_addrID
= "SELECT * FROM LOCATION WHERE organisationID = ? AND addressID = ?";
private static final String SQL_SELECT_LOCATION_BY_ORGID
= "SELECT addressID FROM LOCATION WHERE organisationID = ?";
<BUG>private static final String UPDATE_LOCATION = "UPDATE LOCATION SET begin_date = ? ,end_date = ? WHERE locationID = ?";
</BUG>
public LocationDAO(Connection conn) {
super(conn);
}

= "SELECT * FROM LOCATION WHERE locationID = ? ";
private static final String SQL_SELECT_LOCATION_BY_orgID_addrID
= "SELECT * FROM LOCATION WHERE organisationID = ? AND addressID = ?";
private static final String SQL_SELECT_LOCATION_BY_ORGID
= "SELECT addressID FROM LOCATION WHERE organisationID = ?";
private static final String UPDATE_LOCATION = "UPDATE LOCATION SET from_date = ? ,until_date = ? WHERE locationID = ?";
public LocationDAO(Connection conn) {
super(conn);
}
