objectrowmapper.java

用xml+swing+jdbc(hsqldb)写的电视广告管理软件 客户定义好广告的具体信息

package util;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

public class ObjectRowMapper  implements RowMapper{

	@Override
	public Map<String, java.lang.Object> mapRow(ResultSet rs, int rowNum)
			throws SQLException {
		ResultSetMetaData rsmd = rs.getMetaData();
		int columnCount = rsmd.getColumnCount();
		Map<String,Object> mapOfColValues = new HashMap<String,Object>(columnCount);
		for (int i = 1; i <= columnCount; i++) {
			String key = rsmd.getColumnName(i).toLowerCase();
			Object obj = rs.getObject(i);
			mapOfColValues.put(key, obj);
		}
		return mapOfColValues;
	}


}