不再service循环添加实体类 在sql中批量添加实体类

    技术2022-07-10  132

    service层: aaaaMapper.addResiList(aList); aList(实体类集合)

    dao层: int addResiList(@Param(“aList”)List aList);

    xml: insert into expriment_settings_resistance (EXPID, MEDICINENAME_CHS, MEDICINENAME_EN, S, I, R) values (#{expResi.expid,jdbcType=INTEGER}, #{expResi.medicinenameChs,jdbcType=VARCHAR}, #{expResi.medicinenameEn,jdbcType=VARCHAR}, #{expResi.s,jdbcType=VARCHAR}, #{expResi.i,jdbcType=VARCHAR}, #{expResi.r,jdbcType=VARCHAR})

    Processed: 0.011, SQL: 9