sqltreeservice.java

管理公司合同

/*
 * Created on 2006-8-8 14:38:08
 *
 * By SinoBest
 * Copyright hnisi.com.cn, 2005-2006, All rights reserved.
 */

package cn.com.juneng.system.common.taglib.tree;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import cn.com.juneng.system.common.COMMON;
import cn.com.juneng.system.common.exception.DBOperException;
import cn.com.juneng.system.common.util.SimpleDAO;

/**
 * 直接根据sql语句构造树形结构，sql语句格式： select ** as nodeid,** as nodename,** as parentid
 * from .....
 * 
 * @author yehailong
 * 
 */

public class SqlTreeService implements ITreeService {
	private List list = new ArrayList();

	public SqlTreeService(String sql) {
		try {
			List valueList = SimpleDAO.query(sql);

			for (int i = 0; i < valueList.size(); i++) {
				Map valueMap = (Map) valueList.get(i);
				SimpleTreeNode treeNode = new SimpleTreeNode();
				if (valueMap.get("PARENTID") != null) {
					treeNode.setParentId((String) valueMap.get("PARENTID"));
				} else {
					treeNode.setParentId("0");
				}
				treeNode.setNodeId((String) valueMap.get("NODEID"));
				treeNode.setNodeName((String) valueMap.get("NODENAME"));

				list.add(treeNode);
			}
		} catch (DBOperException e) {
			e.printStackTrace();
		}
	}

	public List findAllRecords() {
		return list;
	}

	public ITreeNode findByNodeId(String nodeId) {
		if (!COMMON.isEmpty(this.list)) {
			Map map = COMMON.collection2map(list, "nodeId");
			return (ITreeNode) map.get(nodeId);
		} else {
			return null;
		}
	}

	public List findSubNode(String nodeId) {
		// TODO Auto-generated method stub
		return null;
	}

}