Java tutorial
/******************************************************************************* * ***** BEGIN LICENSE BLOCK Version: MPL 1.1 * * The contents of this file are subject to the Mozilla Public License Version * 1.1 (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.mozilla.org/MPL/ * * Software distributed under the License is distributed on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for * the specific language governing rights and limitations under the License. * * The Original Code is the OpenCustomer CRM. * * The Initial Developer of the Original Code is Thomas Bader (Bader & Jene * Software-Ingenieurbro). Portions created by the Initial Developer are * Copyright (C) 2005 the Initial Developer. All Rights Reserved. * * Contributor(s): Thomas Bader <thomas.bader@bader-jene.de> * * ***** END LICENSE BLOCK ***** */ package org.opencustomer.db.dao.system; import java.util.ArrayList; import java.util.List; import org.apache.log4j.Logger; import org.hibernate.HibernateException; import org.hibernate.Query; import org.opencustomer.db.dao.calendar.CalendarDAO; import org.opencustomer.db.vo.system.RoleVO; import org.opencustomer.db.vo.system.UserVO; import org.opencustomer.db.vo.system.UsergroupVO; import org.opencustomer.framework.db.HibernateContext; import org.opencustomer.framework.db.dao.UndeletableDAO; import org.opencustomer.framework.db.util.Page; import org.opencustomer.framework.db.util.Sort; import org.opencustomer.framework.db.vo.EntityAccess; public final class UserDAO extends UndeletableDAO<UserVO> { private static final Logger log = Logger.getLogger(UserDAO.class); public final static int SORT_USERNAME = 1; /** * @throws DatabaseException */ public UserDAO() throws HibernateException { super(); } protected Class getEntityClass() { return UserVO.class; } public void delete(UserVO entity, Integer userId) throws HibernateException { new CalendarDAO().delete(entity.getCalendar(), userId); super.delete(entity, userId); } protected final String getSortString(Sort sort) { String orderField = ""; switch (sort.getField()) { case SORT_USERNAME: default: orderField = "e.userName"; break; } if (!sort.isAscending()) return orderField + " DESC"; else return orderField + " ASC"; } public UserVO getByUserName(String userName) { UserVO user = null; try { StringBuilder hql = new StringBuilder(); hql.append(" FROM ").append(getEntityClass().getName()).append(" e "); hql.append(" WHERE e.userName = :userName "); user = (UserVO) HibernateContext.getSession().createQuery(hql.toString()) .setString("userName", userName).uniqueResult(); if (log.isDebugEnabled()) log.debug("found user: " + user); } catch (HibernateException e) { log.error("Could not find user by " + userName, e); throw e; } return user; } public List<UserVO> getForRole(RoleVO role) { List<UserVO> list = new ArrayList<UserVO>(); try { StringBuilder hql = new StringBuilder(); hql.append(" FROM ").append(getEntityClass().getName()).append(" e "); hql.append(" WHERE e.profile.role = :role "); Query query = HibernateContext.getSession().createQuery(hql.toString()); query.setEntity("role", role); list = toTypeSafeList(query.list()); if (log.isDebugEnabled()) log.debug("found role: " + role); } catch (HibernateException e) { log.error("Could not find role for " + role, e); throw e; } return list; } public List<UserVO> getForUsergroup(UsergroupVO usergroup) { List<UserVO> list = new ArrayList<UserVO>(); try { StringBuilder hql = new StringBuilder(); hql.append(" SELECT e "); hql.append(" FROM ").append(getEntityClass().getName()).append(" e "); hql.append(" WHERE e.profile.usergroups.id = :usergroupId "); hql.append(" order by e.userName "); Query query = HibernateContext.getSession().createQuery(hql.toString()); query.setInteger("usergroupId", usergroup.getId()); list = toTypeSafeList(query.list()); if (log.isDebugEnabled()) log.debug("found users: " + list.size()); } catch (HibernateException e) { log.error("Could not find user for " + usergroup, e); throw e; } return list; } public List<UserVO> getList(String userName, Boolean userLocked, Sort sort, Page page, UserVO user) { String _userName = toLower(adjustWildcards(userName)); List<UserVO> list = new ArrayList<UserVO>(); try { StringBuilder hql = new StringBuilder(); hql.append(" FROM ").append(getEntityClass().getName()).append(" e "); hql.append(" WHERE 1=1 "); if (userName != null) hql.append(" AND lower(e.userName) like :userName "); if (userLocked != null) { if (userLocked) { hql.append( " AND ((e.profile.validFrom is not null and e.profile.validFrom > current_timestamp() or e.profile.validUntil is not null and e.profile.validUntil < current_timestamp()) "); hql.append(" or e.profile.locked = true) "); } else { hql.append( " AND not((e.profile.validFrom is not null and e.profile.validFrom > current_timestamp() or e.profile.validUntil is not null and e.profile.validUntil < current_timestamp()) "); hql.append(" or e.profile.locked = true) "); } } if (user != null) { if (!user.getProfile().getRole().isAdmin()) hql.append(" AND e.profile.role.admin = 0 "); hql.append(" AND (e.accessGlobal != '" + EntityAccess.Access.NONE + "' "); hql.append(" OR (e.accessGroup != '" + EntityAccess.Access.NONE + "' "); hql.append(" AND exists (from ").append(UserVO.class.getName()) .append(" as u where u.id = :userId and u.profile.usergroups.id = e.ownerGroup)) "); hql.append(" OR (e.accessUser != '" + EntityAccess.Access.NONE + "' "); hql.append(" AND e.ownerUser = :userId)) "); } if (sort != null) hql.append(" order by " + getSortString(sort)); Query query = HibernateContext.getSession().createQuery(hql.toString()); if (userName != null) query.setString("userName", _userName); if (user != null) query.setInteger("userId", user.getId()); if (page != null) { query.setFirstResult(getFirstResult(page)); query.setMaxResults(getMaxResults(page)); } list = toTypeSafeList(query.list()); if (log.isDebugEnabled()) log.debug("found " + list.size() + " users"); } catch (HibernateException e) { log.error("Could not find users", e); throw e; } return list; } public long countList(String userName, Boolean userLocked, UserVO user) { String _userName = toLower(adjustWildcards(userName)); long count = 0; try { StringBuilder hql = new StringBuilder(); hql.append(" SELECT count(e.id) "); hql.append(" FROM ").append(getEntityClass().getName()).append(" e "); hql.append(" WHERE 1=1 "); if (userName != null) hql.append(" AND lower(e.userName) like :userName "); if (userLocked != null) { if (userLocked) { hql.append( " AND ((e.profile.validFrom is not null and e.profile.validFrom > current_timestamp() or e.profile.validUntil is not null and e.profile.validUntil < current_timestamp()) "); hql.append(" or e.profile.locked = true) "); } else { hql.append( " AND not((e.profile.validFrom is not null and e.profile.validFrom > current_timestamp() or e.profile.validUntil is not null and e.profile.validUntil < current_timestamp()) "); hql.append(" or e.profile.locked = true) "); } } if (user != null) { if (!user.getProfile().getRole().isAdmin()) hql.append(" AND e.profile.role.admin = 0 "); hql.append(" AND (e.accessGlobal != '" + EntityAccess.Access.NONE + "' "); hql.append(" OR (e.accessGroup != '" + EntityAccess.Access.NONE + "' "); hql.append(" AND exists (from ").append(UserVO.class.getName()) .append(" as u where u.id = :userId and u.profile.usergroups.id = e.ownerGroup)) "); hql.append(" OR (e.accessUser != '" + EntityAccess.Access.NONE + "' "); hql.append(" AND e.ownerUser = :userId)) "); } Query query = HibernateContext.getSession().createQuery(hql.toString()); if (userName != null) query.setString("userName", _userName); if (user != null) query.setInteger("userId", user.getId()); count = (Long) query.uniqueResult(); if (log.isDebugEnabled()) log.debug("count " + count + " users"); } catch (HibernateException e) { log.error("Could not find users", e); throw e; } return count; } }