rowsutils.java

Speedframework--基于类型元数据的羽量级ORM.完全基于Java类型元数据和反射机制同时不需要任何对象关系映射配置文件的轻量级ORM框架,它充分利用了类型本身的信息,使用Metadata

package org.speedframework.util;

import java.sql.*;
import java.util.*;

//import org.apache.log4j.Logger;
//import org.speedframework.engine.impl.ExecuteImpl;

/**
 * <p>
 * Title: SpeedFrameworkWork持久层框架
 * </p>
 * 
 * <p>
 * Description: 集合拷贝类
 * </p>
 * 
 * <p>
 * Copyright: Copyright (c) 2006
 * </p>
 * 
 * <p>
 * Company: SpeedFrameworkWork team
 * </p>
 * 
 * @author 李志峰 电话：[phone] 程伟杰 电话：
 * @version 1.0
 */
public class RowsUtils {
//	private static final Logger log = Logger.getLogger(RowsUtils.class);
	public RowsUtils() {
	}

	/**
	 * copy db value from ResultSet
	 * 
	 * @param rs
	 *            ResultSet
	 * @param voclass
	 *            Class or null
	 * @throws Exception
	 * @return List
	 */
	public static List copyRows(ResultSet rs, Class voclass) throws Exception {
		Object vo = null;
		ResultSetMetaData rsm = null;
		List relist = null;
		rsm = rs.getMetaData();
		relist = new ArrayList();
		Map entity = null;		
		while (rs.next()) {
			// Map entity = new FastHashMap();
			if (voclass != null) {
				vo = voclass.newInstance();
			} else {
				entity = new HashMap();
			}
			for (int i = 1; i <= rsm.getColumnCount(); i++) {
				String columnName = rsm.getColumnName(i).toLowerCase();				
					Object value = null;
					// entity.put(rsm.getColumnName(i).toLowerCase(),
					// rs.getObject(i));
//					log.debug("columnName::"+columnName);
					if (voclass != null) {	
						if (!columnName.equals("rownum")
								&& !columnName.equals("rownum_")
								&& !columnName.equals("count_")) {
//						value = ConvertUtil.outPortData(rs, i, columnName,
//								voclass);
							value = ConvertUtil.outPortData(rs,columnName,
									voclass);
						PropertyUtil.setProperty(vo, columnName, value);
						}
						
					} else {
						value = rs.getObject(i);
						entity.put(columnName, value);
					}
				

			}
			if (voclass != null) {
				relist.add(vo);
			} else {
				relist.add(entity);
			}
		}
		return relist;
	}
}