java中xml文件中的foreach循环sql语句
实体类
@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>