更新时间:2022-10-02 22:56:39
HQL语句本身和SQL一样不区分大小写, 但其中的类名, 属性名, (绑定参数的)数据区分大小写.
如果类有子类, 会连同子类一起查询, 不论子类是否和父类或者子类之间是否映射的同一张表.
=, <>, >, <, >=, <=, [not] in, is [not] null, [not] like, [not] between ... and..
String dmlHql = "update User set sex='Female' where id='2' ";
Query query = session.createQuery(dmlHql);
int changerow = query.execuyeUpdate();
dmlHql = "delete User where id='6' ";
query = session.createQuery(dmlHql);
changerow= query.execuyeUpdate();
.... //commit ...
支持inner join, left outer join, right outer join , full join
支持子查询
本文转自linzheng 51CTO博客,原文链接:http://blog.51cto.com/linzheng/1080808