<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>

<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>