1.dao

public interface MapperSelecteAllEmpDao {    public List
     
       all();}
     

2.实现类

public class MapperAllEmpImpl extends JdbcDaoSupport implements        MapperSelecteAllEmpDao {    @Override    public List
     
       all() {        String sql = "select * from emp";        List
      
        list = this.getJdbcTemplate().query(sql, new EmpRowMapper());        return list;    }}
      
     

3.继承rowMapper接口，返回自定义类型

public class EmpRowMapper implements RowMapper
     
       {    @Override    public Emp mapRow(ResultSet rs, int arg1) throws SQLException {        Emp emp = new Emp();        emp.setId(rs.getInt("id"));        emp.setName(rs.getString("name"));        emp.setAge(rs.getInt("age"));        return emp;    }}
     

4.测试

@Test    // Spring使用rowMapper查询表中所有记录    public void rowMapperAll() {        ApplicationContext ac = new ClassPathXmlApplicationContext(                "applicationContext.xml");        MapperSelecteAllEmpDao mapperSelectAll = (MapperSelecteAllEmpDao) ac                .getBean("mapperAll");        List
     
       empList = mapperSelectAll.all();        for (Emp emp : empList) {            System.out.println(emp.getName());        }    }