package pojo;

import java.util.ArrayList;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class ScopeService {

	public static SessionFactory sessionFactory;
	
	//初始化sessionFactory，创建实例   
    static {   
           
        try {   
               
            //从默认位置读取hibernate.cfg.xml   
            Configuration config = new Configuration().configure();   
            sessionFactory = config.buildSessionFactory();   
               
        } catch (RuntimeException e) {   
               
            e.printStackTrace();   
            throw e;   
               
        }   
           
    }
    
    
    public void printAllUser() {   
        
        Session session = sessionFactory.openSession();   
        Transaction tx = null;   
           
        ArrayList<Scope> userList = new ArrayList<Scope>();   
           
        try {   
               
            tx = session.beginTransaction();   
            Query query = session.createQuery("from User as u order by u.name asc");   
            userList = (ArrayList<Scope>) query.list();   
            tx.commit();   
               
            for (int i = 0; i < userList.size(); i ++) {   
                   
                System.out.println(userList.get(i).getScopeName() );   
                   
            }   
               
        } catch (Exception e) {   
        	
            System.out.println(e.toString());   
               
        } finally {   
               
            session.close();   
               
        }   
           
    }
    
}