Java tutorial
/** * ============================================================================= * * ORCID (R) Open Source * http://orcid.org * * Copyright (c) 2012-2014 ORCID, Inc. * Licensed under an MIT-Style License (MIT) * http://orcid.org/open-source-license * * This copyright and license information (including a link to the full license) * shall be included in its entirety in all copies or substantial portion of * the software. * * ============================================================================= */ package org.orcid.persistence.dao.impl; import java.util.List; import javax.persistence.Query; import org.apache.commons.lang.StringUtils; import org.orcid.jaxb.model.message.Visibility; import org.orcid.persistence.dao.OtherNameDao; import org.orcid.persistence.jpa.entities.OtherNameEntity; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.Assert; public class OtherNameDaoImpl extends GenericDaoImpl<OtherNameEntity, Long> implements OtherNameDao { public OtherNameDaoImpl() { super(OtherNameEntity.class); } /** * Get other names for an specific orcid account * @param orcid * @return * The list of other names related with the specified orcid profile * */ @Override @SuppressWarnings("unchecked") public List<OtherNameEntity> getOtherName(String orcid) { Query query = entityManager.createQuery("FROM OtherNameEntity WHERE profile.id=:orcid"); query.setParameter("orcid", orcid); return query.getResultList(); } /** * Update other name entity with new values * @param otherName * @return * true if the other name was sucessfully updated, false otherwise * */ @Override @Transactional public boolean updateOtherName(OtherNameEntity otherName) { throw new UnsupportedOperationException("This opperation is not supported yet"); } /** * Create other name for the specified account * @param orcid * @param displayName * @return * true if the other name was successfully created, false otherwise * */ @Override @Transactional public boolean addOtherName(String orcid, String displayName) { Query query = entityManager.createNativeQuery( "INSERT INTO other_name (other_name_id, date_created, last_modified, display_name, orcid) VALUES (nextval('other_name_seq'), now(), now(), :displayName, :orcid)"); query.setParameter("orcid", orcid); query.setParameter("displayName", displayName); return query.executeUpdate() > 0 ? true : false; } /** * Delete other name from database * @param otherName * @return * true if the other name was successfully deleted, false otherwise * */ @Override @Transactional public boolean deleteOtherName(OtherNameEntity otherName) { Assert.notNull(otherName); Query query = entityManager.createQuery("DELETE FROM OtherNameEntity WHERE id=:id"); query.setParameter("id", otherName.getId()); return query.executeUpdate() > 0 ? true : false; } @Override @Transactional public boolean updateOtherNamesVisibility(String orcid, Visibility visibility) { Query query = entityManager.createNativeQuery( "update profile set last_modified=now(), other_names_visibility=:other_names_visibility, indexing_status='PENDING' where orcid=:orcid"); query.setParameter("other_names_visibility", StringUtils.upperCase(visibility.value())); query.setParameter("orcid", orcid); boolean result = query.executeUpdate() > 0 ? true : false; return result; } }