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;
}
}