Freemarker list的使用

Freemarker list的使用

更新多条记录的操作，这里ids是一个数组

<sqltemplate id = "disableBuildLabourer">
    <![CDATA[
        UPDATE build_labourer SET
            status = 0
        WHERE id IN
        (
        <#list ids as num>
             ${num}
         <#if num_has_next>,</#if>
         </#list>
         )
    ]]>
 </sqltemplate>

 

插入多条记录的操作，这里buildLabourerList是一个List<BuildLabourer>的集合

<sqltemplate id="batchImportBuildLabourer">
    <![CDATA[
        INSERT INTO build_labourer
        (
            realname,
            sex,
            id_card,
            work_type,
            nation,
            address,
            phone
        )VALUES
        <#list buildLabourerList as buildLabourer>
            (
                '${buildLabourer.realname}',
                '${buildLabourer.sex}',
                '${buildLabourer.idCard}',
                '${buildLabourer.workType}',
                '${buildLabourer.nation}',
                '${buildLabourer.address}',
                '${buildLabourer.phone}'
            )
        <#if buildLabourer_has_next>,</#if>
        </#list>
    ]]>
    </sqltemplate>

 

posted @ 2018-07-13 12:36 Rest探路者 阅读( ...) 评论( ...) 编辑 收藏