实体如下:
importcom.fasterxml.jackson.annotation.JsonFormat;importcom.netmarch.web.bean.PagesStatic;importlombok.AllArgsConstructor;importlombok.Builder;importlombok.Data;importlombok.NoArgsConstructor;importorg.springframework.format.annotation.DateTimeFormat;importjavax.persistence.Column;importjavax.persistence.GeneratedValue;importjavax.persistence.Id;importjavax.persistence.Transient;importjava.time.LocalDateTime;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder/***
* app图标*/@JsonFormatpublic classApiCertificate{
@Id
@GeneratedValue(generator= "JDBC")
@TransientprivateInteger id;privateString url;
@Column(name= "`order`")privateInteger order;privateInteger creatorId;
@DateTimeFormat(pattern= "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern= "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")privateLocalDateTime 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 versionfor 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