columnanalyzer.java

羽量级数据持久层开发框架

package org.speedframework.utilities;

import org.apache.log4j.Logger;

import org.speedframework.entity.CacheColumnBean;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class ColumnAnalyzer {

	protected static final Logger log = Logger.getLogger(ColumnAnalyzer.class);

	public static String[] getColumnName(List columnList) {
		String[] columns = new String[columnList.size()];

		for (int i = 0; i < columnList.size(); i++) {
			CacheColumnBean bean = (CacheColumnBean) columnList.get(i);

			columns[i] = bean.getColumnname();
		}

		return columns;
	}

	public static String[][] getColumnType(List columnList, List inColumn) {
		String[][] types_ = new String[inColumn.size()][1];

		for (int i = 0; i < inColumn.size(); i++) {
			String column = inColumn.get(i).toString();

			// log.debug(types_[i].toString());

			String column_type = "";

			for (int j = 0; j < columnList.size(); j++) {
				CacheColumnBean bean = (CacheColumnBean) columnList.get(j);

				if (column.toLowerCase().equals(
						bean.getColumnname().toLowerCase())) {
					column_type = bean.getDatatype();

					break;
				}
			}

			types_[i] = new String[] { column, column_type };
		}

		return types_;
	}

	public static String[] getPrimaryColumnName(List columnList) {
		List column = new ArrayList();
		Iterator it = columnList.iterator();

		while (it.hasNext()) {
			CacheColumnBean bean = (CacheColumnBean) it.next();

			if (bean.isPrimarykey()) {
				column.add(bean.getColumnname());
			}
		}

		String[] columns = new String[column.size()];

		for (int i = 0; i < column.size(); i++) {
			columns[i] = (String) column.get(i);
		}

		return columns;
	}

	public static String getAutoIncrementColumnName(List columnList) {
		String column = "";

		for (int i = 0; i < columnList.size(); i++) {
			CacheColumnBean bean = (CacheColumnBean) columnList.get(i);

			if (bean.isAutoincrement()) {
				column = bean.getColumnname();

				break;
			}
		}

		return column;
	}

	public static String getTableSchem(List columnList) {
		String tableschem = "";

		for (int i = 0; i < columnList.size(); i++) {
			CacheColumnBean bean = (CacheColumnBean) columnList.get(i);
			if (bean.getTableschem() != null
					&& !"".equals(bean.getTableschem())) {
				tableschem = bean.getTableschem();
				break;
			}
		}

		return tableschem;
	}

}