private static Relationshiptype setBeanProperties(ResultSet resultset) {
        Relationshiptype relationshiptype = new Relationshiptype();
        try {
            relationshiptype.setId(resultset.getInt("id"));
            relationshiptype.setName_a_b(resultset.getString("name_a_b"));
            relationshiptype.setLabel_a_b(resultset.getString("label_a_b"));
            relationshiptype.setName_b_a(resultset.getString("name_b_a"));
            relationshiptype.setLabel_b_a(resultset.getString("label_b_a"));
            relationshiptype.setDescription(resultset.getString("description"));
            String contact_type_a = resultset.getString("contact_type_a");
            if (contact_type_a.equals("Individual")) {
                relationshiptype.setContact_type_a(Relationshiptype.Enum_contact_type.INDIVIDUAL);
            }
            if (contact_type_a.equals("Organization")) {
                relationshiptype.setContact_type_a(Relationshiptype.Enum_contact_type.ORGANIZATION);
            }
            if (contact_type_a.equals("Household")) {
                relationshiptype.setContact_type_a(Relationshiptype.Enum_contact_type.HOUSEHOLD);
            }
            String contact_type_b = resultset.getString("contact_type_b");
            if (contact_type_b.equals("Individual")) {
                relationshiptype.setContact_type_b(Relationshiptype.Enum_contact_type.INDIVIDUAL);
            }
            if (contact_type_b.equals("Organization")) {
                relationshiptype.setContact_type_b(Relationshiptype.Enum_contact_type.ORGANIZATION);
            }
            if (contact_type_b.equals("Household")) {
                relationshiptype.setContact_type_b(Relationshiptype.Enum_contact_type.HOUSEHOLD);
            }
            relationshiptype.setContact_sub_type_a(resultset.getString("contact_sub_type_a"));
            relationshiptype.setContact_sub_type_b(resultset.getString("contact_sub_type_b"));
            relationshiptype.setIs_reserved(resultset.getBoolean("is_reserved"));
            relationshiptype.setIs_active(resultset.getBoolean("is_active"));
            return relationshiptype;
        } catch (SQLException ex) {
            Logger.getLogger(RelationshiptypeController.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (Exception e) {
            Logger.getLogger(RelationshiptypeController.class.getName()).log(Level.SEVERE, null, e);
            return null;
        }
    }