代码如下:
String hql = "select a.ac01sno," +
" a.aac001," +
" a.aab001," +
" a.aab003," +
" a.aac022," +
" a.aac003," +
" a.aac004," +
" a.aac005," +
" a.aac006," +
" a.aac007," +
" a.aac008," +
" a.aae001," +
" a.aae002," +
" a.aae003," +
" a.aae004," +
" a.aae005," +
" a.aac014," +
" a.aac015," +
" a.aac016," +
" a.aac017," +
" a.aac018," +
" a.aac019," +
" a.aac020," +
" a.aac021," +
" a.aae200," +
" a.prseno," +
" a.aac023," +
" a.aac024," +
" a.aac025," +
" a.aac002," +
" a.aac009," +
" a.aac026 from Ac01 a left join Kc03 c on a.ac01sno = c.ac01sno where a.aab003='"+orgCode+"' and a.AAC015='"+aac015+"' and c.eke048="+confirmStatus;
List<HashMap<String, T>> list = (List<HashMap<String, T>>)session.createQuery(hql).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
程序运行后报org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 582.......
原因:hql 不支持 left join on 要改成where 就可以了
注意hql语句区分对象和字段的大小写
参考博客:https://blog.csdn.net/zxf1242652895/article/details/53212708