sql连接查询与hibernate连接查询

sql:

交叉连接

SELECT * FROM t_customer c,t_linkman l ;

内连接

SELECT * FROM t_customer c,t_linkman l WHERE c.cid=l.clid;

隐式内连接

SELECT * FROM t_customer c INNER JOIN t_linkman  l ON c.cid=l.clid;

左外连接

SELECT * FROM t_customer c LEFT JOIN t_linkman l ON c.cid=l.clid;

右外连接

SELECT * FROM t_customer c RIGHT JOIN t_linkman l ON c.cid=l.clid;

hibernate:

交叉连接

List<Object[]> list=session.createQuery("select c from Customer c,LinkMan l).list();

内连接

List<Object[]> list=session.createQuery("select c from Customer c inner Join c.setLinkMan").list();

左外连接

List<Object[]> list=session.createQuery("select c from Customer c left Join  c.setLinkMan").list();

右外连接

List<Object[]> list=session.createQuery("select c from Customer c outer Join  c.setLinkMan").list();

迫切左外连接

List<Customer> list=session.createQuery("select distinct c from Customer c left Join fetch c.setLinkMan").list();

迫切内连接

List<Customer> list=session.createQuery("select distinct c from Customer c inner Join fetch c.setLinkMan").list();