jdbc查询返回来的List<Map<String, Object>> 转换成List<Users>

 my.oschina.net/jiefalcon/blog/136581

jdbc查询返回来的List<Map<String, Object>> 转换成List<Users>

public List find() {
	    String sql = "select * from users";
	    List<Users> users = new ArrayList<Users>();
	    List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);
	    for (int i = 0; i < list.size(); i++) {//遍历设置实体
	        Users user = new Users();
	        user.setId((Integer) list.get(i).get("id"));
	        user.setPassword(list.get(i).get("pwd").toString());
	        user.setUserName(list.get(i).get("uname").toString());
	        users.add(user);//添加到List<Users>
	    }

 

另外一种方式：

for(Map<String,Object> map:list){
  for(Map.Entry<String,Object> e:map.entrySet()){
  e.getKey() 和 e.getValue()
  }
} 

 第种方式，待测试

		Map<String, Object> map = new HashMap<String, Object>();
		map.put("key1", "value1");
		map.put("key2", "value2");
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		list.add(map);

		for (Map<String, Object> m : list) {
			for (String k : m.keySet()) {
				System.out.println(k + " : " + m.get(k));
			}
		}