backend.api.View.java Source code

Introduction

Here is the source code for backend.api.View.java

Source

package backend.api;

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, 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;
import org.hibernate.cfg.Configuration;

import backend.core.SessionFactoryManager;
import backend.core.model.Groups;
import backend.core.model.Users;

/**
 *
 * @author Andrzej
 */
public class View {

    private static SessionFactory sf = SessionFactoryManager.INSTANCE.getSessionFactory();

    public boolean checkAuthorization(String name, String password) // ok
    {
        Session s = sf.openSession();
        try {

            Query q = s.createQuery(
                    "select u from Users u where u.name='" + name + "' and u.password='" + password + "'");
            List<Users> result = q.list();
            if (result.isEmpty() || result.size() == 0)
                return false;
            return true;

        } catch (Exception e) {
            e.printStackTrace();
            return false;
        } finally {
            s.close();
        }
    }

    public List<Users> getUsers(int IdGroup) //ok
    {
        Session s = SessionFactoryManager.INSTANCE.getSessionFactory().openSession();
        try {
            String hql = "select new backend.core.model.Users(u.idusers, u.name, u.surname, u.password, u.salt, u.hired, u.last_login) "
                    + "from Users u join u.Groups g where g.idgroups in (:idGroup)";
            Query q = s.createQuery(hql);
            q.setParameter("idGroup", IdGroup);

            List<Users> result = q.list();

            if (result.isEmpty() || result.size() == 0)
                return null;
            return result;

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

    public List<Users> getAllUsers() // ok
    {
        Session s = sf.openSession();
        try {

            Query query = s.createQuery("select u from Users u");

            List<Users> users = query.list();
            return users;

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