package com;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;
import org.hibernate.Transaction;

public class UserInfoDAO {
    public void addUser(UserInfo user){
    	Session session=HibernateSessionFactory.currentSession();
    	Transaction tran=session.beginTransaction();
    	
    	session.save(user);
    	tran.commit();
    	HibernateSessionFactory.closeSession();
    }
    public UserInfo findUser(){
    	Session session=HibernateSessionFactory.currentSession();
    	UserInfo user=(UserInfo) session.get(UserInfo.class,"ff8080810f40da52010f40da55750001");
    	return user;
    }
    public List scrollFind(){
    	Session session=HibernateSessionFactory.currentSession();
    	Query q=session.createQuery("select user.userName from UserInfo as user");
    	List firstNameOfPage=null;
    	ScrollableResults results=q.scroll();
    	if(results.first()){
    		firstNameOfPage=new ArrayList();
    		do{
    			String username=results.getString(0);
    			firstNameOfPage.add(username);
    		}while(results.scroll(2));
    	}
    	return firstNameOfPage;
    }
    public void updateUser(UserInfo user){
    	Session session=HibernateSessionFactory.currentSession();
    	Transaction tran=session.beginTransaction();
    	session.update(user);
    	tran.commit();
    	HibernateSessionFactory.closeSession();
    }
    public UserInfo find(String id){
    	Session session=HibernateSessionFactory.currentSession();
    	Transaction tran=session.beginTransaction();
    	Query query=session.createQuery("from UserInfo where id='"+id+"'");
    	UserInfo user=null;
    	List list=query.list();
    	if(list!=null && list.size()>0){
    		user=(UserInfo) list.get(0);
    	}
    	tran.commit();
    	HibernateSessionFactory.closeSession();
    	return user;
    }
    public void deleteUser(UserInfo user){
    	Session session=HibernateSessionFactory.currentSession();
    	Transaction tran=session.beginTransaction();
    	session.delete(user);
    	tran.commit();
    	HibernateSessionFactory.closeSession();
    }
}