expimpmappingconfig.java

来自「OBPM是一个开源」· Java 代码 · 共 48 行

package cn.myapps.core.expimp.exp.ejb;

import java.util.Collection;
import java.util.LinkedHashMap;
import java.util.Map;

import cn.myapps.core.expimp.exp.util.SQLPackage;

public class ExpIMPMappingConfig extends ExpElement {

	public final static String NAME = "T_MAPPCONFIG_IMPEXCEL";

	public ExpIMPMappingConfig(boolean expAll) {
		super(expAll);
	}

	public String getName() {
		return NAME;
	}

	public Map exportSQLS(String[] ids, Collection ignoreIds) throws Exception {
		Map rtn = new LinkedHashMap();
		StringBuffer query = new StringBuffer();

		for (int i = 0; i < ids.length; i++) {

			if (ignoreIds.contains(ids[i]))
				continue;

			ignoreIds.add(ids[i]);

			query.append("SELECT * FROM ");
			query.append(NAME + " ");
			query.append("WHERE id ='");

			query.append(ids[i] + "'");

			SQLPackage values = new SQLPackage(NAME, query.toString());
			if (!isExpAll()) {
				values.addRestColumn(FOREINGKEY_COLUMN_MODULE);
			}
			rtn.put(ids[i], values);
			query = new StringBuffer();
		}
		return rtn;
	}
}