import?java.io.IOException;
import?java.sql.Timestamp;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

import?org.apache.commons.beanutils.BeanUtilsBean;
import?org.apache.commons.beanutils.ConvertUtilsBean;
import?org.apache.commons.beanutils.converters.DateConverter;
import?org.dbunit.dataset.Column;
import?org.dbunit.dataset.DataSetException;
import?org.dbunit.dataset.IDataSet;
import?org.dbunit.dataset.ITable;
import?org.dbunit.dataset.xml.FlatxmlDataSet;
import?org.springframework.core.io.ClassPathResource;

/**
?*?
?*?從dbunit的FlatxmlDataSet格式的xml文件創建bean
?*?
?*?@author?maoshijie.pt
?*?
?*/
public?class?DBUnitUtils?{

	/**
	?*?從dbunit的flatxmlDataSet中，創建多個bean
	?*?
	?*?@param?
	?*?@param?file
	?*?@param?clazz
	?*?@param?ignoredProps
	?*?@return
	?*?@throws?Exception
	?*/
	public?static??List?createBeans（String?file?String?tableName
			Class?clazz）?throws?Exception?{
		BeanUtilsBean?beanUtils?=?createBeanUtils（）;
		Listject>>?propsList?=?createProps（file?tableName）;
		List?beans?=?new?ArrayList（）;
		for?（Mapject>?props?:?propsList）?{
			T?bean?=?clazz.newInstance（）;
			beanUtils.populate（bean?props）;
			beans.add（bean）;
		}
		return?beans;
	}

	/**
	?*?從dbunit的flatxmlDataSet中，創建bean
	?*?
	?*?@param?
	?*?@param?file
	?*?@param?clazz
	?*?@param?ignoredProps
	?*?@return
	?*?@throws?Exception
	?*/
	public?static??T?createBean（String?file?String?tableName?Class?clazz）
			throws?Exception?{
		BeanUtilsBean?beanUtils?=?createBeanUtils（）;
		Listject>>?propsList?=?createProps（file?tableName）;
		T?bean?=?clazz.newInstance（）;
		beanUtils.populate（bean?propsList.get（0））;
		return?bean;
	}

	private?static?Listject>>?createProps（String?file
			String?tableName）?throws?IOException?DataSetException?{

		Listject>>?propsList?=?new?ArrayListject>>（）;

		IDataSet?expected?=?new?FlatxmlDataSet（Thread.currentThread（）
				.getContextClassLoader（）.getResourceAsStream（file））;
		ITable?table?=?expected.getTable（tableName）;
		Column[]?columns?=?table.getTablemetaData（）.getColumns（）;
		
		for?（int?i?=?0;?i?			Mapject>?props?=?new?HashMapject>（）;
			for?（Column?c?:?columns）?{
				object?value?=?table.getValue（i?c.getColumnName（））;
				String?propName?=?underlineToCamel（c.getColumnName（））;
				props.put（propName?value）;
			}
			propsList.add（props）;
		}
		return?propsList;
	}

	private?static?String?underlineToCamel（String?str）?{
		String?pattern[]?=?str.split（“_“）;
		StringBuilder?builder?=?new?StringBuilder（）;
		for?（int?i?=?0;?i?			if?（i?==?0）?{
				builder.append（pattern[i]）;
			}?else?{
				builder.append（pattern[i].substring（0?1）.toUpperCase（））;
				builder.append（pattern[i].substring（1））;
			}
		}
		return?builder.

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3649??2009-11-24?19:40??DBUnitUtils.java

-----------?---------??----------?-----??----

?????????????????3649????????????????????1