import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.epam.edu.jtc.service.HibernateUtilService;
import com.epam.edu.jtc.dto.LoginDTOForm;

//@Repository
public class AuthorizationService {
		
	//@Autowired
    private     SessionFactory sessionFactory; 
 
     
	public   List checkAuthorization(LoginDTOForm userV) {
		 
		SessionFactory sf = HibernateUtilService.getSessionFactory();
		Session session = sf.getCurrentSession();
		List userList = session
				.createQuery(
						"from User u where u.login='" + userV.getLoginField()
								+ "' and u.password='"
								+ userV.getPasswordField() + "'").list();

		session.close();
	 
		return userList;

	}
	public   SessionFactory getSessionFactory() {
		return sessionFactory;
	}
	public   void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	
	
	
	
}

import org.apache.log4j.Logger;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtilService {

	private static final SessionFactory sessionFactory = buildSessionFactory();
	 private static final Logger log = Logger.getLogger(HibernateUtilService.class);
	// @SuppressWarnings("deprecation")
	private static SessionFactory buildSessionFactory() {
		try {
			 
			return (SessionFactory) new Configuration().configure( )
					.buildSessionFactory();
			
		} catch (Throwable ex) {
			 
			 log.error("Initial SessionFactory creation failed" );
			throw new ExceptionInInitializerError(ex);
		}
	}

	public static SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public static void shutdown() {
		// Close caches and connection pools
		getSessionFactory().close();
	}

}