mysql in 后面接收传入的list

loading....

已于 2022-07-28 10:06:10 修改

阅读量2.5k

点赞数

分类专栏：笔记文章标签： java

于 2020-07-29 16:50:29 首次发布

本文链接：https://blog.csdn.net/qq_40996012/article/details/107669585

版权

笔记专栏收录该内容

4 篇文章 0 订阅

订阅专栏

 public void saveListArray(List<UserDuty> paramArray,List<String> date,List<String> user) {
        log.info("-----------------------------------------------------------"+paramArray);
       String date2= "\""+StringUtil.join(date.toArray(),"\",\"")+"\"";
       String user2="\""+StringUtil.join(user.toArray(),"\",\"")+"\"";
        //根据条件获取id的集合
      List<Map> idList= this.baseMapper.getIdList(date2,user2);
      log.info("id集合"+idList);
      this.baseMapper.deleteListById(idList);
}

 <select id="getIdList" resultType="map" parameterType="string">
        select t.id from tb_user_duty t
where t.user_id in (${user}) and
     t.`date`in (${date})
order by t.user_id
    </select>