ibatis批量数据入库sql

ibaits 批量数据入库sql
<insert id="waiter.insertBatch" parameterClass="java.util.List">
        <![CDATA[
        insert into rc_waiter (
        account,
        emp_id,
        data_time
        )
        values
        ]]>
        <iterate conjunction ="," >
            <![CDATA[
            (
            now(),
            now(),
            #hello[].account#,
            #hello[].empId#,
            #hello[].dataTime#
            )
            ]]>
        </iterate>
    </insert>

 

posted @ 2022-09-08 13:55  hehehenhen  阅读(99)  评论(0)    收藏  举报