package org.test.Dao;

import java.util.Iterator;

import org.hibernate.Query;
import org.hibernate.ScrollMode;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.test.hiber.Customer;
import org.test.hiber.HibernateSessionFactory;

public class CustomerDao {

	/**
	 * @param args
	 */

	Session se=null;
	Transaction tr=null;
	public void queryAllCustomer()
	{
		se=HibernateSessionFactory.getSession();
		tr=se.beginTransaction();
		Iterator ite=se.createQuery("from Customer").list().iterator();
		tr.commit();
		Customer customer=null;
		while(ite.hasNext())
		{
			customer=(Customer)ite.next();
			System.out.println(customer.getId()+" "+customer.getCustomerName());
		}
		se.close();
		
	}
	public void query()
	{
		se=HibernateSessionFactory.getSession();
		tr=se.beginTransaction();
		Query q=se.createQuery("from Customer");
		ScrollableResults sr=q.scroll(ScrollMode.SCROLL_INSENSITIVE);//設置滾動的結果集
		while(sr.next())
		{
			System.out.println(((Customer)sr.get(0)).getCustomerName());
		}
		System.out.println("-------------------------------");
		sr.first();
		System.out.println(((Customer)sr.get(0)).getCustomerName());
		sr.next();
		System.out.println(((Customer)sr.get(0)).getCustomerName());
		sr.previous();
		System.out.println(((Customer)sr.get(0)).getCustomerName());
		sr.close();
		tr.commit();
		se.close();
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		CustomerDao cd=new CustomerDao();
		//cd.queryAllCustomer();
		cd.query();
	}

}