public class DetailRowMapper implements RowMapper<Detail> {
    public Detail mapRow(ResultSet rs, int rowNumber) throws SQLException{
        return new Detail(rs.getInt("detailID"), rs.getInt("personID"), rs.getInt("houseID"));
    }
}


import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@AllArgsConstructor
@NoArgsConstructor
@Data
public class Detail {

    private int detailID;
  	private int personID;
  	private int houseID;
   

}


public interface DetailDao{
  
  	int addDetail(int houseID, int personID);
  
  	List<Occupants> findHouseOccupantsByID(int houseID);
  	
  	int deleteDetailByID(int personID);
  	
  	int MoveOccupantByID(int destinationID, int personID);