<select id="selectUserByList" parameterClass="HashMap" resultClass="UserInfo">

      select * from user

        <dynamic prepend="WHERE">

            <isNotNull property="userId">

                <iterate property="userId" conjunction=" or " close=")" open="(">

                    userId = #userId[]#

                </iterate>

            </isNotNull>

        </dynamic>

</select>

<delete id="del" parameterClass="HashMap">

    DELETE FROM user WHERE  userId  in

    <iterate property="userIds" conjunction="," open="(" close=")">

        #userIds[]#

    </iterate>

  </delete>

<!-- addSerialNumbers 添加流水号     select fn_sys_max('itk_ticket2') -->

   <insert id="addSerialNumbers"  parameterClass="java.util.List">

           INSERT into itk_ticket2

        (tkt_id,tkt_code,tkt_name,tkt_amt,START_DATE,END_DATE,CREATED_USERID,CREATED_USERNAME,CREATED_TIME)

        VALUES

           <dynamic>

            <iterate conjunction=",">

                 ((select fn_sys_max('itk_ticket2'))

                 ,#comList[].tktCode#

                 ,#comList[].tktName#

                 ,#comList[].tktAmt#

                 ,#comList[].startDate#

                 ,#comList[].endDate#

                 ,#comList[].createdUserId#

                 ,#comList[].createdUserName#

                 ,now()

                 )

             </iterate>

        </dynamic>

   </insert>