15、Hibernate的原生sql查询,优化Hibernate的查询效率-优快云博客

本文展示了如何使用Hibernate框架执行原生SQL查询，并通过三个不同示例演示了如何映射查询结果到Java对象，包括直接使用实体类、组合多个实体类以及使用自定义DTO的方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class TestSQL {
    
    @Test
    public void test01() {
        Session session = null;
        try {
            session = HibernateUtil.openSession();
            List<Student> stus = session.createSQLQuery("select * from t_stu where name like ?")
                    .addEntity(Student.class)
                    .setParameter(0, "%孔%")    
                    .setFirstResult(0).setMaxResults(10)
                    .list();
            for(Student stu:stus) {
                System.out.println(stu.getName());
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            HibernateUtil.close(session);
        }
    }
    
    @Test
    public void test02() {
        Session session = null;
        try {
            session = HibernateUtil.openSession();
            List<Object[]> stus = session.createSQLQuery("select {stu.*},{cla.*},{spe.*} from " +
                    "t_stu stu left join t_classroom cla on(stu.cid=cla.id) " +
                    "left join t_special spe on(spe.id=cla.spe_id) where stu.name like ?")
                    .addEntity("stu",Student.class)
                    .addEntity("cla",Classroom.class)
                    .addEntity("spe",Special.class)
                    .setParameter(0, "%孔%")    
                    .setFirstResult(0).setMaxResults(10)
                    .list();
            Student stu = null;
            Classroom cla = null;
            Special spe = null;
            List<StuDto> list = new ArrayList<StuDto>();
            for(Object[] obj:stus) {
                stu = (Student)obj[0];
                cla = (Classroom)obj[1];
                spe = (Special)obj[2];
                list.add(new StuDto(stu, cla, spe));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            HibernateUtil.close(session);
        }
    }
    
    @Test
    public void test03() {
        Session session = null;
        try {
            session = HibernateUtil.openSession();
            List<StudentDto> stus = session.createSQLQuery("select stu.id as sid,stu.name as sname," +
                    "stu.sex as sex,cla.name as cname,spe.name as spename from " +
                    "t_stu stu left join t_classroom cla on(stu.cid=cla.id) " +
                    "left join t_special spe on(spe.id=cla.spe_id) where stu.name like ?")
                    .setResultTransformer(Transformers.aliasToBean(StudentDto.class))
                    .setParameter(0, "%孔%")    
                    .setFirstResult(0).setMaxResults(10)
                    .list();
            for(StudentDto sd:stus) {
                System.out.println(sd);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            HibernateUtil.close(session);
        }
    }
    
    
    
}