类级别的查询
延迟加载
@Test
//get方法,立即加载,执行方式时立即发送sql语句查询结果
public void test(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Customer customer = session.get(Customer.class, 1);
System.out.println(customer);
tx.commit();
}
@Test
//load方法 默认延迟加载 在执行时 不发送任何sql 或先返回一个对象,在使用该对象时,才执行查询
//可以在配置文件中的class属性中做修改 默认load = true 可以改为false 立即加载
//<class name="Customer" table="cst_customer" lazy="false">
public void test2(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Customer customer = session.load(Customer.class, 1);
System.out.println(customer);
tx.commit();
}
关联级别的查询---多表查询,
@Test
//load方法 默认延迟加载 在执行时 不发送任何sql 或先返回一个对象,在使用该对象时,才执行查询
//可以在配置文件中的class属性中做修改 默认load = true 可以改为false 立即加载
//<class name="Customer" table="cst_customer" lazy="false">
public void test2(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Customer customer = session.load(Customer.class, 1);
System.out.println(customer);
tx.commit();
}
@Test
//关联级别 延迟加载 && 加载策略
//fetch select 使用单表查询
//lazy true 使用时才加载
public void test3(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
//~~~~~~
Customer customer = session.get(Customer.class, 2);
Set<LinkMan> linkMans = customer.getLinkMans();
System.out.println(linkMans);
tx.commit();
}
@Test
//关联级别 延迟加载 && 加载策略
//fetch select 使用单表查询
//lazy false 立即加载 测试过程在hiberbate新版本5.4中 都是立即加载
public void test4(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
//~~~~~~
Customer customer = session.get(Customer.class, 2);
Set<LinkMan> linkMans = customer.getLinkMans();
System.out.println(linkMans);
tx.commit();
}
@Test
//关联级别 延迟加载 && 加载策略
//fetch select 使用单表查询
//lazy extra 及其懒惰 与懒加载效果基本一致,如果只获得集合的size 只查询集合的size select count
public void test5(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
//~~~~~~
Customer customer = session.get(Customer.class, 2);
Set<LinkMan> linkMans = customer.getLinkMans();
System.out.println(linkMans.size());
System.out.println(linkMans);
tx.commit();
}
@Test
//关联级别 延迟加载 && 加载策略
//fetch join 多表查询
//lazy true|false|extra 失效 立即加载
public void test6(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
//~~~~~~
Customer customer = session.get(Customer.class, 2);
Set<LinkMan> linkMans = customer.getLinkMans();
System.out.println(linkMans.size());
System.out.println(linkMans);
tx.commit();
}
@Test
//关联级别 延迟加载 && 加载策略
//fetch subselect 子查询
//lazy true
public void test7(){
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
//~~~~~~
String hql = "from Customer";
Query query = session.createQuery(hql);
List<Customer> list =query.list();
for (Customer c:list){
System.out.println(c);
Set<LinkMan> linkMans = c.getLinkMans();
System.out.println(linkMans.size());
System.out.println(linkMans);
}
tx.commit();
}
结论:为了提高效率 ,fetch的选择应该选择默认值select lazy的属性 应该选择true 也是默认值
no-session 问题解决:扩大session的作用范围 ,使用filter过滤器