查询返回对象的List
一、
List<TravelModel> travelList = jdbcTemplate.query(sql.toString(), new BeanPropertyRowMapper<TravelModel>(TravelModel.class));
二、
List<TravelModel> list=jdbcTemplate.query(sql,new RowMapper<TravelModel>(){
@Override
public TravelModel mapRow(ResultSet rs, int rowNum) throws SQLException {
TravelModel bean=new TravelModel();
bean.setF_lottery_num(rs.getString("f_lottery_num"));
bean.setF_act_num(rs.getString("f_act_num"));
bean.setF_lottery_title(rs.getString("f_lottery_title"));
bean.setF_lottery_memo(rs.getString("f_lottery_memo"));
bean.setF_is_use(rs.getInt("f_is_use"));
bean.setF_lottery_probability(rs.getDouble("f_lottery_probability"));
bean.setF_is_target(rs.getInt("f_is_target"));
bean.setF_last_mancode(rs.getString("f_last_mancode"));
bean.setF_last_manname(rs.getString("f_last_manname"));
bean.setF_last_time(rs.getString("f_last_time"));
bean.setF_last_memo(rs.getString("f_last_memo"));
return bean;
}
});