menuitemdaoprovider.java

ACEGI数据库保存 ACEGI数据库保存 ACEGI数据库保存

/*
 * Copyright 2004-2005 wangz.
 * Project shufe_newsroom
 */
package com.skyon.um.security.acegi.strutsmenu;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.util.Assert;

import com.skyon.cams.util.StringUtils;
import com.skyon.framework.util.ResultSetProxy;
import com.skyon.um.security.acegi.IConst;

/**
 * @since 2005-8-4
 * @author 王政
 * @version $Id: MenuItemDaoProvider.java,v 1.7 2005/10/26 03:35:59 wangzheng Exp $
 */
public class MenuItemDaoProvider extends JdbcDaoSupport implements MenuItemProvider {
    
    //~ Static fields/initializers =============================================
    
    private static StringBuffer sb = new StringBuffer();
    
    static {
        sb.append(" select ");
        sb.append(" resourceName, ");
        sb.append(" parentName, ");
        sb.append(" action, ");
        sb.append(" title, ");
        sb.append(" description, ");
        sb.append(" target, ");
        sb.append(" location, ");
        sb.append(" onClick, ");
        sb.append(" onMouseover, ");
        sb.append(" image, ");
        sb.append(" altImage, ");
        sb.append(" tooltip, ");
        sb.append(" roles, ");
        sb.append(" page, ");
        sb.append(" width, ");
        sb.append(" height, ");
        sb.append(" forward ");        
        sb.append(" from resource r, permission p ");
        sb.append(" where r.resourceId = p.resourceId ");
        sb.append(" and r.display = '" + IConst.BOOLEAN_TRUE + "' ");
        sb.append(" and r.layer = '" + IConst.WEB_LAYER + "' ");
        sb.append(" and p.roleName = ? ");
    }
    
    public static final String DEFAULT_RESOURCES_BY_RECIPENTS = sb.toString();
    
    private static Log logger = LogFactory.getLog(MenuItemDaoProvider.class);
    
    //~ Instance fields ========================================================
    
    protected String resourcesByRecipientsQuery;
    
    
    //~ Constructors ===========================================================
    
    public MenuItemDaoProvider() {
        if (logger.isDebugEnabled()) {
            logger.debug("Enter " + getClass());
        }
        this.resourcesByRecipientsQuery = DEFAULT_RESOURCES_BY_RECIPENTS;
    }
    
    
    //~ Methods ================================================================
    
    public MenuCompentWrapper[] getMenuItems(final String[] recipients) {
        Assert.notEmpty(recipients, " recipients can't be empty");
        
        List allResources = new LinkedList();
        final Map aleadyAddedResourceMap = new HashMap();
        
        for (int i = 0; i < recipients.length; i++) {
            List list = getJdbcTemplate().query(getResourcesByRecipientsQuery(), new Object[]{ recipients[i] }, new RowMapper() {
                public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
                	ResultSetProxy proxy = new ResultSetProxy(rs);
                    MenuCompentWrapper wrapper = new MenuCompentWrapper();
                    String resourceName = RESOURCE_PREFIX + StringUtils.trimAndBlank2Null(proxy.getString(1));
                    
                    if (aleadyAddedResourceMap.containsKey(resourceName)) {
                    	return null;
                    }              
                    aleadyAddedResourceMap.put(resourceName, new Object());
                    
                    wrapper.setResourceName(resourceName);
                    wrapper.setParentName(RESOURCE_PREFIX + StringUtils.trimAndBlank2Null(proxy.getString(2)));
                    wrapper.setLocation(StringUtils.trimAndBlank2Null(proxy.getString(3)));
                    wrapper.setTitle(StringUtils.trimAndBlank2Null(proxy.getString(4)));                    
                    wrapper.setTarget(StringUtils.trimAndBlank2Null(proxy.getString(5)));
                                        
//                    wrapper.setDescription(StringUtils.blank2Null(proxy.getString(5)));
//                    wrapper.setUrl(StringUtils.blank2Null(proxy.getString(3)));
//                    wrapper.setAction(org.apache.commons.lang.StringUtils.trim(proxy.getString(3)));
//                    wrapper.setOnclick(StringUtils.blank2Null(proxy.getString(8)));
//                    wrapper.setOnmouseover(StringUtils.blank2Null(proxy.getString(9)));
//                    wrapper.setImage(StringUtils.blank2Null(proxy.getString(10)));
//                    wrapper.setAltImage(StringUtils.blank2Null(proxy.getString(11)));
//                    wrapper.setToolTip(StringUtils.blank2Null(proxy.getString(12)));
//                    wrapper.setRoles(StringUtils.blank2Null(proxy.getString(13)));
//                    wrapper.setPage(StringUtils.blank2Null(proxy.getString(14)));
//                    wrapper.setWidth(StringUtils.blank2Null(proxy.getString(15)));
//                    wrapper.setHeight(StringUtils.blank2Null(proxy.getString(16)));
//                    wrapper.setForward(StringUtils.blank2Null(proxy.getString(17)));
                    return wrapper;
                }           
            });
            allResources.addAll(list);
        }
        
        
        for (Iterator iter = allResources.iterator(); iter.hasNext(); ) {
        	if (iter.next() == null) {
        		iter.remove();
        	}
        }
        
        return (MenuCompentWrapper[]) allResources.toArray(new MenuCompentWrapper[0]);
    }

    
    


    /**
     * @return Returns the resourcesByRecipientsQuery.
     */
    public String getResourcesByRecipientsQuery() {
        return resourcesByRecipientsQuery;
    }



    /**
     * @param resourcesByRecipientsQuery The resourcesByRecipientsQuery to set.
     */
    public void setResourcesByRecipientsQuery(String resourcesByRecipientsQuery) {
        this.resourcesByRecipientsQuery = resourcesByRecipientsQuery;
    }
    
    
    
    

}