Hibernate Criteria 关联查询(inner join 与 left join)

    1. --------------------------------------------------------------------Dao(left join) ---------------------------------------------------------
    2.  
    3. [java] view plaincopy
       
    1. /**
    2. * <Criteria查询>
    3. *
    4. * @return List
    5. */
    6. @SuppressWarnings("unchecked")
    7. public List<User> findByCriteria()
    8. {
    9. return (List)ht.execute(new HibernateCallback()
    10. {
    11. public Object doInHibernate(Session session)
    12. throws HibernateException,
    13. SQLException
    14. {
    15. Criteria criteria = session.createCriteria(User.class);
    16. criteria.add(Restrictions.eq("password", "123"));
    17. // 关联
    18. criteria.setFetchMode("dept", org.hibernate.FetchMode.JOIN);
    19. return criteria.list();
    20. }
    21. });
    22. }

    1. --------------------------------------------------------------------Dao(inner join) ---------------------------------------------------------
    2. [java] view plaincopy
       
    1. /**
    2. * <Criteria查询>
    3. *
    4. * @return List
    5. */
    6. @SuppressWarnings("unchecked")
    7. public List<User> findByCriteria()
    8. {
    9. return (List)ht.execute(new HibernateCallback()
    10. {
    11. public Object doInHibernate(Session session)
    12. throws HibernateException,
    13. SQLException
    14. {
    15. Criteria criteria = session.createCriteria(User.class);
    16. criteria.add(Restrictions.eq("password", "123"));
    17. // 关联
    18. criteria = criteria.createCriteria(&qu
50000+
5万行代码练就真实本领
17年
创办于2008年老牌培训机构
1000+
合作企业
98%
就业率

联系我们

电话咨询

0532-85025005

扫码添加微信