ibatis中加入外键

希望对大家能有所帮助

在mysql下： 
<!-- 创建外键 -->
     <statement id="createFK" parameterClass="parameterBean"  >
      <![CDATA[
      ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE ON DELETE CASCADE
       ]]>
     </statement>


在oracle下：（没有级联更新,不能使用on delete cascade)
<!-- 创建外键 -->
     <statement id="createFK" parameterClass="parameterBean"  >
      <![CDATA[
      ALTER TABLE famm_groups_users ADD FOREIGN KEY(mainUserID) REFERENCES $mtableName$($muserPK$) ON UPDATE CASCADE        ]]>
     </statement>