正常的查询应该是这样:SELECT count(0) FROM 表名
结果生成的查询语句变成了这样:select count(0) from (SELECT a.data AS "data", a.explain AS "explain" FROM 表名 a WHERE a.data= ? ORDER BY a.id) tmp_count 。导致查询语句错误报错。
解决办法:
@Column(name="explain", attrName="explain", label="属性单位"),
改为
@Column(name="\"explain\"", attrName="explain", label="属性单位"),