Java tutorial
/* * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License") + you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.openmeetings.app.data.calendar.daos; import java.util.Date; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.NoResultException; import javax.persistence.PersistenceContext; import javax.persistence.TypedQuery; import org.openmeetings.app.OpenmeetingsVariables; import org.openmeetings.app.data.user.dao.UsersDaoImpl; import org.openmeetings.app.persistence.beans.calendar.AppointmentReminderTyps; import org.red5.logging.Red5LoggerFactory; import org.slf4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; @Transactional public class AppointmentReminderTypDaoImpl { private static final Logger log = Red5LoggerFactory.getLogger(AppointmentReminderTypDaoImpl.class, OpenmeetingsVariables.webAppRootKey); @PersistenceContext private EntityManager em; @Autowired private UsersDaoImpl usersDao; public AppointmentReminderTyps getAppointmentReminderTypById(Long typId) { try { log.debug("AppointmentReminderTypById: " + typId); String hql = "select app from AppointmentReminderTyps app " + "WHERE app.deleted <> :deleted " + "AND app.typId = :typId"; TypedQuery<AppointmentReminderTyps> query = em.createQuery(hql, AppointmentReminderTyps.class); query.setParameter("deleted", "true"); query.setParameter("typId", typId); AppointmentReminderTyps appointmentReminderTyps = null; try { appointmentReminderTyps = query.getSingleResult(); } catch (NoResultException ex) { } return appointmentReminderTyps; } catch (Exception ex2) { log.error("[getAppointmentReminderTypsById]: " + ex2); } return null; } public Long updateAppointmentReminderTyps(Long typId, String name) { try { AppointmentReminderTyps ac = this.getAppointmentReminderTypById(typId); ac.setName(name); ac.setUpdatetime(new Date()); if (ac.getTypId() == null) { em.persist(ac); } else { if (!em.contains(ac)) { em.merge(ac); } } return typId; } catch (Exception ex2) { log.error("[updateAppointmentReminderTyps]: ", ex2); } return null; } public Long addAppointmentReminderTyps(Long user_id, String name) { try { AppointmentReminderTyps ac = new AppointmentReminderTyps(); ac.setName(name); ac.setStarttime(new Date()); ac.setDeleted("false"); ac.setUser(usersDao.getUser(user_id)); ac = em.merge(ac); Long category_id = ac.getTypId(); return category_id; } catch (Exception ex2) { log.error("[addAppointmentReminderTyps]: ", ex2); } return null; } public Long deleteAppointmentReminderTyp(Long typId) { try { AppointmentReminderTyps ac = this.getAppointmentReminderTypById(typId); log.debug("ac: " + ac); if (ac == null) { log.debug("Already deleted / Could not find: " + typId); return typId; } ac.setUpdatetime(new Date()); ac.setDeleted("true"); if (ac.getTypId() == null) { em.persist(ac); } else { if (!em.contains(ac)) { em.merge(ac); } } return typId; } catch (Exception ex2) { log.error("[deleteAppointmentReminderTyp]: " + ex2); } return null; } public List<AppointmentReminderTyps> getAppointmentReminderTypList() { log.debug("getAppointmenetReminderTypList"); try { String hql = "select a from AppointmentReminderTyps a " + "WHERE a.deleted <> :deleted "; TypedQuery<AppointmentReminderTyps> query = em.createQuery(hql, AppointmentReminderTyps.class); query.setParameter("deleted", "true"); List<AppointmentReminderTyps> listAppointmentReminderTyp = query.getResultList(); return listAppointmentReminderTyp; } catch (Exception ex2) { log.error("[getAppointmentReminderTypList]: " + ex2); } return null; } }