Query对象

Query对象详解

import java.util.Arrays;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import org.junit.Test;

import com.itheima.a_hello.User;
//详解Query对象
public class Query_test {
	@Test
	//Query对象 封装HQL语句的对象
	//Query中封装查询细节api
	public void fun1(){
		//1加载配置
		Configuration  conf = new Configuration().configure();
		//2 根据Configuration 配置信息创建 SessionFactory
		SessionFactory sf = conf.buildSessionFactory();
		//3 获得session
		Session session = sf.openSession();
		//打开事务
		Transaction ts = session.beginTransaction();
		
		//--------------------------------------------------------
		
		Query query = session.createQuery("from com.itheima.a_hello.User ");
		
		//分页 limit index,count;
		
		//指定结果从第几个开始拿
		query.setFirstResult(0);
		//指定拿几个结果
		query.setMaxResults(2);
		
		//query.list() 将hql语句执行,并返回结果(多行)
		List<User> list =  query.list();
		System.out.println(list);
		//uniqueResult 将hql语句执行,并返回结果(一行)
		//User u = (User) query.uniqueResult();
		//System.out.println(u);
		//---------------------------------------------------------
		//提交事务
		ts.commit();
		
		//关闭资源
		session.close();
		sf.close();
	}
}