MyBatis columns mapping with MySQL Keywords and Reserved Words
@Column(name = "`year`")
private String year;
@Column(name = "`year_month`")
private String yearMonth;
I annotated the year and yearMonth fields with the @Column annotation, but the query result is null.
I want to handle compatibility in DefaultResultSetHandler. Any suggestions?
the below sql is mybatis log.
mybatis
3.5.14
SELECT creation_date, created_by, last_update_date, last_updated_by, object_version_number, id, request_week, `year`, `year_month`
FROM dppcm_po_no_import
WHERE ((po_no IN ('305743571', '305743990', '305777642', '305778006', '305778007', '305778204')));