Hibernate的HQL查询

OID查询

• 使用get方法

Customer customer = session.get(Customer.class,11);

• 使用load方法

Customer customer = session.load(Customer.class,11);

对象导航检索

根据已经查询到的对象， 获得其关联的对象的一种查询语言
例：

LinkMan linkMan = session.get(LinkMan.class,1l);
Customer customer = linkMan.getCustomer();

Customer customer = session.get(Customer.class,2l);
Set<LinkMan> linkMans = customer.getLinkMans();

HQL检索

HQL：Hibernate Query Language 一种面向对象的查询语言，通过session.createQuery()

• HQL简单查询所有

Query query = session.createQuery("from Customer")
List<Customer> list = query.list();

• HQL排序查询

// 设置降序排序 升序使用asc 降序使用desc
List<Customer> list = session.createQuery("from Customer order by cust_id desc").list();

• HQL条件查询

Query query = session.createQuery("from Customer where cust_source = ? and cust_name like ?");
query.setParameter(0,"XXX");
query.setParameter(1,"XXX");
List<Customer> list = query.list();

• HQL投影查询

//1. 查询多个属性
List<Object[]> list = session.createQuery("select c.cust_name,c.cust_source from Customer c").list();
//2. 查询多个属性，封装到对象中
List<Customer> list = session.creteQuery("select new Customer(cust_name,cust_source) from Customer").list();

• HQL分页查询

Query query = session.createQuery("from LinkMan");
query.setFirstResult(20);
query.setMaxResults(10);
List<LinkMan> list = query.list();

• HQL分组统计查询

// 聚合函数的使用：count(),max(),min(),avg(),sum()
		Object object = session.createQuery("select count(*) from Customer").uniqueResult();
		System.out.println(object);
		// 分组统计：
		List<Object[]> list = session.createQuery("select cust_source,count(*) from Customer group by cust_source").list();

##多表查询
sql的多表查询：

• 连接查询
  交叉连接：笛卡尔积
  select * from A,B;

• 内连接 :inner join (inner 可以省略)

1. 隐式内连接：
   select * from A,B where A.id = B.aid;
2. 显示内连接：
   select * from A inner join B on A.id = B.aid;

• 外连接 :

1. 左外连接:left outer join(outer 可以省略)
   select * from A left outer join B on A.id= B.aid;
2. 右外连接:right outer join(outer 可以省略)
   select * from A right outer join B on A.id = B.aid;

• 子查询

HQL的多表连接查询

• 交叉连接
• 内连接

1. 隐式内连接

 from  Customer A,B where A.id = B.aid

2. 显示内连接

from Customer c inner join c.linkMans

3. 迫切内连接

from Customer c inner join fetch c.linkMans

• 外连接

3. 左外连接
4. 右外连接
   3. 迫切左外连接