jdbc 集合返回map

package org.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.Map.Entry;

public class TestOracle {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@localhost:1521:ora";
			String uname = "scott";
			String pssw = "tiger";
			Connection cn = DriverManager.getConnection(url,uname,pssw);
			
			PreparedStatement ps = cn.prepareStatement("select * from emp");

			ResultSet rs = ps.executeQuery();
		
			ResultSetMetaData rsmd = rs.getMetaData();
			int colCount = rsmd.getColumnCount();
			List<Map> list = new ArrayList<Map>();
			while(rs.next()){
				Map<String,Object> colMap = new HashMap<String, Object>(colCount);
				for(int i=1 ;i<=colCount ;i++){
					String colName = rsmd.getColumnName(i);
					Object colValue = rs.getObject(colName);
					colMap.put(colName, colValue);
				}
				list.add(colMap);
			}
			
			
			//测试 查看第一条list<map>
			
			Object colValue = list.get(0).get("ENAME");
			pr(colValue);
			pr("-----------------------------------------");
			//测试 遍历所有list<map>
			for(Map<String,Object> map : list){
				Set<Entry<String, Object>> ens = map.entrySet();
				Iterator<Entry<String, Object>> it = ens.iterator();
				while(it.hasNext()){
					Entry<String, Object> ent = it.next();
					String colName = ent.getKey();
					Object value = ent.getValue();
					pr(colName+":"+value);
				}
			}
			
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public static void pr(Object p){
		System.out.println(p);
	}

}