博客系统后台部分,视频是47,48,写入数据库时报错
错误信息如下:
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 'refreshtok0_ where refreshtok0_.id='945613356524371968'' at line 1
postman中的信息:
ide中的写入代码:
数据库中表的信息:
refreshToken类:
@Entity
@Table(name = "tb refresh_token")
public class RefreshToken {
@Id
private String id;
@Column(name = "refresh_token")
private String refreshToken;
@Column(name = "user_id")
private String userId;
@Column(name = "token_key")
private String tokenKey;
@Column(name = "create_time")
private Date createTime;
@Column(name = "update_time")
private Date updateTime;
//省略set、get
}
跟着视频做的,但是报错了,看报错信息,应该时sql查询时出的问题,但是不太清楚具体是哪个
希望做过这个的小伙伴帮忙解答一下,我先继续去对照视频找找看是不是漏了啥/(ㄒoㄒ)/~~
配置一下sql的log输出,看看生成的语句是什么就知道了。另外注意字段不要是关键字,如果是关键字的话,要用'`'包括起来