【老鼠路】SQLQuery

package com.gyf.hibernate.test;


import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;

import com.gyf.hibernate.domain.User;
import com.gyf.hibernate.uitls.HibernateUtils;

/**
 SQLQuery
SQLQuery:使用原生的SQL语句查询
并不是所有sql都能转成hql
 */
public class Lesson11 {

    @Test
    public void test1(){
        //获取session对象
        Session session =  HibernateUtils.openSession();
    
        //创建SQLQuery查询对象
        SQLQuery query = session.createSQLQuery("select * from t_user");

        //返回数据封装到集合，集合装的数组
        List<Object[]> list = query.list();
        for(Object[] objs : list){
            for(Object o : objs){
                System.out.println(o);
            }
            System.out.println("-------------------");
        }
        
        //关闭会话
        session.close();
        
    }
    
}