mybatis中xml配置

• ID = #{id,jdbcType=BIGINT}

• ID IN (${ids})--------------------与#{}区别在于ids字符串变量两边不会带引号

• UPDATED_AT = now()

• 时间范围

        <if test="startTime !=null  and endTime !=null">
            <![CDATA[
                AND CREATED_AT>=  #{startTime,jdbcType=VARCHAR}
                AND CREATED_AT<= #{endTime,jdbcType=VARCHAR}
          ]]>
        </if>