cruds.ProjectCrudImplementation.java Source code

Introduction

Here is the source code for cruds.ProjectCrudImplementation.java

Source

/*
 * 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.
 */
package cruds;

import crudsinterface.ProjectCrudInterface;
import crudsinterface.UsersCrudInterface;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import pojos.Projectsforusers;
import pojos.Users;
import seesioncreator.SessionCreation;

/**
 *
 * @author m@pc
 */
public class ProjectCrudImplementation implements ProjectCrudInterface {
    Session sc;

    public ProjectCrudImplementation() {
        sc = SessionCreation.getSessionFactory().openSession();
    }

    @Override
    public ArrayList<Projectsforusers> selectProjects(int id) {
        List<Projectsforusers> projects = new ArrayList<>();
        Criteria criteria = sc.createCriteria(Projectsforusers.class);
        criteria.add(Restrictions.eq("users.userId", id));
        criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
        projects = criteria.list();
        return (ArrayList<Projectsforusers>) projects;
    }

    @Override
    public Projectsforusers selectProject(int id) {
        Projectsforusers p = new Projectsforusers();
        try {
            sc.beginTransaction();
            System.out.println();
            p = (Projectsforusers) sc.get(Projectsforusers.class, id);
            sc.getTransaction().commit();
            System.out.println(p);
        } catch (HibernateException e) {
            e.printStackTrace();
        } finally {
            sc.close();
        }

        return p; //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public boolean insertProject(Projectsforusers c) {
        boolean flag = true;
        try {
            sc.getTransaction().begin();
            sc.saveOrUpdate(c);
            sc.getTransaction().commit();
        } catch (HibernateException ex) {
            sc.getTransaction().rollback();
            ex.printStackTrace();
            flag = false;
        } finally {
            sc.close();
        }
        return flag;
    }

    @Override
    public boolean updateProject(Projectsforusers c, int id) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public boolean deleteProject(int id) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public ArrayList<Projectsforusers> selectLastInterd() {
        System.out.println("in crud mona");
        List<Projectsforusers> projects = new ArrayList<>();
        Session session = SessionCreation.getSessionFactory().openSession();
        int n = 2;
        Criteria count = session.createCriteria(Projectsforusers.class);
        count.setProjection(Projections.rowCount());
        Long total = (Long) count.uniqueResult();
        Criteria criteria = session.createCriteria(Projectsforusers.class);
        criteria.setFirstResult((int) (total - n));
        criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
        criteria.setMaxResults(n);
        projects = criteria.list();
        return (ArrayList<Projectsforusers>) projects;
    }

    @Override
    public ArrayList<Projectsforusers> selectBestProjects() {

        UsersCrudInterface crud = new UsersCrudImplementation();
        ArrayList<Users> usersAll = crud.selectMaxRateUsers();
        List<Projectsforusers> projects = new ArrayList<>();
        for (int i = 0; i < usersAll.size(); i++) {
            Criteria criteria = sc.createCriteria(Projectsforusers.class);
            criteria.add(Restrictions.eq("users.userId", usersAll.get(i).getUserId()));
            projects.addAll(criteria.list());
        }
        return (ArrayList<Projectsforusers>) projects;
    }

    @Override
    public ArrayList<Projectsforusers> selectAllProjects() {
        List<Projectsforusers> projects = new ArrayList<>();
        Criteria criteria = sc.createCriteria(Projectsforusers.class);
        projects = criteria.list();

        return (ArrayList<Projectsforusers>) projects;
    }

}