把实体类型List中的数据插入到数据库中

首先实体类:

@Data
public class Uesr{
          
   
    private String resrowld;
    private Date transactionDate;
    private String price;
    private String transactioncode;
    private String trndescription;
}

测试类:

@Test
  public R Test(){
          
     
  ...
  List<Uesr> list = irecordService.queryklbill(name);
  boolean insertionlist = ipensedetailService.insertionlist(list);
 }

重点就是Mapper.xml文件该如何写

<insert id="insertionlist"   parameterType="java.util.List" useGeneratedKeys="false">
        insert into detail(
        Res_RowID,
        TransactionDate,
        Price,
        TransactionCode,
        TrnDescription
        )
        values
        <foreach collection="list" item="item" index= "index" separator =",">
        (
        #{
          
   item.resrowld,jdbcType=VARCHAR},
        #{
          
   item.transactionDate,jdbcType=VARCHAR},
        #{
          
   item.price,jdbcType=VARCHAR},
        #{
          
   item.transactioncode,jdbcType=VARCHAR},
        #{
          
   item.trndescription,jdbcType=VARCHAR}
        )
        </foreach>
    </insert>

可能写的不够清晰 但仔细看还是能够看的懂得…