mybatis用注解方式同时插入多行数据


@Insert("<script>" +
            " insert into t_doc (id, name, doctype, url, typecode, uploadtime, filename)" +
            " values " +
            " <foreach collection = \"list\" item=\"item\" index=\"index\" separator=\",\">" +
            " (#{item.id}, #{item.name}, #{item.doctype}, #{item.url}, #{item.typecode}, now(), #{item.filename})" +
            " </foreach>" +
            "</script>")
int insertList(@Param("list") List<DocEntity> docEntities);


版权声明:本文为ylfmsn原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。