java中xml文件中的foreach循环sql语句

最新推荐文章于 2024-07-19 17:37:28 发布

qq_42702252

最新推荐文章于 2024-07-19 17:37:28 发布

阅读量1.3k

点赞数

文章标签： java sql xml

本文链接：https://blog.csdn.net/qq_42702252/article/details/129120623

版权

实体类

@Data
public class BatChSysUserDTO {
    private List<Long> id;
    private List<String> name;
    private List<String> sex;
    private List<String> remark;
}

查询

mapper层

List<SysUser> selectbatch (@Param("list") BatChSysUserDTO batChSysUserDTO);

xml层

<select id="selectbatch" resultType="com.example.demo.entity.SysUser">
    SELECT * FROM  sys_user
             where name in
    <foreach item="item" collection="list.name" open="(" separator="," close=")">
        #{item}
    </foreach>
</select>

新增

实体类为

public class CheckComentEntity {
  /*t_check_coment*/
  private Long    id;
  @JsonSerialize(using = ToStringSerializer.class)
  private Long    checkId;

  private String  checkCategory;

  private String  checkType;
  private String  checkConment;
  private String  riskLevel;
  private String  description;
  private String  remark;
  private String  isInput;
  private String  business;
  private String  itemName;
  private Date    createTime;
  private Date    updateTime;
  private Integer checkResult;
  private String  questionDescription;

}

mapper 层

void addCheckConment(@Param("list") List<CheckComentEntity> list);

xml层

<insert id="addCheckConment" parameterType="java.util.List">
    insert into
        t_check_conment_save
        (check_id,check_type,check_conment,risk_level,description,remark,check_result,check_conment_status,create_time,update_time,item_name,question_description)
    values
    <foreach collection="list" item="item" index="index" separator=",">
        (
        #{item.checkId},#{item.checkType},#{item.checkConment},#{item.riskLevel},
         #{item.description},#{item.remark},#{item.checkResult},'0',now(),now(),#{item.itemName},#{item.questionDescription}
         )
    </foreach>
</insert>