BeanPropertyRowMapper

public List<Course> findStdCourseByPid(int pid) {

		String sql = "select * from 7east_course where parentid=?";
		BeanPropertyRowMapper<Course> argTypes = new BeanPropertyRowMapper<Course>(Course.class);

		Object[] args = new Object[] { pid };
		List<Course> list = getJdbcTemplate().query(sql, args, argTypes );

		return list;

		}





RowMapper



public class AccountDaoImpl implements AccountDAO {
private JdbcTemplate jt;

public AccountDaoImpl() {
   super();
}

public AccountDaoImpl(JdbcTemplate jt) {
   super();
   this.jt = jt;
}

public JdbcTemplate getJt() {
   return jt;
}

public void setJt(JdbcTemplate jt) {
   this.jt = jt;
}

public List<?> findAcctMonthDetails(String labip, int year, int month) {
   String sql = "select dayofmonth(logouttime),sum(duration) from detailmonths_? " +
     "where labip=? and YEAR(logouttime)=? group by DAYOFMONTH(logouttime)";
   List<?> list = jt.query(sql, new Object[] { month, labip, year },
     new RowMapper() {
      @Override
      public Object mapRow(ResultSet rs, int n)
        throws SQLException {
       AccountMonthDetails amd = new AccountMonthDetails();
       amd.setDay(rs.getInt(1));
       amd.setDuration(rs.getLong(2));
       return amd;
      }
     });
   return list;
}

}