spring管理后用迭代的方法
public List findZBB() {this.jdbcTemplate = Factory.getJdbcTemplate();//得到连接List zbList = new ArrayList(); // 返回页面的listString sql = "select * from onduty where o_date > (sysdate - 1) and o_date < (sysdate + 1)"+ " order by DECODE(o_name1,'值班所领导',1,'值班科长',2,'值班民警',3)";List findList = jdbcTemplate.queryForList(sql);Iterator tt = findList.iterator();while (tt.hasNext()) {JobBean zbb = new JobBean();Map jdMap = (Map) tt.next();zbb.setJobid(jdMap.get("o_id") == null ? "" : jdMap.get("o_id").toString()); // 值班排班idzbb.setJpost(jdMap.get("o_name1") == null ? "" : jdMap.get("o_name1").toString()); // 职位zbb.setName(jdMap.get("o_name2") == null ? "" : jdMap.get("o_name2").toString()); // 添加值班姓名zbb.setMobile(jdMap.get("o_name3") == null ? "" : jdMap.get("o_name3").toString()); // 添加值班人固定电话zbb.setPhone(jdMap.get("o_name4") == null ? "" : jdMap.get("o_name4").toString()); // 添加值班人手机zbList.add(zbb);}return zbList;}

?