• mybatis/tk mybatis下实体字段是关键字/保留字,执行报错


    实体如下:

    import com.fasterxml.jackson.annotation.JsonFormat;
    import com.xxx.web.bean.PagesStatic;
    import lombok.AllArgsConstructor;
    import lombok.Builder;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    import org.springframework.format.annotation.DateTimeFormat;
    
    import javax.persistence.Column;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    import javax.persistence.Transient;
    import java.time.LocalDateTime;
    
    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @Builder
    /***
     * app图标
     */
    @JsonFormat
    public class ApiCertificate{
        @Id
        @GeneratedValue(generator = "JDBC")
        @Transient
        private Integer id;
    
        private String url;
    
        @Column(name = "`order`")
        private Integer order;
    
        private Integer creatorId;
    
        @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
        @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
        private LocalDateTime createTime;
    }

    tk mybatis使用动态sql语句的insert方法报错:

    ### SQL: INSERT INTO api_certificate  ( url,order,creator_id,create_time ) VALUES( ?,?,?,? )
    ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,creator_id,create_time ) VALUES( 'certificate/6c38dea0-3450-4bdf-8cd4-f42b' at line 1
    ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,creator_id,create_time ) VALUES( 'certificate/6c38dea0-3450-4bdf-8cd4-f42b' at line 1
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

    解决方法,在sql关键字字段上加@Column注解,注意不同数据下关键字转义字符的不同,以上是mysql

    springmvc下可以通过xml文件配置。可以到网上去搜 mybatis beginningDelimiter endingDelimiter

    参考来源:https://vladmihalcea.com/escape-sql-reserved-keywords-jpa-hibernate/

  • 相关阅读:
    redis---01
    mysql优化-----索引覆盖
    mysql优化-------Myisam与innodb引擎,索引文件的区别
    mysql优化-----多列索引的左前缀规则
    mysql---列的选取原则
    boogo08---中间件
    goroutine pool,WaitGroup,chan 示例
    Android开发 |常见的内存泄漏问题及解决办法
    Android中FragmentPagerAdapter对Fragment的缓存(二)
    Android中FragmentPagerAdapter对Fragment的缓存(一)
  • 原文地址:https://www.cnblogs.com/passedbylove/p/11686079.html
Copyright © 2020-2023  润新知