MyBatis IBatis 마이바티스 조회 후 입력 예시

<insert id="insert" parameterType="VO">
    /* VO.insert*/
    <![CDATA[
        INSERT INTO t_send(
          SEND_SEQ
        , RGST_ID
        , RGST_DT
        , TTL
        , CONT
        , DVSN
        )
        VALUES
        ( (SELECT IFNULL(MAX(SD.SEND_SEQ)+1,1) FROM TABLE SD)
         ,#{loginSeq ,jdbcType=VARCHAR}
         ,NOW()
         ,#{ttl ,jdbcType=VARCHAR} 
         ,#{cont ,jdbcType=VARCHAR}  
         ,#{dvsn ,jdbcType=VARCHAR} )
    ]]>
    <selectKey resultType="String" keyProperty="sendSeq" order="AFTER">
    <![CDATA[
        SELECT
        MAX(SEND_SEQ) sendSeq
        FROM TABLE
        WHERE USE_YN = 'Y'
    ]]>
    </selectKey>
</insert>