public void queryCustomerbymerchantId(){ ?????????SessionFactory sf = HibernateUtil.getSessionFactory(); ?????????Session session = sf.getCurrentSession(); ?????????Transaction ts = session.beginTransaction(); ?????????try { ????????Query query=session.createQuery("select c from Customer c join c.merchant m where m.mid=1"); ????????List customer = query.list(); ????????for(int i=0;i<customer.size();i++) ????????{ ?????????Customer customers =(Customer)customer.get(i); ?????????????System.out.println(i+"--"+customers); ????????} ???????????ts.commit(); ???????????????????} catch (HibernateException e) { ?????????// TODO Auto-generated catch block ?????????if(ts != null) ?????????{ ?????????????ts.rollback(); ?????????} ?????????e.printStackTrace(); ?????} ?} ?
public void queryCustomerbyOrderId(){ ?????????SessionFactory sf = HibernateUtil.getSessionFactory(); ?????????Session session = sf.getCurrentSession(); ?????????Transaction ts = session.beginTransaction(); ?// ?????int n; ?// ?????Scanner sc=new Scanner(System.in); ?// ?????n=sc.nextInt(); ?????????try { ????????Query query=session.createQuery("select customer from Order o where ?o.id=1" ); ????????System.out.println(query); ????????List customer = query.list(); ???????????for(int i=0;i<customer.size();i++) ????????{ ?????????Customer customers =(Customer)customer.get(i); ?????????????System.out.println(i+"--"+customers); ????????} ???????????ts.commit(); ???????????????????} catch (HibernateException e) { ?????????// TODO Auto-generated catch block ?????????if(ts != null) ?????????{ ?????????????ts.rollback(); ?????????} ?????????e.printStackTrace(); ?????} ?} ?
hibernate关于多对多映射和多对一的hql查询
原文地址：https://www.cnblogs.com/acefeng/p/9206289.html