JdbcTemplate中向in语句传参_jdbctemplate in()传参-CSDN博客

本文介绍如何在Java中使用NamedParameterJdbcTemplate进行数据库操作，重点讲解了数组转换为List的方法，以及如何通过参数化查询提高代码的可读性和维护性。示例展示了如何查询特定租户和教师的评分信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.JdbcTemplate

使用 NamedParameterJdbcTemplate

2.使用List传递而不是数组[]

数组转List的方法：

先装箱，转为引用类型，再转为List<T>

例子：

long[] itmes 转为 List<Long>

 1)
  Arrays.asList(ArrayUtils.toObject(items))  
 2) JAVA 8  方式：  LongStream.of(items).boxed().collect(Collectors.toList())

    public List<TeacherScoreModel> selectListRecentTimesEvalInfo(Long tenantId ,long[] items,List<String> teacherNoList){
        if (items ==null || items.length == 0) {
            log.warn("items size is 0.");
            return new ArrayList<>();
        }
        if (Inspections.isEmpty(teacherNoList)) {
            log.warn("teacherNoList is 0.");
            return new ArrayList<>();
        }
        log.info("1.2.2/1.3.2最近几次评教  tenantId={},items={},teacherNoList={}",tenantId,items,teacherNoList);
        String sql = " SELECT teacher_name,teacher_no,total_score,analysis_item_id,analysis_item_name FROM getv001_teacher_score_by_teacher " +
                " WHERE tenant_id=:tenantId AND teacher_no IN (:teacherNoList) AND analysis_item_id IN (:items) ORDER BY analysis_item_id ASC";
        Map<String, Object> params = new HashMap<>();
        params.put("tenantId", tenantId);
        params.put("teacherNoList", teacherNoList);
        params.put("items",Arrays.asList(ArrayUtils.toObject(items)));
        List<TeacherScoreModel> list=jdbcTemplate.query(sql, params,new BeanPropertyRowMapper(TeacherScoreModel.class));
        log.info("1.2.2/1.3.2最近几次评教  list={}",list);
        return list;
    }