GroupDAO.java

/*
*
* Copyright 2005 AgileTec s.r.l. (http://www.agiletec.it) All rights reserved.
*
* This file is part of jAPS software.
* jAPS is a free software; 
* you can redistribute it and/or modify it
* under the terms of the GNU General Public License (GPL) as published by the Free Software Foundation; version 2.
* 
* See the file License for the specific language governing permissions   
* and limitations under the License
* 
* 
* 
* Copyright 2005 AgileTec s.r.l. (http://www.agiletec.it) All rights reserved.
*
*/
package com.agiletec.aps.system.services.group;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import com.agiletec.aps.system.services.authorization.authorizator.AbstractApsAutorityDAO;

/**
 * Data Access Object per gli oggetti Group. 
 * @author E.Santoboni
 */
public class GroupDAO extends AbstractApsAutorityDAO implements IGroupDAO {
	
	/**
	 * Carica la mappa dei gruppi presenti nel sistema 
	 * indicizzandola in base al nome del gruppo.
	 * @return La mappa dei gruppi presenti nel sistema.
	 */
	@Override
	public Map<String, Group> loadGroups() {
		Connection conn = null;
		Statement stat = null;
		ResultSet res = null;
		Map<String, Group> groups = new HashMap<String, Group>();
		try {
			conn = this.getConnection();
			stat = conn.createStatement();
			res = stat.executeQuery(ALL_GROUPS);
			Group group = null;
			while (res.next()) {
				group = new Group();
				group.setName(res.getString(1));
				group.setDescr(res.getString(2));
				groups.put(group.getName(), group);
			}
		} catch (Throwable t) {
			processDaoException(t, "Error while loading groups", "loadGroups");
		} finally {
			closeDaoResources(res, stat, conn);
		}
		return groups;
	}
	
	/**
	 * Aggiunge un gruppo nel db.
	 * @param group Il gruppo da aggiungere.
	 */
	@Override
	public void addGroup(Group group) {
		Connection conn = null;
		PreparedStatement stat = null;
		try {
			conn = this.getConnection();
			conn.setAutoCommit(false);
			stat = conn.prepareStatement(ADD_GROUP);
			stat.setString(1, group.getName());
			stat.setString(2, group.getDescr());
			stat.executeUpdate();
			conn.commit();
		} catch (Throwable t) {
			this.executeRollback(conn);
			processDaoException(t, "Error while adding a group", "addGroup");
		} finally {
			closeDaoResources(null, stat, conn);
		}
	}
	
	/**
	 * Aggiorna un gruppo nel db.
	 * @param group Il gruppo da aggiornare.
	 */
	@Override
	public void updateGroup(Group group) {
		Connection conn = null;
		PreparedStatement stat = null;
		try {
			conn = this.getConnection();
			conn.setAutoCommit(false);
			stat = conn.prepareStatement(UPDATE_GROUP);
			stat.setString(1, group.getDescr());
			stat.setString(2, group.getName());
			stat.executeUpdate();
			conn.commit();
		} catch (Throwable t) {
			this.executeRollback(conn);
			processDaoException(t, "Error while updating a group", "updateGroup");
		} finally {
			closeDaoResources(null, stat, conn);
		}
	}
	
	/**
	 * Rimuove un gruppo dal db.
	 * @param group Il gruppo da rimuovere.
	 */
	@Override
	public void deleteGroup(Group group) {
		this.deleteGroup(group.getName());
	}
	
	/**
	 * Rimuove un gruppo dal sistema.
	 * @param groupName Il nome del gruppo da rimuovere.
	 */
	@Override
	public void deleteGroup(String groupName) {
		Connection conn = null;
		PreparedStatement stat = null;
		try {
			conn = this.getConnection();
			conn.setAutoCommit(false);
			stat = conn.prepareStatement(DELETE_GROUP);
			stat.setString(1, groupName );
			stat.executeUpdate();
			conn.commit();
		} catch (Throwable t) {
			this.executeRollback(conn);
			processDaoException(t, "Error while deleting a group", "deleteGroup");
		} finally {
			closeDaoResources(null, stat, conn);
		}
	}
	
	@Override
	protected String getLoadAuthsForUserQuery() {
		return SELECT_GROUPS_FOR_USER;
	}
	
	@Override
	protected String getAddUserAuthorizationQuery() {
		return ADD_USER_GROUP;
	}
	
	@Override
	protected String getRemoveUserAuthorizationQuery() {
		return REMOVE_USER_GROUP;
	}
	
	@Override
	protected String getRemoveUserAuthorizationsQuery() {
		return REMOVE_USER_GROUPS;
	}
	
	@Override
	protected String getUserAuthorizatedQuery() {
		return SELECT_USERS_FOR_GROUP;
	}
	
	private final String ALL_GROUPS =
		"SELECT groupname, descr FROM authgroups";
	
	private final String SELECT_GROUPS_FOR_USER =
		"SELECT groupname FROM authusergroups WHERE username = ? ";
	
	private final String SELECT_USERS_FOR_GROUP =
		"SELECT username FROM authusergroups WHERE groupname = ? ";
	
	private final String DELETE_GROUP =
		"DELETE FROM authgroups WHERE groupname = ? ";
	
	private final String ADD_GROUP =
		"INSERT INTO authgroups (groupname ,descr ) VALUES ( ? , ? )";
	
	private final String UPDATE_GROUP =
		"UPDATE authgroups SET descr= ? WHERE groupname = ? ";	
	
	private final String ADD_USER_GROUP =
		"INSERT INTO authusergroups (username, groupname) VALUES ( ? , ? )";
	
	private final String REMOVE_USER_GROUP =
		"DELETE FROM authusergroups WHERE username = ? AND groupname = ? ";
	
	private final String REMOVE_USER_GROUPS =
		"DELETE FROM authusergroups WHERE username = ? ";
	
	
}