jdbc查询中出错 java.sql.SQLException: 无效的列索引

<pre name="code" class="java"><span style="font-family: Arial, Helvetica, sans-serif;"></span>

StringBuffer sql = new StringBuffer();
		sql.append(" SELECT SMID, ID, NAME, PROV_CODE, UPDATA_TIME FROM "+tableName+" WHERE PROV_CODE = "+daoParmasData.getREGION_CODE());
		PreparedStatement ps = conn.prepareStatement(sql.toString());
		ResultSet rset= ps.executeQuery();
		ResultSetMetaData md = rset.getMetaData(); 
		//取得结果集列数
		int col = md.getColumnCount();
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		Map<String, Object> rowData = null;
		while(rset.next()){
			rowData = new HashMap<String,Object>();
			for (int i = 0; i <= col; i++) {
				rowData.put(md.getColumnLabel(i), rset.getObject(md.getColumnLabel(i)));
			}
			list.add(rowData);
		}
		ps.close();
		return list; 

按照上面的例子，想把查出来的字段和值放在集合里面。可是在执行循环的时候出现错误，无效的索引。然后测试了一下拿到

ResultSetMetaData md里面的值，用这个<code><a target=_blank href="" style="font-weight: bold;">getColumnName</a>()方法，这个方法的索引是从1开始的，不是0.所以只要修改循坏里面的i的初始值，将0改为1，就OK了！索引错误还要认真检查sql的拼写！</code>