jdbc 使用in

?

1 2	@Inject   NamedParameterJdbcTemplate namedParameterJdbcTemplate;

　　

?

1 2 3 4 5 6 7

public List<TeacherContributionLastCalculated> searchLastCalculated(Set<String> fromIdLst) {         if (fromIdLst.isEmpty()) return new ArrayList<>();         String sql = "select * from ot_teacher_contribution_last_calculated where from_id in (:ids)";         Map<String, Object> param = new HashMap<>();         param.put("ids", fromIdLst);         return namedParameterJdbcTemplate.query(sql, param, EntityRowMapper.rowMapper(TeacherContributionLastCalculated.class));     }