l利用Mybatis将内存封装集合数据添加进数据库

    技术2023-08-18  92

    //方法 void insertDegreeList(@Param(“list”) List list);

    <insert id="insertDegreeList" parameterType="java.util.List"> insert into tbl_scctn_degree ( ORGID,EMPID,ISMAIN,DEPTORGID,DEGREE ) values <foreach collection="list" item="item" index= "index" separator =","> ( #{item.ORGID}, #{item.EMPID}, #{item.ISMAIN}, #{item.DEPTORGID}, #{item.DEGREE} ) </foreach> </insert>
    Processed: 0.010, SQL: 9