myBatis主键自增长sql

Insert

<insert id="insertVoteComment" parameterType="" keyProperty="F_COMMENT_ID">

<selectKey resultType="String"order="BEFORE" keyProperty="fCommentId">

               selectto_char(sysdate,'yyyyMMddhhmiss')||seq_vote_comment.nextval as fCommentId fromdual

         </selectKey> 

    insert into TV_VOTE_COMMENT(

            F_COMMENT_ID,     

            F_ACTIVE_ID,      

            F_DETAIL_ID,      

            F_COMMENT_MOBILE, 

            F_COMMENT_TIME,   

            F_COMMENT_CONTENT,

            F_AUDIT_STATE,    

            F_AUDIT_ID,       

            F_AUDIT_MAIN,     

            F_AUDIT_TIME,     

            F_AUDIT_DESC     )

     values(

           #{fCommentId,jdbcType=VARCHAR},

           #{fActiveId,jdbcType=VARCHAR},

           #{fDetailId,jdbcType=VARCHAR},

           #{fCommentMobile,jdbcType=VARCHAR},

           to_char(sysdate,'yyyyMMddhh24miss'),

           #{fCommentContent,jdbcType=VARCHAR},

           #{fAuditState,jdbc=Integer},

           #{fAuditId,jdbcType=VARCHAR},

           #{fAuditMain,jdbcType=VARCHAR},

           #{fAuditTime,jdbcType=VARCHAR},

           #{fAuditDesc,jdbcType=VARCHAR},

 

         )

   

    </insert>

 

 

Xml配置文件的，${}和#{}

#{}解析后默认有引号‘小李’

${}解析后无引号