实体如下:
import com.fasterxml.jackson.annotation.JsonFormat; import com.netmarch.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/