package com.crystal.hibernate;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;


public class UserManager
{


 public void addUser(User u)
    {
        Transaction tx = null;
        Session session = InitSessionFactory.getInstance().getCurrentSession();
        try {
            tx = session.beginTransaction();
            session.save(u);
            tx.commit();
        }
        catch (HibernateException e) {
            e.printStackTrace();
            if (tx != null && tx.isActive()) {
                tx.rollback();
            }
        }
    }
 
     public int getUser(String username)
    {
        Transaction tx = null;
        List list = null;

        Session session = InitSessionFactory.getInstance().getCurrentSession();
        try {
            tx = session.beginTransaction();
            list =
                session.createQuery("SELECT sname FROM User as u WHERE sname = :userid").setParameter("userid", username)
                    .list();
            tx.commit();             	
        }
        catch (HibernateException e) {
            e.printStackTrace();
            if (tx != null && tx.isActive()) {
                tx.rollback();
            }
        }
        if(list.isEmpty()==true)
        {
        	return 0;       	
        }
        else
        {
        return 1;
        }
    }
}