package org.virtus.study.remotesql.app.base.data;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Types;

import org.springframework.jdbc.core.RowMapper;

/**
 * Spring JDBC 查询默认Row mapper
 * 
 */
@SuppressWarnings("rawtypes")
public final class QueryRowMapper implements RowMapper
{
	private ResultSetMetaData meta;
	public Object mapRow(ResultSet rs, int rowNum) throws SQLException
	{
		if (this.meta == null) this.meta = rs.getMetaData();

		MapEx<String,?> map = new MapEx<String,Object>();
		for (int i = 1; i <= this.meta.getColumnCount(); i++)
		{
			/**
			 * getColumnName 在mysql下有问题，获取不到字段的别名( AS 后面的)
			 */
			//String key = this.meta.getColumnName(i);
			String key = this.meta.getColumnLabel(i);
			
			int columnType = this.meta.getColumnType(i);
			if (columnType == Types.TIMESTAMP || columnType == Types.DATE)
			{
				map.set(key, rs.getTimestamp(i));
			}
			else
			{
				map.set(key, rs.getString(i));
			}
		}
		return map;
	}
}