Java - ibatis

atch file table

<insert id="insertAtchFile" parameterClass="kr.or.ddit.member.vo.AtchFileVO">

  <selectKey keyProperty="atchFileId" resultClass="long">
    SELECT atch_file_seq.nextval
    FROM DUAL
  </selectKey>
  INSERT INTO ATCH_FILE
  (
    ATCH_FILE_ID
    ,FILE_SN
    ,FILE_STRE_COURS
    ,STRE_FILE_NM
    ,ORIGNL_FILE_NM
    ,FILE_EXTSN
    ,FILE_CN
    ,FILE_SIZE
    ,CREAT_DT
  )

  VALUES
  (
    #atchFileId# <!-- selectKey 에서 매핑해줘서 atch_file_seq.nextval로 안써줘도됨 -->
    ,#fileSn#
    ,#fileStreCours#
    ,#streFileNm#
    ,#orignlFileNm#
    ,#fileExtsn#
    ,#fileCn#
    ,#fileSize#
    ,#creatDate#
  )	
</insert>

• selectKey 하는 이유: insert한 후 얻은 key값을 저장함으로써 나중에 MemberVO 컬럼에 넣으려고
• 프사같은느낌