/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

/**
 *
 * @author developer
 */
public class TestDAO {

    public SsoUser getSsoUserById(String id) {

        try {
            SessionFactory sf = NewHibernateUtil.getSessionFactory();
            Session session = sf.openSession();
            Query query = session.createQuery("select ssou from SsoUser ssou");
			//Query query = session.createQuery("from SsoUser");

            query.setMaxResults(1);

            List<SsoUser> ssouserlist = query.list();

            if (ssouserlist != null && ssouserlist.size() > 0) {
                return ssouserlist.get(0);
            } else {
                return null;
            }

        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
}