解决n+1问题

来源：互联网发布：vs2015编程c语言编辑：程序博客网时间：2024/05/20 19:29

//N+1问题.查询Student信息,如果需要Clazz信息,如果有很多班级的话,就会有很多条查询语句.public void testN1(){Session session = DBUtil.getSession();Transaction tr = session.beginTransaction();Query query = session.createQuery("from Student");List<Student> list = query.list();if(null != list || list.size() > 0){for(Student student:list){System.out.println("--------------------------");System.out.println(student.getStudentName()+":"+student.getClazz().getClazzName());}}tr.commit();DBUtil.closeSession(session);}

//解决N+1问题  --- 强迫左连接(只有一次查询),性能优化问题public void testN(){Session session = DBUtil.getSession();Transaction tr = session.beginTransaction();Query query = session.createQuery("from Student stu left join fetch stu.clazz");List<Object> list = query.list();if(null != list || list.size() > 0){for(Object object:list){Student student = (Student)object;System.out.println(student.getStudentName()+":"+student.getClazz().getClazzName());}}tr.commit();DBUtil.closeSession(session);}

0 0