springboot 注解 sql ,插入数据、更新数据时，设置创建时间

springboot 注解 sql ,设置创建时间

mysql 写法
@Update({
    "update electronic_invoice_user",
    "set phone = #{phone,jdbcType=VARCHAR}, ",
      "wechat_userid = #{wechatUserid,jdbcType=VARCHAR},",
      "userid = #{userid,jdbcType=VARCHAR},",
      "source_code = #{sourceCode,jdbcType=VARCHAR},",
      "update_time = now(),",    更新时间
      "remark = #{remark,jdbcType=VARCHAR}",
    "where certificate_no = #{certificateNo,jdbcType=INTEGER}"
})
/*根据证件号更新手机号*/
int updateUserPhone(ElectronicInvoiceUser record);

oracle 写法
@Update({
    "update electronic_invoice_user",
    "set phone = #{phone,jdbcType=VARCHAR}, ",
      "wechat_userid = #{wechatUserid,jdbcType=VARCHAR},",
      "userid = #{userid,jdbcType=VARCHAR},",
      "source_code = #{sourceCode,jdbcType=VARCHAR},",
      "update_time = sysdate,",  更新时间
      "remark = #{remark,jdbcType=VARCHAR}",
    "where certificate_no = #{certificateNo,jdbcType=INTEGER}"
})
/*根据证件号更新手机号*/
int updateUserPhone(ElectronicInvoiceUser record);