Hibernate的SQLQuery的用法

Configuration configuration = new Configuration();
        configuration.configure();

        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();

        org.hibernate.SQLQuery query = (org.hibernate.SQLQuery) session.createSQLQuery("select  * from salarydb.department where department_id=?");
        //和sql用法一样
        query.setParameter(1,"1");
        //返回值为list  list里面是二维数组
        List<Object[]> list = query.list();
        for (Object[] objs: list) {
            System.out.println("---------------");
            for (Object obj:objs
                 ) {
                System.out.println(obj);
            }
        }
        session.close();
        sessionFactory.close();
    }

结果为