Spring JDBC ResultSetExtractor接口示例

public List<Student> listStudents() {
   String SQL = "select * from Student";
      List <Student> students = jdbcTemplateObject.query(SQL, 
         new ResultSetExtractor<List<Student>>(){
            public List<Student> extractData(
               ResultSet rs) throws SQLException, DataAccessException {
               List<Student> list=new ArrayList<Student>();  
               while(rs.next()){  
                  Student student = new Student();
                  student.setId(rs.getInt("id"));
                  student.setName(rs.getString("name"));
                  student.setAge(rs.getInt("age"));
                  student.setDescription(rs.getString("description"));
                  student.setImage(rs.getBytes("image"));
                  list.add(student);  
               }  
               return list;  
            }          
         });
   return students;
}

https://www.yiibai.com/springjdbc/resultsetextractor.html