9.1，spring Template将查询的结果封装成map,list,bean的list

1.map

 注意：这个方法查询的结果集长度只能是1
 String sql = "select * from emp where id = ? or id = ?";
				        Map<String, Object> map = template.queryForMap(sql, 1001,1002);
				        System.out.println(map);
				        //{id=1001, ename=孙悟空, job_id=4, mgr=1004, joindate=2000-12-17, salary=10000.00, bonus=null, dept_id=20}

2.list

String sql = "select * from emp";
				        List<Map<String, Object>> list = template.queryForList(sql);
				
				        for (Map<String, Object> stringObjectMap : list) {
				            System.out.println(stringObjectMap);
				        }

3.类的集合

String sql = "select * from emp";
		        List<Emp> list = template.query(sql, new RowMapper<Emp>() {//匿名内部类，重写这个方法
		
		            @Override
		            public Emp mapRow(ResultSet rs, int i) throws SQLException {
		                Emp emp = new Emp();
		                int id = rs.getInt("id");
		                String ename = rs.getString("ename");
		                int job_id = rs.getInt("job_id");
		                int mgr = rs.getInt("mgr");
		                Date joindate = rs.getDate("joindate");
		                double salary = rs.getDouble("salary");
		                double bonus = rs.getDouble("bonus");
		                int dept_id = rs.getInt("dept_id");
		
		                emp.setId(id);
		                emp.setEname(ename);
		                emp.setJob_id(job_id);
		                emp.setMgr(mgr);
		                emp.setJoindate(joindate);
		                emp.setSalary(salary);
		                emp.setBonus(bonus);
		                emp.setDept_id(dept_id);
		
		                return emp;
		            }
		        });
		
		
		        for (Emp emp : list) {
		            System.out.println(emp);
		        }

用实现类来封装成list,非常方便

String sql = "select * from emp";
				        List<Emp> list = template.query(sql, new BeanPropertyRowMapper<Emp>(Emp.class));
				        for (Emp emp : list) {
				            System.out.println(emp);
				        }